Forum Discussion
Solved
Please Help !! Median Range Formula
Hi - I am trying to get the median of a large number of values in a column range example rows (c.3000)- such that the formula ignores zero / errors or blanks. Additionally, I want to be able to apply...
=MEDIAN(FILTER(V9:V300,(V9:V300<>0)*(SUBTOTAL(102,OFFSET(V8,SEQUENZ(COUNT(V9:V300),,1),,,)))))