Excel Forum

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

Got a Question? Ask it Here in the Forum.