Excel Forum
Similar Content
Average Cells Excluding Zeros in Excel
Tutorial: Exclude zeros while averaging cells in Excel. This method removes all zeros from the equa...
Return the Max Number from a Range That is Within a Minimum and Maximum Target Value in Excel - UDF
Macro: Return the highest number between two numbers that is in a range of cells with this UD...
Excel VBA Check if a Cell is in a Range
Tutorial: VBA that checks if a cell is in a range, named range, or any kind of range, in Excel. Sec...

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.