Eliminate duplicates(values) in an Excel column !!

[Jane Humbrey]

Hi Guys

G'day. I have a long list of email values in a column in excel
spreadsheet(windows 2000). I want to findout the duplicates and want to
eliminate those. ie. If I have (e-mail address removed) 5 times in an excel column , I
just want to keep only one(keep uniqueness). Can anybody help me how I can
find the duplicates and eliminate those in an Excel column. In the end I
want a column which contains unique email addresses. Thank you.

Jo

 

[Paul B]

Jo, have a look at data, filter, advanced filter and unique records only and
see if this will do what you want

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Jane Humbrey]

Hi Mike

I tested with your suggestion. It worked nicely. Thank you Mike.

Jo

 

[Jane Humbrey]

Hi Paul

Yes, It worked nicely. Thanks you.

Cheers
Jo