how to delete duplicate data from an excell spreadsheet
 

I have a worksheet with names and addresses sorted in alpha order and I see a
lot of duplicated data, is there an option to delete duplicated data and only
have one record per name?

Thanks!

how to delete duplicate data from an excell spreadsheet
 

One way is to set up a helper column. Assuming the data begins in cell A1, in
cell B2 enter: =if(a2=a1,"Dupe","") and copy the formula all the way down to
the end of your dataset. Then simply delete everything that's labeled as a
Dupe in Column B (using the autofilter is easy, and the first occurence of
each duplicate won't be labeled as such).

"sabogal" wrote:

I have a worksheet with names and addresses sorted in alpha order and I see a
lot of duplicated data, is there an option to delete duplicated data and only
have one record per name?

Thanks!

how to delete duplicate data from an excell spreadsheet
 

try selecting a cell in the data then datafilteradvance filter and select
unique records only and filter. you can then copy and paste the filtered data.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"sabogal" wrote:

I have a worksheet with names and addresses sorted in alpha order and I see a
lot of duplicated data, is there an option to delete duplicated data and only
have one record per name?

Thanks!