Sorry for poor grammer last time, In Excel, how do a seach for the bottom cell in a column.?

0 ⤊

Sorry for poor grammer last time, In Excel, how do a seach for the bottom cell in a column.?

2006-09-15 07:52:47 · 3 answers · asked by John R 2 in Computers & Internet ➔ Software

This is for reporting, so I need an excel formula that does it for me.

2006-09-15 08:12:38 · update #1

3 answers

Highlight the column, hold down the control key and press the down arrow.

2006-09-15 07:56:30 · answer #1 · answered by ijcoffin 6 · 0⤊ 0⤋

If you are just trying to get to the very last cell, hit Ctrl + the down arrow key a few times. Depending on how many empty cells you have in between cells with contents, it should take you there pretty quick.

2006-09-15 07:56:52 · answer #2 · answered by Elsie 2 · 0⤊ 0⤋

Do this
=match( offset( $B$1, count( $B:$B), 0,1,1), $B:$B,0)

good luck

Read my profile, I am the XLMan

2006-09-15 22:46:19 · answer #3 · answered by Anonymous · 0⤊ 0⤋