auto number

[ash]

is it possible to make excel give an automatic number
when you enter date
say if you were entering staff id numbers and when you
want to enter a new member excel looked for the first
avaliable number not in use?
please help
thank you

 

[Frank Kabel]

Hi Carl
maybe the following helps you (creates a sequence number
in column A
after you have entered something in column B of the
previous row):
in A1 enter
1
in A2 enter