Sequential numbering

J

jazz

I have a list of items, numbered, say 1 to 10. When I want to enter the
next item, is there a way that I can automatically have the next number as
11? I know I can use the fill handle to create the numbered list, but I was
hoping to avoid that, and had hoped that when I tab into the particular cell,
and then tab to the next cell, it would automatically provide the next
number. Too much to ask? I am using Excel 2000. Many thanks. Jazz.
 
B

BenjieLop

jazz said:
I have a list of items, numbered, say 1 to 10. When I want to ente
the
next item, is there a way that I can automatically have the next numbe
as
11? I know I can use the fill handle to create the numbered list, bu
I was
hoping to avoid that, and had hoped that when I tab into the particula
cell,
and then tab to the next cell, it would automatically provide the next
number. Too much to ask? I am using Excel 2000. Many thanks.
Jazz.
Click to expand...


If your items are to be listed in Column B (starting in Cell B1, fo
example), enter this formula in Cell A1

=if(B1<>"",counta($B$1:B1)&".","")

and copy this down until wherever cell you want to stop.

The above formula will automatically and sequentially give you a numbe
for the items that you enter in Column B.

I hope this is the formula that you are looking for
 
K

Ken Russell

Hi Jazz,

There is probably a more sophisticated way of doing it, but this will work;

Assuming column A contains your sequential numbers, then enter this formula
in A11
=IF(B11<>"",A10+1,"")
Cheers,
Ken Russell

[email protected]
Remove yourhat to reply by e-mail
..
 
M

Monique

All I do is go to next blank cell and add:
=A1+1 and use the pull handle down the column.
 
Top