Using Last Value in a Column

Topic

New Reply

I have a worksheet where the columns are filled in with data periodically. I want to set up some sort of formula that uses the last non-blank value in a column.

e.g. if B22 is the last number, then that would be an argument in the formula; but next time I’d like B23 to be used in that same formula

Is there a rel. simple way to do that?

Thx!

Reply | Quote

Replies

See the replies to [post=”782412″]Post 782412[/post]

Reply | Quote

The solution Stuart is sending you to will find the value in the last cell in a column. If you want to reference the cell location, you can use:

=INDIRECT(“B”&INDEX(B:B,MATCH(9.99999999E+307,B:B,1))+1)

Change the +1 at the end of the formula to the row number of your header (or one less than the first row that contains data if you do not have a header row.

Reply | Quote

thx much!

Reply | Quote