Allow only unique numbers in a Column in Excel.
Do not allow duplicate values in a column. Send an error message if the value already exists.
=COUNTIF($A$2:$A$20,A2)=1
For more help visit my website
I am able to provide online help on your computer for a reasonable rate.
MY videos are all created on Camtasia.
Follow me on Facebook
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
MOBILE Numbers LIST IN COLUMN without Repeats ?