Thread: find duplicates with the first three digit that are the same.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default find duplicates with the first three digit that are the same.
=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.
Reply With QuoteReply With Quote