Identifying duplicate entries

  • Thread starter Thread starter japc90
  • Start date Start date
J

japc90

I have a spreadsheet which I am sure has duplicate account numbers and
I need to delete everything but the first entry. An simple way to
accomplish this?

Thank you in advance for any assistance.
 
How about just sorting the data and sight checking it?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I don't know how you could have Excel automatically delete the entries, but
maybe this will help. You can use conditional formatting to highlight the
duplicates. Select the entire column, click Format->condition Formating,
select "Formula is" and enter the following formula (replace all A's with the
column you selected)

=COUNTIF(A:A,A1)>1

click format and pick something really noticable like a lime green
background. Click "OK" and now all duplicates for that column will be
highlighted. So you can go in and manually delete them.
 
I don't know how you could have Excel automatically delete the entries

A new feature in Excel 2007.

Data tab>Data Tools>Remove Duplicates
 
Data>Filter>Advanced Filter.

Check "Unique records only" and "copy to another location".


Gord Dibben MS Excel MVP
 
Back
Top