Dear Friends,
I am using a array formula to find the max and min values in a month and year between two columns.
Column E Column F
3/2/2015 3/22/2015
3/2/2015 3/22/2015
3/3/2015 3/23/2015
3/4/2015 3/10/2015
3/5/2015 3/11/2015
3/6/2015 3/25/2015
3/7/2015 3/30/2015
3/7/2015 3/30/2015
3/7/2015 3/30/2015
To find the Min of difference - =MIN(IF((MONTH(E5:E13)=MONTH(NOW())*(YEAR(E5:E13)=YEAR(NOW()))*(MONTH(F5:F13)=MONTH(NOW()))*(YEAR(F5:F13)=YEAR(NOW()))),F5:F13-E5:E13)),
Ans= 6.
To find the Max of difference - =Max(IF((MONTH(E5:E13)=MONTH(NOW())*(YEAR(E5:E13)=YEAR(NOW()))*(MONTH(F5:F13)=MONTH(NOW()))*(YEAR(F5:F13)=YEAR(NOW()))),F5:F13-E5:E13))
Ans= 23.
I want array formulas for the conditions:-
1.But with this formula i want to find the number of max value occurrence.
2. Number of Values above 3.
2. And if the "column F" is empty then it should calculate the values in the next "column G".
Kindly help me with this please.
Thanking you.
Bookmarks