Identifying duplicate entries

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.
 
B

Bob Phillips

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)
 
S

Sloth

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.
 
T

T. Valko

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
 
G

Gord Dibben

Data>Filter>Advanced Filter.

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


Gord Dibben MS Excel MVP
 
Top