I have duplicate personnel numbers in a column. How do I quickly get rid of the duplicates?
B bea Jan 24, 2005 #1 I have duplicate personnel numbers in a column. How do I quickly get rid of the duplicates?
D David McRitchie Jan 24, 2005 #2 Hi Bea, You can hide them with a filter, Debra Dalgleish has pages on filters at http://www.contextures.com. Chip Pearson has some pages on dealing with duplicates, check his topic.htm index http://www.cpearson.com/excel/topic.htm
Hi Bea, You can hide them with a filter, Debra Dalgleish has pages on filters at http://www.contextures.com. Chip Pearson has some pages on dealing with duplicates, check his topic.htm index http://www.cpearson.com/excel/topic.htm
