Help in big way on Same Data

[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

 

[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

 

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

 

[Peo Sjoblom]

Take a look at the advanced filter and unique records only

http://www.contextures.com/xladvfilter01.html#FilterUR