Highest value between two dates
On Sat, 15 Aug 2009 13:43:01 -0700, Geo wrote:
What formula would I use to find the highest value between two dates.
Date on col A
values on col B
This formula must be **array-entered**:
=MAX((Dates=StartDate)*(Dates<=EndDate)*Values)
----------------------------------------
To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. If you did this
correctly, Excel will place braces {...} around the formula.
--ron
|