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...
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...



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.