Thread: number columns with letters

How can I number using letters as well

For example

Cell A2 = 1

Cell A3 = +A1+1 to be 2

Cell A4 +A2+1 to be 3 and so on

But what I need is to have cell A1 number = A-1 or A 1 where the A is constant, and the 1 is two in the next cell and so on.

Here's one way: Put this in A2 then copy down:

="A-"&(ROW()-1)

Thanks, but I did that and it is not working right

Cell A3 has A-1
Cell A4 has "A-"&(ROW()-1) , and the output is A-6

Forget it

I got it

it is reading from the ROW reference

now I have

Cell A4 has "A-"&(ROW()-5) , and the output is A-2

Thanks

But now if I insert a ROW between a set of numbers, I have to work on the rest below the new inserted ROW

Is there a way to Dynamically number the not blank cells in the Column ?

Originally Posted by OceanBlue

But now if I insert a ROW between a set of numbers, I have to work on the rest below the new inserted ROW

Is there a way to Dynamically number the not blank cells in the Column ?

Sorry, I can't figure out what you mean here. Can you attach your file, showing what you mean by "dynamically number the not blank cells"?

Originally Posted by 6StringJazzer

Sorry, I can't figure out what you mean here. Can you attach your file, showing what you mean by "dynamically number the not blank cells"?

Agree my question is a bit ambiguous.

Attached is a screen shot.

Notice I circled Cell A20 & A21

If I Delete anyone of them, I have to edit the code for the rest of the cells (going down)
to compensate the deleted row. (even Insert will give me the same result.)

That is what I meant by a Dynamic way of numbering in case I need to Delete or insert a ROW

Hope this is more clear now.

In A2 (first cell below the header row), =max(A$1:A1)+1 and format as P-0

Originally Posted by shg

In A2 (first cell below the header row), =max(A$1:A1)+1 and format as P-0

Not too sure how it supposed to work with your formula !

This is what I am using to number the row
="A-"&(ROW()-1)

if I put your formula : =MAX(A$1:A1)+1
to the first cell, it has no effect.

Please advise.

In A2, enter the formula =MAX(A$1:A1)+1 and copy down. What do you see?

Originally Posted by shg

In A2, enter the formula =MAX(A$1:A1)+1 and copy down. What do you see?

the number " 1 "

That's in A2. What do you see when you copy the formula down several rows?

What do you see when you delete one of the formulas in the middle?

Please don't quote whole posts. Use the Reply button, not the Quote button.

I don't see anything different, except like what I have explained.

Step 1
In A2, Format Cells> Number Tab > Custom P-0 (that's a zero not an "O") "OK"

Step 2
In A2, =MAX(A$1:A1)+1
Drag or copy that down. See my attachment.
Is that what you are looking for?

That is exactly what I am looking for . Thanks a million

However,

Cell format does not populate the custom P-0 format at my end !


Attached is a DOC with screen shots.

I am using MS Office 2007