formula work one one sheet but not another


Hello I have a formula =IF(COUNTIF(IndexKey:IndexKey, IndexKey@row > 1), 1, 0) that checks all the indexkeys in the column to see if there are any duplicates. This works perfectly on my tester sheet which is an exact copy of the sheet I want the formula on but for some reason doesn't work on the main sheet and returns 0 instead of 1 even when there is only 2 rows on the sheet with the same indexkey it doesn't work

Best Answer