Quote:
Originally Posted by ArviLaanemets
So what you really want, is the last value greater than current one. The max previous value can be somewhere before Jan 11.
Another thing is, you are speaking about dates, but you are checking row-wise. What is 'previous' for you - the previous date, or previous row. What happens when the table is rearranged (sorted) by some other column. In case you check not date-wise, but row-wise, your formula's results most probably will be entirely different.
|
You are correct, the max value can be before Jan 11 and is in my example, but the defining criteria I am interested in capturing the last max value, which is cell B15 or 26. So to answer, I dont intend to sort any of the columns, and I dont really want to check row wise, I want to check by the date and display the last max value as well as the date it occured. Thanks