Stop duplicate numbers

S

Stig

Hi
I am setting up a spreadsheet to use as a basis for a database.
How do I create a column of unique numbers that can be used as serial
numbers? I need to ensure that all the numbers are not duplicated.
Thanks
Dave
 
B

Bob Phillips

Put 1 in A1, 2 in A2, select A1:A2, go to the bottom right of the selection
until the cursor becomes a black cross, click and drag down as much as you
want.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
S

Stig

Thanks for that Bob.
Can I stop anyone from altering the column and thereby getting the same
serial nnumber twice?
Thanks
Dave
 
B

Bob Phillips

You could protect the sheet(Tools>Worksheet>Protect Sheet...), or even hide
from view (Format>Sheet>Hide), and reference the serial numbers in that
sheet..
 
Top