View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sweetetc
 
Posts: n/a
Default Compare the 1st 9 digits in two columns looking for duplicates

I have two columns of data. Each row cell is 27 characters long. I want to
find any duplicate matches between the two columns on just the 1st 9
characters of each cell. Is there a function that can do this?

--
Thanks
ETC