Hello all. I will try to do my best explaining my need on this thread.
currently I have three columns. Two columns A and B have last names in them. (no particular order. However, Column C has managers associated with the last name in column B.
What I would like to do is this. find duplicates between column A and column B and where there is a duplicate list the manager from column C into a new column D. example below
1 Column A Column B Column C Column D
2 smith Jones Peterson Erickson
3 Jones Thompson Erickson Cooper
4 anderson Palin Dickenson
5 thompson Finegold Cooper
I hope this all makes sense. Is there an easy way to do this?
Thanks
Bookmarks