MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!