View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
habelow1 habelow1 is offline
external usenet poster
 
Posts: 1
Default concatenate 2 columns (A2+B2) and compare for duplicates

I have 2 columns (First Name, Last Name) that I need to see if there are any
duplicates in the spreadsheet, and to flag them.
John Smith <----Duplicate
Jane Smith
John H Smith
John Smith <---- Duplicate

Thanks