In hindsight it's worth noting that the prior suggestion would be open to error should 2 numbers appear in the first column containing a number.
The present formula would return the lower of the 2 values as opposed to that appearing in the first row (if greater than value in row below).
Let me know if you need to account for this.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks