Extracting Unique Records in a column

[Baskar]

Dear Friends,

A	B
12	AP
12	AP
13	CH
1	CH
2	CH
15	CH
2	AP

<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>

I have a scenerio where to extract unique records in a column on condition base. I have managed to
find unique base using {=INDEX($K$2:$K$8,MATCH(0,COUNTIF($C$1:C1,$A$2:$A$8),0))}.

To Find Unique base on condition I have tried {=INDEX($K$2:$K$8,MATCH(0,COUNTIFs($C$1:C1,$A$2:$A$8,$B$2:$B$8,"CH"),0))} but didn't worked.


Kindly Guide me where I went wrong.

 

[Andrew Poulsom]

Try:

=INDEX(A$2:A$8,SMALL(IF(FREQUENCY(IF(B$2:B$8="CH",MATCH(A$2:A$8,A$2:A$8,0)),ROW(A$2:A$8)-ROW(A$2)+1),ROW(A$2:A$8)-ROW(A$2)+1),ROWS(C$2:C2)))

confirmed with Ctrl+Shift+Enter.

 

[Baskar]

Thanks, It is working.

May I know why it doesn't work in my formula?

 

[Andrew Poulsom]

Your COUNTIFS formula is syntactically incorrect. The criteria ranges don't have the same number of rows.