Stop Values Duplicating

C

chrishocking

I have an excel spread sheet into which serial numbers are input. However a
serial number can be duplicated, how can i stop this from happening.
 
M

Max

chrishocking said:
I have an excel spread sheet into which serial numbers are input. However a
serial number can be duplicated, how can i stop this from happening.
Click to expand...

You could try using Data > Validation

Assuming serial nos are input into A1 down
Select col A, click Data > Validation, make the settings as
Allow: Custom
Formula: =COUNTIF(A:A,A1)<2
Ok out

Test it out by trying to input some duplicate serial numbers into col A.
 
Top