Eliminate duplicates(values) in an Excel column !!

  • Thread starter Thread starter Jane Humbrey
  • Start date Start date
J

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
 
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 **
 
Back
Top