Feb 02 2019 09:43 AM
Feb 02 2019 09:56 AM
SolutionHi,
You may use array formula (Ctrl+Shift+Enter to enter it)
=MEDIAN(IF(A2:A78<=60,A2:A78,""))
or regular one
=AGGREGATE(16,6,A2:A78/(A2:A78<=60),0.5)
Feb 02 2019 09:56 AM
SolutionHi,
You may use array formula (Ctrl+Shift+Enter to enter it)
=MEDIAN(IF(A2:A78<=60,A2:A78,""))
or regular one
=AGGREGATE(16,6,A2:A78/(A2:A78<=60),0.5)