Hi
I am trying to do a match to see if there are duplicate Surname's within a spreadsheet,
However when I try =MATCH I cannot seem to get the results unless I use Match Type 1 However this seems to bring up data even if the Surnames arent the same?
I think maybe there are common letter but I really cant figure it out
Spreadsheet is attached..I am looking to find out if Buyer Column and Seller Column have been family transfers where the Surname is a common demonitor...
Thanks for your help
Bookmarks