Stop Values Duplicating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.

---
 
Back
Top