Ok please help recommend a formula to do this.
I have 1 column into which different numbers will be entered. I need to write a formula that will return the value inside the lowest (by low I don't mean numerically lowest, I mean vertically on the screen the lowest) positive cell within that column. For instance:
A
1 55
2 0
3 59
4 0
5 75
So if I select A1:A5, I want the formula to return the value within A5, which is 75. If I delete the 75, the formula would then return 59, because it is the lowest (on the vertical axis) positive value.
Can this be done?
Bookmarks