Filtering Issue

J

jayhjenkins

I have a spreadsheet listing registered customers for a rewards card.
it includes customer id numbers, addresses and date of last use. the
issue is that there are many duplicate addresses and duplicate names.
i want to get rid of the duplicates based on the date of last use (in
other words, only keep the records of the rewards card the customer is
actually using, as opposed to the duplicates they have accumulated
over the years). i've tried toying with the advanced filter and all
kinds of sorts, all to no avail. any help would be GREATLY
appreciated. thanks.
 
R

ryguy7272

If you sort by 'date of last use' and then use the Advanced Filter tool (make
sure to click the Unique records only box), why DOESN'T it work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
Remove Duplicates logic 2
Count Function (conditional counts) in Reports 3
Filtering Alpha numeric text 1
Spreadsheet - Deleting Duplicate Records - Self Checking 1
How to remove duplicated data repeated.... 7
look for multiple entries 4
Count how many different cells are in a range 1

Top