spoke too soon this does not seem to comapre what I need

22345678922223200 12345678922223200 TRUE
32345678922223200 12345678922223200 TRUE
42345678922223200 22345678922223200 FALSE
12345678922223200 12345678922223200 FALSE
12345678922223200 12345678922223200 TRUE
24345678922223200 12345678922223200 TRUE

These two columns should return True, False, False, True. True. False,
I am aking if for the 1st 9 digits and A1 are there any matches for the 1st
9 digits in column B Then A2 first 9 digits, etc.


--
Thanks
ETC


"Sweetetc" wrote:

> 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