Thread: find duplicates with the first three digit that are the same.
View Single Post
  #1  
Old June 18th, 2009, 12:51 AM posted to microsoft.public.excel.worksheet.functions
Steved
external usenet poster
  
Posts: 252
Default find duplicates with the first three digit that are the same.
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.