automatically generated numbers

  • Thread starter Thread starter carl ledlow
  • Start date Start date
C

carl ledlow

Is it possible to have fields in a particular column
automatically generate sequential numbers when the enter
key is pressed
 
Hi Carl
not sure I understood you. Could you give an example. Especially: what
do you mean with 'when the enter key is pressed')
 
Original Message
Hi Carl
not sure I understood you. Could you give an example.
Especially: what
do you mean with 'when the enter key is pressed')


Regards
Frank Kabel
Frankfurt, Germany


carl ledlow wrote:
Is it possible to have fields in a particular column
automatically generate sequential numbers when the enter
key is pressed
Hi Frank

Lets Say for example that I have a List of items to enter
into a worksheet with, say, 5 columns. What I want happen
is this, at the end of the 5th column I would press the
(entre) button and have the next available number in the
list automatically generated by the system as soon as the
field is highlighted
 
Hi Carl
maybe the following helps you (creates a sequence number in column A
after you have entered something in column F of the previous row):
in A1 enter
1
in A2 enter
=IF(F1<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy down
 
Back
Top