I have a large array of data which has intermittent zero values in it where
the data has not been acquired. I want to create a generic formula which I
can copy down one column that gives me the median average of the data in one
row, but does not include zero values. I have been able to do this for the
mean average by using the formula =(SUM(A1:Z1))/(COUNTIF(A1:Z1, "<0")), (if
there is an easier way, let me know) but I cannot see a way of doing
something similar for the median. BTW, i have tried deselecting 'zero values'
in the options tab but it merely hides the zeroes, and still uses them in the
calculations.

Any thoughts gladly appreciated.