How do i remove duplicate records in Excel 2007
 

I have a massive list of email addresses in Excel and I know there are many
duplicates in it. How do I easily remove the duplicates so I have a clean
list? P.S. I am not an experienced Excel user, so it might be obvious but I
have no idea how to go about it.

How do i remove duplicate records in Excel 2007
 

Select the range of cells you want to remove the duplicates from.
Goto Data tabRemove Duplicates
Provide the info to the user forms

--
Biff
Microsoft Excel MVP


"ComputerPussycat" wrote in
message ...
I have a massive list of email addresses in Excel and I know there are many
duplicates in it. How do I easily remove the duplicates so I have a clean
list? P.S. I am not an experienced Excel user, so it might be obvious but
I
have no idea how to go about it.