Hi omnibrown

Use Advanced filter
http://www.contextures.com/xladvfilter01.html#FilterUR


--
Regards Ron de Bruin
http://www.rondebruin.nl


"omnibrown" wrote in message
...

Sheet 1 Col A has a list of text values, the list has cells with the
same value repeated. On sheet 2 col A I want the list of unique values
from sheet 1 col A. Easy?


--
omnibrown
------------------------------------------------------------------------
omnibrown's Profile: http://www.excelforum.com/member.php...o&userid=30409
View this thread: http://www.excelforum.com/showthread...hreadid=500776