How to grab the last number in a column

[rickscolaro]

I asked this question last year and used the response successfully, but I forgot how to do it because I haven't used it in so long

How do you retrieve whatever is the last number in a column ( say a running total )?

Thanks again...I will store the formula somewhere, I promise....

 

[Datsmart]

You mean this post?
http://www.mrexcel.com/forum/showthread.php?t=362683

Quick search off of your name listed your posts.

 

[Ron Coderre]

The VALUE of the last NUMERIC value in Col_A:

=LOOKUP(10^99,A:A)

The VALUE of the last NUMERIC value in Row_1:

=LOOKUP(10^99,1:1)

Does that help?

 

[rickscolaro]

You mean this post?
http://www.mrexcel.com/forum/showthread.php?t=362683

Quick search off of your name listed your posts.

YES!! Thanks!! I also did a search and found out how to do the same thing for a range of cells too!
You guys are awesome....

Rick S.