Checking for Duplicates

[RandWald]

Hi. I found this formula for "checking for duplicates" via conditional format rules.

I would like to modify it to only search for the first 5 characters to match.

=countif(A:A,A1)>1

thanks, Randy

[filthy_birds]

add a new column for the first 5 characters using =LEFT(A,5) and run the countif on this column

[Pete_UK]

Try it like this:

=countif(A:A,left(A1,5)&"*")>1

Hope this helps.

Pete