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/duplic...gingDuplicates


---
Regards,
Norman



"jaya" <jayap@wanadoo.fr> wrote in message
news:43588faa$0$17220$8fcfb975@news.wanadoo.fr...
> How can I delete duplicate names in a column.
> Thanks for your help
>

[Norman Jones]

Hi Jaya,

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

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

---
Regards,
Norman



"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:eRgY8xg1FHA.1028@TK2MSFTNGP12.phx.gbl...
> 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/duplic...gingDuplicates
>
>
> ---
> Regards,
> Norman
>
>
>
> "jaya" <jayap@wanadoo.fr> wrote in message
> news:43588faa$0$17220$8fcfb975@news.wanadoo.fr...
>> How can I delete duplicate names in a column.
>> Thanks for your help
>>
>
>