delete duplicate in a list

[jaya]

How can I delete duplicate names in a column.
Thanks for your help

 

[Norman Jones]

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

 

[Norman Jones]

Hi Jaya,

The three suggestions were intended as alternative options rather than
sequential steps.

Hopefully this was apparent but, just in case, ,,,