Help in big way on Same Data

L

Lou

Good Day!
I have a table I imported which has 1432 record for events
we held. The problem is that each record has nulitple
duplicates. Example;

Name Amount Covers
Bob 100 10
Bob 100 10
Bob 100 10
Ted 100 10
Ted 100 10

I need to formulate or something to delete the lines that
are duplicates. Ideas and suggestions would be great. I
can sort it but I want completelly get rid of the dupes.

Thank you.
Lou
 
A

Amit Shanker

Go to Data--Filter--Advanced Filter and in the resulting dialogue box, check
'Unique records only'. You can then copy this unique list to another sheet.

Amit
 
B

Bob Umlas Excel MVP

Select the range, use Data/Filter/Advanced filter
check Unique Records Only and "Copy to another location"
Put in an address to hold the result, then click OK. When
you're done, you will have the unique records in the new
place. You can delete the original range or not.
 
Top