Hi all!
i'm using the formula below to find duplicates; however, i want to make the formula dynamic, so i don't have to change it everytime new data is added to sheet. Any help will be greatly appretiated.
=IF(COUNTIF(F2:F1774,F2)>1,"Remove",0)
Thank you!!!
i'm using the formula below to find duplicates; however, i want to make the formula dynamic, so i don't have to change it everytime new data is added to sheet. Any help will be greatly appretiated.
=IF(COUNTIF(F2:F1774,F2)>1,"Remove",0)
Thank you!!!