Getting rid of duplicates

[nycnights]

I am need of some assistance. In one column I have over 500 names and some most are duplicated. Is there a quick way to get rid of the duplicates

Thanks,
Danny

[sann0638]

I would do this by creating a 'count' pivot table then copying the first column, which should contain each name once.

Doubtless there is a better way.

Mike

[Aladin Akyurek]

On 2002-05-20 07:53, nycnights wrote:
I am need of some assistance. In one column I have over 500 names and some most are duplicated. Is there a quick way to get rid of the duplicates

Thanks,
Danny

One way:

Advanced Filter with Unique Records Only checked.

Also have a look at a thread started by White6174 as author.

[philR]

Depending on what you are trying to do, and advanced filter might be the way to go. Select Data..Filter..Advanced filter, select your data, and check the "Unique records only" box. You can also get it to copy the unique list to another location if that is what you want it to do. Have a play with it!

PhilR

[sann0638]

thought there might be!