For my company I need to compare two lists of emails, one master list, and one list of everyone that has opened it. I need to find the duplicates from this list, and that's the easy part. Here's what I don't know how to do: I need to find these duplicates and compare them to another column in the sheet that gives the geographic location for each email in the master list. I can't just remove duplicates because then it will adjust the order of the emails in correlation to their geographic location number. I am also working with a master list that contains half a million email address's, so highlighting and eyeballing the Geo locations connected is out of the question. I have combined the master email list with the geographic location column by separating the email and location with a comma with a "=A2&", "&D2" formula, but then I do not know how to highlight and sort out the duplicates, because there is an added numerical value and a comma in the cell even though the email addresses are the same. Please help this has been making my brain melt for over three days and I cannot seem to figure it out even when I make example sheets with much less data. Thanks !
Bookmarks