Have duplicate rows of data

  • Thread starter Thread starter homer985
  • Start date Start date
H

homer985

I have a database in Excel format that I need to trim down. There are
duplicate "entries", with identical information by rows. Is it possible
to have it automatically trimmed, deleting the duplicate rows?

I have 2,100 rows of data, many of which are duplicate. Just want to
trim that down...

Thanks,
Dave
 
Thanks Frank, that look like EXACTLY what I need. My computer knowledge
is good, but my experience with macro's is limited. Obviously I'll need
to cut and paste the macro commands... any suggestions on putting into
to my database/workbook.

Any help will be appreciated.

TIA
 
Thanks Franks once again! You da man. Worked like a charm, and you save
me a couple of hours of work from going through thousands of repeate
entries.

Dav
 
Back
Top