Duplicates Value

Thomas · Dec 1, 2003

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

Ron de Bruin · Dec 1, 2003

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