unique list

[Guest]

ColumnA ColumnB
g g
d d
f f
a a
g h
h
h
a
f

I have a list of none sorted data in column A and I wish column B to list
the unique values as shown. Is there a way of doing this without using
'advanced filter' ? I've tried using LOOKUP and MATCH functions, but can't
see a way of doing it. Any help would be appreciated.

Rgds

 

[Gary Brown]

Check out Chip Pearson's web site...
http://www.cpearson.com/excel/duplicat.htm#CountingUnique
About half way down the page is "Counting Unique Entries
In A Range"
HTH,
Gary Brown

 

[Frank Kabel]

Hi
in B1 enter the array formula:
INDEX($A$1:$A$10,MATCH(1,COUNTIF($A$1:$A$10,$A$1:$A$10),0))

and in B1 enter the array formula:
INDEX($A$1:$A$10,MATCH(1,COUNTIF($A$1:$A$10,$A$1:$A$10)*(COUNTIF
(B$1:B1,$A$1:$A$10)=0),0))
and copy this down as far as needed

 

[Aladin Akyurek]

See my contrib in:

http://www.mrexcel.com/board2/viewtopic.php?t=104177&highlight=unique+list

 

[icestationzbra]

go over to www.contextures.com. from the Files link, locate and downloa
a file called "ExtractUnique.xls". it depicts a nice way of doing wha
you are trying to accomplish

 

[Aladin Akyurek]

Why don't also try the formula system the link I quoted describes?