I have attached a small subset of a 26,000 member contact list. (Don't worry, I've modified each record enough to thoroughly protect the privacy of each original contact.)I want to remove the entire row, for any email address that is identical to another. In other words, I don't want to send two emails to the same person, even if their address or other information are different.The contact information is listed in rows. The rows are not all identical - for example, someone may have the same email address, but have a different street, city, or state address.Whenever two identical emails appear in the list, I want to remove the entire row of information containing one of them, and it doesn't matter which row it is.Hope this is doable. By a macro, add-in, sort/filter function, or something else.
![]() ![]()
I can't imagine manually going through this entire list removing the hundreds of duplicates, and I can't figure out how to automatically do it.Thanks!
![]()
May 10, 2011 This Excel 2008 issue is something that just came up for me as well, and by accident, I was able to sort a list by carrying out the following steps: Select record range (For example, all of Column B) Click on Menu Buttons: Data Filter Advanced Filter.
I have an issue where Remove Duplicates is not functioning as expected. I have 2 files: Source.xlsx and Calculation.xlsx ![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |