How can I delete duplicate names in a column. Thanks for your help
N Norman Jones Oct 21, 2005 #2 Hi Jaya, (1) Sort the column (2) Use Advanced Filter, selecting the Unique option (3) use a formula approach. for example see: http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates
Hi Jaya, (1) Sort the column (2) Use Advanced Filter, selecting the Unique option (3) use a formula approach. for example see: http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates
N Norman Jones Oct 21, 2005 #3 Hi Jaya, The three suggestions were intended as alternative options rather than sequential steps. Hopefully this was apparent but, just in case, ,,,
Hi Jaya, The three suggestions were intended as alternative options rather than sequential steps. Hopefully this was apparent but, just in case, ,,,