how to delete duplicate data from an excell spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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).
 
try selecting a cell in the data then data>filter>advance 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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates Deletion ? 2
remove duplicates but retain one not delete both 4
Finding Duplicates in a Column (Without Sorting) 3
Identify Duplicates in a List 1
excel - removing duplicate entries in spreadsheet 1
Deleting duplicate records 2
Pulling data from other spreadsheets 1
locating and deleting duplicate cell entries 2

Back
Top