theLEARNER1991
New Member
- Joined
- Mar 22, 2014
- Messages
- 15
Hi friends,
I wanted to find maximum and minimum between two dates, date is in column a7 to a2000, highest sales point for day is in column e7 to e2000,lowest sales point for day is in column f7 to f2000,starting date is computed in column o7 to o2000 and end date is in p7 to p2000.
maximum sales between o7 and p7 should in cell q7 minimum sales between minimum in same period should be in cell r7
maximum sales between o8 and p8 should in cell q8 minimum sales between minimum in same period should be in cell r8 and so on till row 2000...
I tried to use nested function but couldnt use it
the functin I used is
=MAX(IF($A$7:$A$2000>=O7,IF($A$7:$A$2000<=P7,$E$7:$E$2000))) But when i tried to enter function as nested function (by pressing ctrl+shift+enter) nothing happended.
I am using ms excel 2016.
hope you people would help me in this regard
Thanks in advance
I wanted to find maximum and minimum between two dates, date is in column a7 to a2000, highest sales point for day is in column e7 to e2000,lowest sales point for day is in column f7 to f2000,starting date is computed in column o7 to o2000 and end date is in p7 to p2000.
maximum sales between o7 and p7 should in cell q7 minimum sales between minimum in same period should be in cell r7
maximum sales between o8 and p8 should in cell q8 minimum sales between minimum in same period should be in cell r8 and so on till row 2000...
I tried to use nested function but couldnt use it
the functin I used is
=MAX(IF($A$7:$A$2000>=O7,IF($A$7:$A$2000<=P7,$E$7:$E$2000))) But when i tried to enter function as nested function (by pressing ctrl+shift+enter) nothing happended.
I am using ms excel 2016.
hope you people would help me in this regard
Thanks in advance