|
Featured Tutorial
Featured Macro
Excel Magic Trick 344: MAX IF & RANK functions without Zeros
Max value when there is more than one criteria. See how to extract the maximum weights for each wrestler and then rank then while giving a 0 score the phrase No Lift. See the MAX, IF and RANK functions in an array formula.
Max If, more than one condition, more than one 1 criteria.
Other videos at youTube: Mode if STDEV if MEDIAN IF
Max If, more than one condition, more than one 1 criteria.
Other videos at youTube: Mode if STDEV if MEDIAN IF