Forum Discussion
Return the address of last cell by formulas
So I just learned that Ctrl + End will bring you to last used cell in excel (which is very useful, right?). Is there a way to refer to that cell in formulas? No VBA allowed. Or can I refer to la...
=MAX((A1:A1000480<>"")*ROW(1:1000480))
=MAX((1:1<>"")*TRANSPOSE(ROW(1:16384)))
=ADDRESS(F5,F8)
Do you want formulas like these? See attached file.