Hello. I have encountered a problem I just cannot solve myself, if someone could help me out I would be eternally grateful. I have been assigned with the task of organizing a database consisting of user details. As follows - Date, First name, Last name, Email, House phone, Work phone, Mobile phone, Address, City, State, Zip, etc. This Database is a product of two databases being merged into one, therefor there are a lot of duplicate accounts. At the same time the information per row is different, so the duplicates are hard to find. Let me explain - If I highlight all and go into "Data" - "Remove Duplicates" I will get 25 results. Basically 25 rows that are completely the same, but if I highlight only the "Email" column and remove duplicates specifically from that column, I get around 6 thousand results, basically 6 thousand duplicate emails removed. (I obviously can't just leave it at that since I need to remove the entire row corresponding with the duplicate email and not just the email itself.) Something I have found is that usually the duplicate account doesn't have a single phone number. So what I am trying to do is; have excel remove the row of a duplicate email that doesn't have a corresponding phone number. One way I have thought of doing that is going into "Home"-"Conditional Formatting"-"Highlight Cells Rules"-"Duplicate Values" and then program a macro to check if the text in column "D" (Email) is highlighted, if yes then check the next 3 cells to the right (House phone, Work phone, Mobile phone), if they are empty then remove the row entirely. Though I have no idea how to implement this, neither can I do this manually because I have a total of about 20 thousand rows.
If you have any sort of ideas I would love to hear them.
Bookmarks