Remove duplicate IF...

**bruizer31** · 05-15-2013, 08:49 PM

Hi-

I have a long list of names in column A, with the date they called us in column B. We run incentive programs for specific months. If they called within that specific time frame they get a gift card. The dates of the incentive change depending on which company I am running the report for.
When i run the report, i run it for the length of the incentive program. ie 1/1/2013- 4/30/2013.. but when i am making the report for april, i would need to make sure the list is filtered down to only include people that have called the for the first time in april.

So I need a macro that will 1- ask me the date range that is acceptable for people to have called (such as 4/1/2013 - 4/30/2013, 2- search through column A and find out if the name has a duplicate outside that date range, 3- delete all rows within the list that included that name if they have called outside the specified range.

So i should be left with just a list of the names that have called within the month I specified and have not called before then. I tried filtering but with the length of my list it is too time consuming. I can't remove duplicated because i need to know if they have called before and when i remove dups they all look like unique callers.

I'm somewhat new to macros so if you could explain the steps the macro takes that would be helpful for my progress in learning.

Thanks in advance!

**Leith Ross** · 05-15-2013, 11:41 PM

Hello thebka,

Welcome to the Forum!

Posting your workbook is the quickest way to get answer to your problem. People are not inclined to recreate your work just to test it.

This will provide all the information needed to accurately develop and test your solutions and provides you with the quickest turnaround time.
If your workbook contains sensitive information please redact it before posting.

To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture

**arlu1201** · 05-17-2013, 02:28 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.