I am trying this formulae - it worked fine in one sheet but doesn't seem to work in another sheet even though it has the same column manes.
This formula should ideally activate checkbox if there are duplicates and then I have a conditional formatting that will highlight the duplicate Invoice numbers when checkbox is checked.
Currently the check box isn't getting checked and also the formula is bringing back 'NO MATCH'
Any help would be appreciated.
=IF([Invoice Number]@row = "", "", IF(COUNTIF([Duplicate Invoice Number]:[Duplicate Invoice Number], [Duplicate Invoice Number]@row) > 1, 1, ""))
Help Article Resources
Check out the Formula Handbook template!