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:V2999],([V9:V2999]<>0)*(SUBTOTAL(102,OFFSET[[V9,ROW(V9:V2999],[V9:V2999]],SEQUENCE(COUNT([V9:V2999]),,1),,,)))))
I tried this but its not working
Where you have a header I begin at row 9 and the header is dynamic as linked to a data source
Could you help me solve
=MEDIAN(FILTER([V9:V300],([V9:V3000]<>0)*
(SUBTOTAL(102,OFFSET[[V8,SEQUENCE(COUNT([V9:V300]),,1),,,)))))It seems you mixed up two formulas. It's either ROW() or SEQUENCE() but not both.
Hi Detlef - thanks so much for assistance and reply - I tried this in cel ref attached, but am getting error.
=MEDIAN(FILTER(V9:V300,(V9:V300<>0)*(SUBTOTAL(102,OFFSET(V8,SEQUENZ(COUNT(V9:V300),,1),,,)))))
