04-02-2020 11:42 AM
04-02-2020 11:42 AM
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?
04-02-2020 11:56 AM
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.
04-02-2020 12:11 PM
04-02-2020 12:45 PM
This last clarification raises (in my mind at any rate) another question, having to do with the way you've organized your database. You wrote "I have my main data, then I paste the unsubscribe data below it and highlight for duplicates..." making me think you're creating multiple rows for the same individual....which in general isn't a good idea.
So would it be possible for you to post an example of your actual spreadsheet (just rendering the names and any other identifiable things so they're not real ones?
That aside, I wonder why you feel a need to delete the unsubscribers in the first place. You obviously need to honor their request, but could that not be accomplished by a column in the database that indicates "Active" or "Unsubscribed"--that would then enable you to send a "Welcome back" note to anybody who eventually re-subscribes.
All of which is to say, there may be other ways altogether to manage this situation.
04-02-2020 12:46 PM
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],"")
04-02-2020 12:55 PM
04-02-2020 01:02 PM
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.
04-02-2020 02:42 PM
by Monica_Shook on June 17, 2020
by Ilya_M on March 02, 2020