2014-04-14

EXCEL - Median calculation (conditional on range matching a value)

=MEDIAN(IF(AR:AR=AY14,AI:AI ))

=MEDIAN(
IF(
RANGE_WITH_DATA_TO_FILTER_BY = VALUE_TO_FILTER_WITH
, RANGE_WITH_NUMERIC_VALUES_TO_CALC_MEDIAN_FOR
)
)
By

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)