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