I have values in cells E1, E2 E3 & E4. Cells E5 thru E50 are blank. Is there a formula that will return the value of the last cell with a value into Cell E51?
Values will be added to Cells E5 etc. and I want the last value to be returned to E51.
I have values in cells E1, E2 E3 & E4. Cells E5 thru E50 are blank. Is there a formula that will return the value of the last cell with a value into Cell E51?
Values will be added to Cells E5 etc. and I want the last value to be returned to E51.
Welcome to the board.
In E51, =index(e1:e50, match(9e307, e1:e50))
Entia non sunt multiplicanda sine necessitate
Hi, welcome to the forum
Another option...
=INDEX($E$1:$E$20,MATCH(0,$E$1:$E$20,-1))
Note, both shg's and my suggestions will only work with numbers, not text
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks guys, I would not have figured that out. I am using numbers, not text. thanks again
Here's another one...
=LOOKUP(1E100,E1:E50)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Great, the shorter the better!
Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks