Help in big way on Same Data

  • Thread starter Thread starter Lou
  • Start date Start date
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
 
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
 
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.
 
Back
Top