I would like to have an Excel formula that will return the last populated cell in a range that is >0. For example, in column E, I have a range for data from E1:E20 I would like to have a formula in cell E25 for example, that would return the last number populated in the range of E1:20 that is greater than 0. If data is entered in cells E1 to E15, I would like the formula to return the data in E15 if that is the last number entered in the range. Thanks.
Last edited by RDMRDM; 05-08-2009 at 05:14 PM.
Try this...
Place it in the cell you want the results in.
Please Login or Register to view this content.
NOTE: It will result with the last NUMBER...ignoring any alpha entries
Hope that helps,
GWB
I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!
Please mark your threads as Solved once it is solved. Check the FAQ's to see how.
Lots of useful suggestions here for last value in numeric ranges, text ranges, and mixed ranges:
http://www.ozgrid.com/forum/showthread.php?t=68869
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
To get the last number > 0 try
=LOOKUP(2,1/(E1:E20>0),E1:E20)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks