Assuming that A2:C100 contains the data, and that D2 contains the first
formula which returns the number of unique entries, try the following
formula which needs to be confirmed with CONTROL+SHIFT+ENTER...

E2, copied down:

=IF(ROWS(E$2:E2)<=$D$2,INDEX(A$2:A$100,SMALL(IF(B$ 2:B$1000,IF(C$2:C$100<
1,IF(MATCH(A$2:A$100,A$2:A$100,0)=ROW(A$2:A$100 )-ROW(A$2)+1,ROW(A$2:A$10
0)-ROW(A$2)+1))),ROWS(E$2:E2))),"")

Hope this helps!

In article ,
guneet_ahuja
wrote:

hi,

well u gave me an excellent formula to count the unique values,

but now please give an formula which will give a unique list i.e with
same condition as above i want the unique list of column A & not just
the count of these unique values.

thanks & regards