Reference to http://www.excelforum.com/excel-gene...ml#post2367964
I converted the example for calculating by day to calculating by month with
=MAX(FREQUENCY(IF((J$5:J$47>0)*(MONTH($B$5:$B$47)=2),ROW(J$5:J$47)),IF((J$5:J$47<=0)+(MONTH($B$5:$B$47)<>2),ROW(J$5:J$47))))
Attached is a sample. I have a main data with a few tabs for different months. In my actual spreadsheet, I have been using the function of --(TEXT(Main!$B$5:$B$47,"mmm")=$C$1 where $C$1 is a list of months. When $C$1 changes, all data will change according to the selected month.
How do I make $C$1 become "2" in MONTH(Main!$B$5:$B$47)=2 so that whenever I change the month in one tab, my winning streak will change accordingly?
Example: MONTH(Main!$B$5:$B$47)=Convertnumber($C$1), where Convertnumber($C$1) = 2 if $C$1 is selected to be Feb?
Bookmarks