Merging two columns of Names to One Column

New Contributor

Im having a problem trying to merge two column of names to on single column with applying a rule of if there is duplicate names in column A and column B then column C will be all the names that were not duplicates in Column A&B

3 Replies

Excel has the option "Remove duplicates"! Have you tried? You need to have all cells on the same column though.


 Sorry that's Italian, but you can find your way comparing the icons ;)


But, if you don't want (or you can't) use that, you can try in the way I used in the attached file.



Thank you for your reply. Its a bit more that the duplicate and the attach file you sent over. I attach a sample of what i am trying to do. If column A and column B have a match i want column E to have all the matches.

If you add desired result to the sample it'll be easier. Do you mean matches for columns A and C (A and B never matches)? In E in first row it'll be "Blocker, DeBisschop" or what?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies