Finding the address of the last "Non-Empty" cell in the first row

[Jackcell]

Hi all,

I would like to find the last non-empty cell in the first row. Is there anyway possible in doing so?

Cheers,
Jack

 

[mrhstn]

Hi Jack

For the address in the first in the first row:

=ADDRESS(1, LOOKUP(2, 1/(1:1<>""), COLUMN(1:1)))

 

[arthurbr]

If you need the cell's address in a function/formula, use INDEX(1:1;1;MAX(MATCH({"ZZZZZZZZZZZZZZZZZZZZ";9,99E+307};1:1))) as reference. No address needed

 

[Aladin Akyurek]

Address last numeric cell:

=CELL("address",INDEX(1:1,MATCH(9.99E+307,1:1)))

Address last text cell:

=CELL("address",INDEX(1:1,MATCH(REPT("z",255),1:1)))

Address of the last non-empty cell (with any value), control+shift+enter, not just enter:

=CELL("address",INDEX(1:1,MATCH(9.99E+307,1/(1-ISBLANK(1:1)))))