Forum Discussion
Excel Function Question
Hi everyone, I have air pollution measurements taken every second and I am looking to find a way to achieve the following: - Find the median of every 9th, 10th, and 11th value It is a bit...
I didn't catch you'd like to find median for all such cells together, or for each 3 separately.
For such sample
if first
=AGGREGATE(19,6,1/(MOD(ROW($B$2:$B$45)-ROW($B$1)-2,10)>6)/(ROW($B$2:$B$45)>ROW($B$1)+1)*$B$2:$B$45,2)if second
=MEDIAN(INDEX($B$2:$B$45,(ROW()-ROW($F$1)-1)*10+{9,10,11}))and drag down