Forum Discussion
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 having to do it manually?
Filter by color (From your conditional formatting), delete the visible rows and then remove the filter.
15 Replies
Filter by color (From your conditional formatting), delete the visible rows and then remove the filter.
- Wow I had no idea I could filter by color?? DUH!!! You have no idea how much work you've just saved me!!!!!! Thanks a million.
With all of your data in a column (ideally a table), select a single cell in the column with the duplicates. From the Data ribbon, use the Remove Duplicates button. It will prompt for acceptance of the current column and in on click your duplicates will be removed.
- 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.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],"")
