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...
[TABLE="width: 163"]
<TBODY>[TR]
[TD]SE[/TD]
[TD]Name[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]D[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]D[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]G[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]E[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]E[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]K[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]K[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]I[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]K[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]K[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]B[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]B[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]B[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]B[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]B[/TD]
[TD]A[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]

 

[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