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.

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.





"Max" wrote:

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

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" wrote:
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

Hello Max

Excellent.

I thankyou for taking timeout.

Have a nice day.

"Max" wrote:

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" wrote:
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

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

Excellent.

I thankyou for taking timeout.

Have a nice day.