unique values of a column

[Guest]

hi

how can i get the unique values of a column in an array?
thanks in advance

 

[Alan]

I think Advanced Filter will do what you want, there is an excellent
tutorial here from Debra Dalgleish
http://www.contextures.com/xladvfilter01.html
Regards

 

[mzehr]

Hi,
Additionally check out Chip Pearson's website at:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

 

[Guest]

i wanted to have it in an array... but this is using
advanced filters

 

[Aladin Akyurek]

If you're looking for a formula system, see:

http://www.mrexcel.com/board2/viewtopic.php?t=105230&highlight=distinct