Mark duplicate with cell linking

Nicole Hodges

Hello!

 

I am trying to check my helper column if a certain column contains any of the same amounts as in multiple columns in a sep sheet. I tried cell reference in place of [Column Name]@row but it isn't working... any help here?

=IF(COUNTIF([Column Name]:[Column Name], [Column Name]@row) > 1, 1)

Paul Newcome

HERE is some info on Cross Sheet References.

 

You could try a formula that would look similar to this...

 

=CONTAINS([Column Name]@row, {Other Sheet Range})

.

@{Other Sheet Range} would be a cross sheet reference that contains all of the columns you want to search. The formula would check the box if the data in [Column Name]@row is in any cell within that range.