I am trying to identify duplicates on a sheet using a check box

I want to identify duplicates on a sheet using a check box but I want to ensure that 2 conditions are meet. If the amount is the same and the Internal Wire ID is the same.

I am using this formula to look for matches in amount, =IF(COUNTIF(Amount:Amount, Amount@row) > 1, 1) but I am getting too many positive so I want to have it look at the Internal Wire ID (this is another column) and see if it is a duplicate as well.

I have also tried setting up two columns using, =IF(COUNTIF(Internal Wire ID:Internal Wire ID, Internal Wire ID@row)> 1,1) but this is showing #UnPAR I am assuming because it is not a numerical amount.


Thanks for your help

Best Answer

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Answer ✓

    you should be able to use =IF(COUNTIFS(Amount:Amount, Amount@row, [Internal Wire ID]:[Internal Wire ID], [Internal Wire ID]@row) > 1, 1) 

    When a column name has more than one word it needs to be in brackets [column name]

Answers