Positive MEDIAN
Posted by Artem on March 16, 2001 3:23 PM
Is there a way to find a MEDIAN in an array ignoring negatives and zeros? e.g. the MYMEDIAN of {-1,-3,0,-4,2,5,-3,7,-6,0} = 5 THANKS!
Posted by Ian on March 16, 2001 3:31 PM
How about entering the array formula =MEDIAN(IF(a1:a10>0,a1:a10). Hit control shift enter to enter it.
Posted by Artem on March 16, 2001 3:36 PM
That works. Thank you!
