Another remove duplicates from Excel Q: Find the dupe, remove the ROW
February 20, 2013 2:44 PM Subscribe
So, Excel 2011 has a handy function for removing duplicates. Neat! Except that when it removes the dupe, it shifts all the cells UP, thereby ruining the relationship between the columns in the row.
What I need it to do is this:
-Look for dupes
-IF it find a dupe, delete the WHOLE ROW that dupe exists in
posted by GilloD to technology (7 answers total) 4 users marked this as a favorite
Here's the rub: I'm sorting by e-mail addresses. These are the unique ID. All the other columns could be different, but if that ID is the same, I wanna remove the 2nd (And 3rd and 4th...) instance of it from the sheet.