Christian Hans
asked on
Excel Forula to line up matching cells
Please see attached...
I have two Excel columns containing email addresses.
I need to run a function to make them line up, using column A as the master, search column B for the same address, then move it to the same row.
I cant just sort the two columns as there are addresses missing, so I want to be able to see the blanks.
Thanks in advance folks...
Book1---Excel.jpg
I have two Excel columns containing email addresses.
I need to run a function to make them line up, using column A as the master, search column B for the same address, then move it to the same row.
I cant just sort the two columns as there are addresses missing, so I want to be able to see the blanks.
Thanks in advance folks...
Book1---Excel.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Accept: Rob Henson (https:#a41853542)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Accept: Rob Henson (https:#a41853542)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer
Open in new window