find duplicates with the first three digit that are the same.

Steved · Jun 18, 2009

Hello from Steved

Can I please find duplicates with the first three digit that are the same.

And can the bottom formula be Altered please to do this.

=IF(COUNTA(H4,D4)<2,"",IF(H4=D4, "dup",""))

for example "471" and "4715"

Thankyou.

Steved · Jun 18, 2009

Hello Teethless mama from Steved

Thankyou.

Teethless mama said:
=IF(LEFT(D4,3)=LEFT(H4,3),"dup","")