I'm running Mac Office 2011 under Lion.
I have a sheet of many thousands of rows of data, with a good 40 or 50 columns. One column is email address. If any two rows have a duplicate email address, I'd like to keep only one of the rows.
Ideally, when duplicates were found it would default to keeping the row that has a particular value ("Y") in a specific cell, if applicable. But even if it just kept the first or last one, it would be an improvement.
Also, there can easily be more than two instances of a particular email address, so a solution would need to be able to handle any arbitrary number of duplicates.
I have tried the solution suggested here - Remove duplicate rows in excel when not all the columns are the same - but it did nothing for me.
Thanks for any suggestions!