I've borrowed this formula for finding duplicates

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

My objective is to search Columns A:A and C:C for duplicates if found then
in Column G:G put yes.

=IF(COUNTIF(A423:C423,"DUPLICATE"),"yes")

Thankyou.
 
My objective is to search Columns A:A and C:C for duplicates
if found then in Column G:G put yes.
Click to expand...

The above is interp'd to mean uniqueness is defined by both cols A and C
Assuming data in row2 down
In G2:
=IF(SUMPRODUCT((A$2:A2=A2)*(C$2:C2=C2))>1,"dup","")
Copy G2 down to the last row of data in cols A & C
Col G will flag duplicates as "dup"
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
 
Hello Max from Steved

Max I'm getting "dup" when no duplicate's

A3 5525 C3 5521

and not getting "dup" when their are duplicates.

A22 5528 C22 5528

Thankyou.
 
Back
Top