Main Profile

At A Glance

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
Length: 06:31

Contact

Questions about Excel Magic Trick 344: MAX IF & RANK functions without Zeros

Want more info about Excel Magic Trick 344: MAX IF & RANK functions without Zeros? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question