Column A consists of date (ranging from Jan 2000 - till date)
Column B consists of value
Need to find following values of a month of a year
First
Max
Min
Last
First/last value can be in somewhere in the middle of the month. Not necessarily be in start/end (date) of a month.
I want something like this...
Date | First | Max | Min | Last
Jan-00 | 100 | 102 | 99 | 101
Feb-00 | 101 | 103 | 98 | 98
...
=MAX(IF(MONTH($A$1:$A$5)=4,B1:B5))
I tried this formula for Max value, but it just picks the max value of April (2000 - 2013). It's not finding specific month/year like Apr-13's max value...
Bookmarks