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