I've borrowed this formula for finding duplicates

[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.

 

[Max]

My objective is to search Columns A:A and C:C for duplicates

if found then in Column G:G put yes.

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
---

 

[Steved]

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.

 

[Max]

Try this then in C2, copied down:
=IF(COUNT(A2,C2)<2,"",IF(A2=C2, "dup",""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik

 

[Steved]

Hello Max

Excellent.

I thankyou for taking timeout.

Have a nice day.

 

[Max]

Welcome, Steved
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik