%mode init A1:5 A2:2 A3:3 A4=8 A5:1 A6=6 A7:7 A8=4 A9:9 A10:10 A12=MEDIAN(A$1:A1) A13=MEDIAN(A$1:A2) A14=MEDIAN(A$1:A3) A15=MEDIAN(A$1:A4) A16=MEDIAN(A$1:A5) A17=MEDIAN(A$1:A6) A18=MEDIAN(A$1:A7) A19=MEDIAN(A$1:A8) A20=MEDIAN(A$1:A9) A21=MEDIAN(A$1:A10) A22=MEDIAN(1,9,2,3,5) A23=MEDIAN(4,2,1,3) A24=MEDIAN(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10) A25=MEDIAN(42) B1=TRUE() B2=FALSE() B3=TRUE() B5=MEDIAN(B1:B3) B6=MEDIAN(B1:B2) %calc %mode result A12=5 A13=3.5 A14=3 A15=4 A16=3 A17=4 A18=5 A19=4.5 A20=5 A21=5.5 A22=3 A23=2.5 A24=5.5 A25=42 B5=1 B6=0.5 %check