| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop Values Duplicating
Cheers. Thanks a million your a star
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop Values Duplicating
welcome.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "chrishocking" wrote in message ... Cheers. Thanks a million your a star |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i stop repeating values? | Excel Discussion (Misc queries) | |||
| duplicating values to different worksheets | Excel Discussion (Misc queries) | |||
| How do I stop #DIV/0! when some of my values are zero? | Excel Discussion (Misc queries) | |||
| How do I stop worksheets from duplicating cell in a different wor. | Excel Discussion (Misc queries) | |||
| Stop from duplicating entries on multiptle sheets | Excel Discussion (Misc queries) | |||
Linear Mode
