I need URGENT Help

[Ibrarbutt]

[TABLE="class: grid, width: 100, align: center"]
<tbody>[TR]
[TD]Group 1[/TD]
[TD]P
[/TD]
[/TR]
[TR]
[TD]Group 1<strike></strike>
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]Group 2
[/TD]
[TD]
P[/TD]
[/TR]
[TR]
[TD]Group 3[/TD]
[TD]
A[/TD]
[/TR]
[TR]
[TD]Group 3[/TD]
[TD]
A[/TD]
[/TR]
[TR]
[TD]Group 1[/TD]
[TD]
P[/TD]
[/TR]
[TR]
[TD]Group 2[/TD]
[TD]
A[/TD]
[/TR]
[TR]
[TD]Group 3[/TD]
[TD]
P[/TD]
[/TR]
[TR]
[TD]Group 2[/TD]
[TD]
P[/TD]
[/TR]
[TR]
[TD]Group 1[/TD]
[TD]
A[/TD]
[/TR]
</tbody>[/TABLE]
I need Results, i have 1000 rows for 15 groups

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Group No
[/TD]
[TD]Count(P)
[/TD]
[TD]Count(A)[/TD]
[/TR]
[TR]
[TD]
Group 1[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]
Group 2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
Group 3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Group 1 Counts (A) Count
Group 2
Group 3

 

[James006]

Just Insert a Pivot Table ... (less than 5 seconds ... it's done ...)

 

[Ibrarbutt]

Pivot Table is not working, as the second col, i have almost 35.

 

[AlanY]

try

Book1
	A	B	C	D	E	F
1	Group 1	P		Group No	P	A
2	Group 1	A		Group 1	2	0
3	Group 2	P		Group 2	2	0
4	Group 3	A		Group 3	1	0
5	Group 3	A
6	Group 1	P
7	Group 2	A
8	Group 3	P
9	Group 2	P
10	Group 1	A
Sheet2

Cell Formulas
Range	Formula
E2	=COUNTIFS(A:A,$D2,B:B,E$1)