2006-09-15 08:20:33 · 5 answers · asked by John R 2 in Computers & Internet ➔ Software
This is the third time I answered this today
IT IS
=offset( $B$1, counta($B:$B) , 0,1,1)
Read my profile, I am the XLMan
2006-09-15 22:57:17 · answer #1 · answered by Anonymous · 1⤊ 0⤋
The closest I can come up with is to name the currently used cells and then use the rows function: =ROWS(name) to determine the number of rows being used. As long as rows are inserted instead of merely typing at the bottom, this will work.
2006-09-15 15:37:40 · answer #2 · answered by nospamcwt 5 · 0⤊ 0⤋
There is no formula that I am aware of that will do this. You would need to program it in Visual Basic for Applications. (Press Alt F11)
2006-09-15 15:23:44 · answer #3 · answered by teef_au 6 · 0⤊ 0⤋
Ctrl + C ---- Ctrl + V
2006-09-15 15:26:16 · answer #4 · answered by cutie-n-ny 1 · 0⤊ 0⤋
check for the last value ...
2006-09-15 15:22:23 · answer #5 · answered by Manis 4 · 0⤊ 1⤋