Easy one..?

G

Gromit

Hmmm, I need a formula because I'm building an Indirect function.

Unfortunately neither of these formulas work for columns>26...

The one I came up with is hardly very elegant:

=MID(ADDRESS(ROW(),COLUMN()),2,FIND("$",ADDRESS(ROW(),COLUMN()),2)-2)

Maybe there's no easy solution after all?

Cheers

Gromi
 
F

Frank Kabel

Hi
as a suggestion: Don't use the A1 reference style but the R1C1 style in
INDIRECT then. Set the second (optional) parameter of INDIRECT to
FALSE.
 
R

Ron Rosenfeld

Hmmm, I need a formula because I'm building an Indirect function.

Unfortunately neither of these formulas work for columns>26...

The one I came up with is hardly very elegant:

=MID(ADDRESS(ROW(),COLUMN()),2,FIND("$",ADDRESS(ROW(),COLUMN()),2)-2)

Maybe there's no easy solution after all?

Cheers

Gromit
Click to expand...

Well, the ADDRESS function takes numbers as it's argument, so perhaps if you
post the formula you are trying to come up with, we can come up with a more
elegant solution.


--ron
 
Top