Hi guys,

Apologies for not using code tags I just posted in a hurry

So I have attached a duplicate-test.xls file to my original post, which has some sample fictional data on it in the same format as my real spreadsheets. I have not saved this with the macro included though as thought it best to leave that off!

catherine paice, francis healey and wendy price all appear twice, so these duplicates need to go, however only columns A = name, B = email and G = Yes/No (for member) need to be considered. All the other data is copied across but as the macro should not compare address, city and phone it shouldnt matter what is inside these cells right?

What the macro should do is remove the duplicates based on both Name and Email together (which it does already) but if collective duplicates contain different Yes or No values in G, it needs to display Yes for that column in the final list.

Wendy Price is the one in the test file that has "yes" in one row and "no" in the other.

I hope that helps!!!


Susie x