This one is giving me fits. I keep thinking I should be able to do it but I can’t firgure it out.
Title may be misleading…I actually have four columns (2x2)
Column A are email addresses such as:
Column B are just the domains of the above addresses stripped out so would look like:
Columns C & D are done exactly the same way although it is a different list of names. The domains are frequently (not always) the same though (so, column C is unique but column D will have a great many in common with column B).
Basically these are lists for two separate e-mails we send out. My task is to bill the companies for the subscribers they have. Unfortunately, so far, the only way I can gather everyone from (say) 123.com is to manually cut and paste from each list. It is a long list though and insanely tedious.
My question is can I match the domain columns of the two lists and keep the names next to them in the right order? If I make them a table and sort on a column the columns, being unequal, do not match up. Note that there may be twenty “123.com” in one list and five in the other (or vice versa).
Not sure if this makes sense but if anyone has a bright idea for this would be much appreciated.
Thanks in advance!