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
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.