Hi, hope you can help me with a questions.
I have five number in five cells. I have to calculate the median of them like 3,5,6,8 and 10 and the result of this should be 6, right.
But sometimes on of those numbers are unknown and i just put (0) instead of it like 3,5,0,0,10 and the result is 3, right.
But the result should be 5 because 0,0 are not numbers in fact.
So, i need that the function MED (or other way) skip the 0 number.
Is that possible? Thank you much for your atention.![]()
Bookmarks