How to generate next number?

  • Thread starter Thread starter anna
  • Start date Start date
A

anna

Hi all,

I've been losing sleep trying to think of a formula to
automatically generate next reference number.
In the column A, there are reference numbers in a standard
format, say,

X1
X2
....
X100

and so on. Here's what I want: when I select the last
one, e.g. X100 and hit Enter, I want X101 to automatically
appear in the cell below. (Or, it might insert itself
when you type something in the cell next to it and then
tab along to the next one - can't remember exactly). An
ex-colleague showed me how to do it, but I've forgotten
the formula!
Great big thanks to anyone who helps!
 
Hi

Select the last cell, and drag it down using the little black square in the
bottom right-hand corner. If this does not increment it by one, do the same
while holding the Ctrl key.

Andy.
 
You should be able to fill down using the fill handle.
Click the bottom right-hand corner of the cell containing
X100, and holding down the mouse button down, drag down
the column.

HTH
Jason
Atlanta, GA
 
Hi Anna
in cell A1 enter
=IF(B1<>"",1,"")

in cell A2 enter the following formula
=IF(B2<>"",MAX($A$1:$A1)+1,"")
copy this formula down for as many rows as you like

Now select column A and format this column with the custom format (goto
'Cells - format')
"X"0
 
Thanks for making me smile!!
Here's something that might make you smile:

There are 10 types of people in the world.
Those that understand binary, and those that don't.

Andy.
 
Back
Top