Address of last nonzero value in a range
 

Maybe something like this (in sections for readability):

=ADDRESS(ROW(INDIRECT(E2)),MATCH(2,INDEX(1/(
INDIRECT(MID(REPT(":"&LOOKUP(10^99,--RIGHT(
E2,{1,2,3,4,5})),2),2,255))<""),0)),4)

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"Hans Knudsen" wrote:

I have the following matrix formula
=ADDRESS(E2;MAX(IF(16:16<"";COLUMN(1:256);""));4)
E2 holds a cell Address, for example A16 and the above formula then gives me
the address of the last nonzero cell in row 16. What should the formula look
like if I want to let the first argument of the IF formula (here 16:16)
reflect the row number of the cell address specified in cell E2?

Regards
Hans Knudsen