Macro that searches through column and removes specific duplicates

Hello, I have a really long list of names when people contacted my company, with their date of contact in the column next to it. I would like to be able to identify if the previous month was the first time someone contacted my company. So I need a formula (or macro) that would search the names column for duplicates and if the duplicate's date is outside of a specified range it will delete all instances. So I would be left with only the people that contacted us for the first time in that range. Thanks for your help in advance!

Why not just filter the rows by date with the Unique Records Only option?

http://office.microsoft.com/en-us/ex...010073943.aspx

Would it be better to filter by a unique ID, such as a phone number, rather than a name to make sure you do not exclude any contacts with similar names?

Yes, sorted by date Newest to Oldest

Capture111.PNG

In this example everyone but August Olesch should be deleted.. The incentive would be from 1/1/2011-present, so thats what my report will return. All the others called before May, including Barbara Schell, so she wouldnt get credit for being a first time caller in May. I sorted by name just to show the list in a single screen, it is normally sorted by date- newest to oldest

Originally Posted by shg

With the list sorted ascending by date, add a formula in C2 and copy down:

=COUNTIF(A$1:A2, A2)

AutoFilter col B for April and col C for 1

Thank you! How could i turn this into a macro so it will do all that for me, so i would just be left with the few rows that are the results? I'm at a new job and would like to impress my department with a new macro for everyone to use! -Thanks!

Originally Posted by shg

With the list sorted ascending by date, add a formula in C2 and copy down:

=COUNTIF(A$1:A2, A2)

AutoFilter col B for April and col C for 1

Would it also be possible to add to the macro how many calls each person gets? Sometimes a company will run an incentive where the first 2 calls get the incentive as opposed to just the first call during the program. I would still need to report on that monthly.

create a sample sheet of the data and use dummy info, with expexted results. Your two columns of data is pointless.

The only thing I didn't understand was your comment at the very end, about asking you how many times "a person can be counted."

Otherwise, your instructions seemed quite clear.

Here's my take on a solution. This modified example seems to do what you wish.

(Rather than delete data from the main list, instead I simply listed the employees who will receive a gift card on a different tab.)

callers by month - modified.xlsm

Modify the code as you see fit.

Originally Posted by Ed_Collins

The only thing I didn't understand was your comment at the very end, about asking you how many times "a person can be counted."

Otherwise, your instructions seemed quite clear.

Here's my take on a solution. This modified example seems to do what you wish.

(Rather than delete data from the main list, instead I simply listed the employees who will receive a gift card on a different tab.)

Attachment 236311

Modify the code as you see fit.

Thanks. Ill take a look! Sorry for the confusion. Some incentive programs say the first two calls a person makes get counted as opposed to just the very first time they call us. So regardless of what month they call during the program they still count whenever the first two calls were.

Thanks for your help!