Quote:
Originally Posted by Claus Busch
Hi Rune,
Am Thu, 14 Nov 2013 08:33:52 +0000 schrieb RuneVSP:
Date Temp
1oct 10
2oct 10
3oct 12
4oct 10
5oct 14
B10=2oct
B11=4oct
try:
=MAX((A2:A6=B10)*(A2:A6<=B11)*(B2:B6))
and array-enter the formula with CTRL+Shift+Enter
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Thanks you it worked out fine, for the max. However the minimum and median cannot be identified this way. I gues it is due to the fact that my product is 0 in most cases.. Any idea how i can expand so i can also find these two parameters