I have a column (I) in which i record 7 digit numbers, sometimes i use more than 1 number in each cell, each number is separated by a space, i am currently using this formula to show me if i am entering a duplicate number,
=IF(COUNTIF($I$2:I2,I2)>1,"Dup","") it is fine when there is only 1 number in a cell, the problem is it does not find duplicates if there is more than one number in the cell. Any help would be appreciated.
=IF(COUNTIF($I$2:I2,I2)>1,"Dup","") it is fine when there is only 1 number in a cell, the problem is it does not find duplicates if there is more than one number in the cell. Any help would be appreciated.