Unique Count formula

[Md Ziayul Haque]

Hi...
Can anyone please help....for unique count in excel with this below parameters... I want to know If A has many times but out will come a has two uniqe code. output will come :- A has two unique code D & B then unique count comes 2, HOW....please help...thanks...

SE	Name	Code
A	C	D
A	C	D
A	C	D
A	A	B
A	A	B
A	A	B
A	A	B
B	D	C
B	D	C
B	F	F
B	F	F
B	F	F
B	G	G
C	E	E
C	E	E
C	K	J
C	K	L
D	I	H
D	H	I
D	J	K
D	J	K
D	J	K
D	K	M
D	K	M
E	B	A
E	B	A
E	B	A
E	B	A
E	B	A

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

 

[Akashwani]

Hi, welcome to MrExcel.

Does this work for you?.....

Excel Workbook
	A	B	C	D	E	F	G	H
1	SE	Name	Code		Helper		SE Criteria	Count
2	A	C	D		1		A	2
3	A	C	D		0		B	3
4	A	C	D		0		C	3
5	A	A	B		1		D	4
6	A	A	B		0		E	1
7	A	A	B		0
8	A	A	B		0
9	B	D	C		1
10	B	D	C		0
11	B	F	F		1
12	B	F	F		0
13	B	F	F		0
14	B	G	G		1
15	C	E	E		1
16	C	E	E		0
17	C	K	J		1
18	C	K	L		1
19	D	I	H		1
20	D	H	I		1
21	D	J	K		1
22	D	J	K		0
23	D	J	K		0
24	D	K	M		1
25	D	K	M		0
26	E	B	A		1
27	E	B	A		0
28	E	B	A		0
29	E	B	A		0
30	E	B	A		0
Sheet4

The formulas need to be copied down as far as is required and the ranges will need to be adjusted to suit.
I found the solution here...
Excel Count Unique Values

I hope this helps.

Good luck.

Ak