Forum Discussion
Solved
Sorting out duplicates.
Hello I have a big list of data (email subscribers) and I need to remove the unsubscribers. I do know how to use conditional formatting and highlight duplicates but how do I remove them without havin...
Filter by color (From your conditional formatting), delete the visible rows and then remove the filter.
Hi, sorry I should further clarify.
I need both email addresses removed not just the duplicate? I have my main data, then I paste the unsubscribe data below it and highlight for duplicates to show me who needs to be removed out of the main list at the time of emailing.
I need both email addresses removed not just the duplicate? I have my main data, then I paste the unsubscribe data below it and highlight for duplicates to show me who needs to be removed out of the main list at the time of emailing.
You could try this.
Put your full list in column A (table named Subscribers). Don't append the unsubscribers to the end, though, as you had been doing.
Put your unsubscribers in column C (table named Unsubscribe)
In Column E, use the following formula: =IF(ISNA(VLOOKUP(A2,C:C,1,FALSE)),Table1[@Subscribers],"")
- YES!!!!!!! The formula won't work for me LOL but this is 100% exactly what I am talking about 😄
lesleypohl
Perhaps the formula isn't working because it's referencing the table by name. Try it replacing it with just the column label. Like: =IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),A1,"") for row 1, and let the A1 change as the formula is populated for each subsequent row.