Forum Discussion
Sorting out duplicates.
Filter by color (From your conditional formatting), delete the visible rows and then remove the filter.
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.
Is there a way to highlight the duplicates prior to deleting them so I can verify the information?
You can highlight both of the columns, and from the Data ribbon, select Conditional Formatting. From that dropdown menu, select Highlight Cell Rules > Duplicate Values. Once you confirm the color option it will show you the duplicates in both columns.
WOW...thanks for the speedy response. I have a spreadsheet of names for our holiday catalog. I read your post but I am a little confused (Sorry). Do I need to copy the address column to do the conditional formating?
Thanks in advance for your assistance. I attached a ship of my data list
- 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],"")
- YES!!!!!!! The formula won't work for me LOL but this is 100% exactly what I am talking about 😄
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.
- Hi, well the data is coming from multiple platforms so unfortunately it's the only way until our new integration into salesforce.
