Another way



=COUNTIF(B$1:B$100,LEFT(A1,9)&"*")0



--

Regards,

Peo Sjoblom


"Sweetetc" wrote in message
...
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