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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - find duplicates with the first three digit that are the same. (https://www.excelbanter.com/excel-worksheet-functions/234223-find-duplicates-first-three-digit-same.html)

Steved

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.

Teethless mama

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.

Steved

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

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.

All times are GMT +1. The time now is 12:16 AM.