Hello Teethless mama from Steved

Thankyou.

"Teethless mama" wrote:

=IF(LEFT(D4,3)=LEFT(H4,3),"dup","")


"Steved" wrote:

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.