Identifying duplicate entries

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

 

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

 

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

 

[CLR]

Jim Cone's fine commercial add-in called XLCompanion has a feature that will
remove all rows with a duplicate in a column........it's available at:

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3

 

[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

 

[Gord Dibben]

Data>Filter>Advanced Filter.

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


Gord Dibben MS Excel MVP