Stop Values Duplicating
 

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.

Stop Values Duplicating
 

"chrishocking" wrote:
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.

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Stop Values Duplicating
 

Cheers. Thanks a million your a star

Stop Values Duplicating
 

welcome.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"chrishocking" wrote in message
...
Cheers. Thanks a million your a star