Increment Letters (A+1 = B)

How do i increment the letters?
I want to be able to select cells A1, then B2, then C3 etc.
I can easily increment the rows, how do i increment columns?? thks

[Mark W.]

On 2002-02-20 06:50, Anonymous wrote:
How do i increment the letters?
I want to be able to select cells A1, then B2, then C3 etc.
I can easily increment the rows, how do i increment columns?? thks

=OFFSET(A1,1,1) is B2
=OFFSET(A1,2,2) is C3

...therefore, the formula...

=OFFSET($A$1,ROW(A1),ROW(A1))

...references B2, and as this formula is copied or filled down it references each sucessive diagonally adjacent cell (i.e., C3, D4, E5, etc.).


[ This Message was edited by: Mark W. on 2002-02-20 07:57 ]

[Juan Pablo González]

Also

=CHAR(65)

returns "A", 66 is "B", and so on.

[sadi]

How to Increment Letters after "Z" like excel column (AA, AB, AC etc) is it Possible.

Thanks

[tusharm]

It is a lot better to work with numbers instead of letters to identify both rows and columns. That way column 26 is column Z and column 27 is column AA.

Originally Posted by sadi

How to Increment Letters after "Z" like excel column (AA, AB, AC etc) is it Possible.

Thanks

[boim]

How to Increment Letters after "Z" like excel column (AA, AB, AC etc) is it Possible.

something like this perhaps?

=ADDRESS(ROW(),COLUMN(Z1)+1)

[sadi]

Thanks for reply

Can i get like A, B, C.... Z Than AA, AB, AC Like Excel column

Thanks again

[boim]

=LEFT(RIGHT(ADDRESS(1,COLUMN($Z$1)+ your increment here,4),2),1)

[sadi]

Thanks dear
But i want Like this, if A1 = A than A2 =B .... =Z than AA, AB (Same as a excel Column name a to z than aa, ab..az)

Thanks for reply

[boim]

You meant "then" not "than" ?

one possible way is:

=SUBSTITUTE(ADDRESS(1,COLUMN($A$1)+ B2,4),"1","")

where B2 is the amount of increment.

or put this from A1 down

=SUBSTITUTE(ADDRESS(1,ROW(),4),"1","")

Have you considered tusharm / Juan PG suggestions instead of trying whatever approach you're doing now?