T Thomas Dec 1, 2003 #1 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
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
R Ron de Bruin Dec 1, 2003 #2 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
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
