populate number if matching unless blank

[abraham30]

Hello everyone!

In the attached sheet, if the data from col A and C are distinct, then i need to populate as 1 unless blank (for duplicate)


see example data in row number 2 is distinct (USA, 23-JAN-2005) , so display as 1
where as same data is populated in row number 5 and 9 (duplicate), so display as blank


Thanks in advance

[oeldere]

I used a helpcolumn (yellow cells) to get the result.

The result is in the green cells.

I used =if(countif....

[RudiS]

An alternative...

=IF(SUMPRODUCT(--($A$2:A2=A2),--($C$2:C2=C2))=1,1,"")