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)



"japc90" wrote in message
...
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.

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.

"japc90" wrote:

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.

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



"japc90" wrote:

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.

I don't know how you could have Excel automatically delete the entries

A new feature in Excel 2007.

Data tabData ToolsRemove Duplicates

--
Biff
Microsoft Excel MVP


"Sloth" wrote in message
...
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.

"japc90" wrote:

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.

DataFilterAdvanced Filter.

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


Gord Dibben MS Excel MVP

On Fri, 1 Feb 2008 07:15:54 -0800 (PST), japc90 wrote:

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.