Finding duplicate nuumbers in a column

[Johnny the hat]

Is there a formula to find duplicate numbers in columns in excel

 

[Peo Sjoblom]

Do you want to find them or remove them

to find them

=IF(COUNTIF($A$1:$A$20,A1)>1,"Duplicate","")

in a help column copy down and it will tag each number/value that occur
more than once. If you only want to tag from the second occurrence

=IF(COUNTIF($A$1:$A1,A1)>1,"Duplicate","")

both formulas should be copied down

if you just want to remove any duplicates and get a unique number column use
data>advanced filter and unique records only

Regards,

Peo Sjoblom

 

[Johnny the hat]

Thank You