Try This in Column B
=IF(COUNTIF($A$1:$A$100,A1)=COUNTIF(A1:A100,A1),A1 ," ")

"Khoshravan" wrote:

I am trying to use the "list unique" instructions given by xldynamic given in
the following link:
http://www.xldynamic.com/source/xld.xlFAQ0021.html
Its instructions are as follows:
A1:A100 are the input data, and we want to find the unique list of these data
B1=IF(COUNTIF($A$1:A1,A1)=1,ROW(A1),"") This givens the row number of
unique entries and works fine
C1=SMALL(IF($B$1:$B$100="","",ROW($B$1:$B$100)),RO W(B1)) an array formula,
and my data it returns 1 for all columns which is strange
D1=IF(ISNUMBER(C1),INDEX(A:A,C1),"")) supposed to give the unique list but
in my case only gives the first entry in all cells.

I think something is wrong in C1 formula.
Any comment is welcomed.

--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan