Hi Thomas

One way is to use Advanced filter to extract a list of unique items
http://www.contextures.com/xladvfilter01.html#FilterUR

Or Check out this site
http://www.cpearson.com/excel/duplicat.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Thomas" wrote in message ...

I have a range of text values from A1:A1684, I would like
to find the distinct cell values in the list?

Thank You,

Thomas