Address of last nonzero value
 

Hans,

here are some formulas for last cell:

http://www.mvps.org/dmcritchie/excel/lastcell.htm


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Hans Knudsen" wrote:

I have the following matrix formula
=ADDRESS(E2;MAX(IF(11:11<"";COLUMN(1:256);""));4)
In E2 I have a cell address, here A11 and the formula gives me the address
of the last nonzero cell in row 11, for example J11 (If E2 has the cell
address A12 the last value might be D12). What should the formula look like
if I want the first argument of the IF formula (here 11:11) to always
reflect the row number of of the cell address in E2?

Hans Knudsen