Macro to remove duplicate entries basis of different conditions

Hello Guys,

I need help in creating a Macro to remove duplicate entries from entire data basis of below requirement:

Requirement:

1. Need a Macro which identify the duplicate entries through comparing the values of Column A, B, D and F in Sheet 1.

2. Macro should delete all duplicate entries if Status Column (Column G) is filled against any duplicate row.

3. If, Status column is empty against all duplicate entries then macro should delete only the old entries by comparing the Date and Time from Column E.

For example: If you see the attached sheet then Row No. 2, 3, 4 and 9, 10, 11 (marked as yellow) are duplicates and the Status column is also filled. So, macro should delete the all above 6 rows. Now, the Row No. 5, 6 and 7, 8 are also duplicates but the Status column is empty; so Macro should check for the latest entry through Column E and delete the old duplicate entries which is Row No. 5 and 6.

The purpose of this Macro is to keep only unique entries in the sheet whose Status column is empty and which is recently added

Please let me know if need more clarification.

Thanks,
MG

Hi Manish..
I have a solution... (not up to the mark yet...)
may be a step forward..

check the attachment .. and tell me that if the unique cells calculated by me are to be kept or ..
there is something which I am missing..

Don't forget to click *

Hello Vikas,

Thanks for reply.

May be I had not clarified my requirements properly.

Please see the attached file for how the data I required or should look after running the Macro.

Please let me know if you need any more clarification on it.

Thanks,
MG

check the attachment for explanation...



Don't forget to click *

Hello Vikas,

I know it is a little bit confusing. Let me try to explain it again.

What I have to do is, every day I have to fetch this sheet from the system and have to fill the Status column against each unique App ID (in Column A). But, this Sheet contains the duplicate entries.

Now what I required is, if any App ID contains the Status column filled then Macro should delete the all entries from the sheet (including those duplicate entries of same App ID which have the Status column empty because they are already updated).

Now there are few duplicate App ID entries against those the Status column has not been updated. In this case Macro should delete the old duplicate entries by comparing the Date & Time value in Column E of same App ID's.

Now, I will update the Status against the remaining unique (and latest) entries.

But, to double check the duplicate entries, I need an Macro which comapres all the A, B, D and F Columns (to identify the exact duplicate entries) because there are some duplicate App ID's which have different values in B, D or F Column.

May be above explanation will help you to understand my previous attached file.

Thanks for helping me.

Regards,
MG