Stop duplicate numbers

  • Thread starter Thread starter Stig
  • Start date Start date
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
 
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)
 
Thanks for that Bob.
Can I stop anyone from altering the column and thereby getting the same
serial nnumber twice?
Thanks
Dave
 
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..
 
Bob said:
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..
Click to expand...

Perhaps the OP could use Data Validation with a custom formula to
enforce a unique constraint e.g.
=SUM(1/COUNTIF(MyRange,MyRange))=COUNTA(MyRange)

Jamie.

--
 
Back
Top