To get the larger, or greater, of two values, you can use the MAX function. In the example shown, the formula in D5 is:
=MAX(B5,C5)
How this formula works
The MAX function is fully automatic – it returns the largest...

Excel does not offer a "max if" function, so to get a maximum value based on criteria, you can use the MAX function together with the IF function.
This is an array formula and must be entered with Control + Shift +...

To find the position (row) of the last file revision in a table, you can use a formula based on several Excel functions: MAX, IF, ISERROR, ROW, and INDEX.
In the example shown, the formula in cell H6 is:
{=MAX(IF(...

To lookup information related to the the maximum value in a range, you can use a formula that comines the MAX, INDEX, and MATCH functions.
In the example shown, the formula in I8 is:
=INDEX(F3:F11,MATCH(MAX(C3:C11),...

To calculate the longest winning streak, you can use an array formula based on the frequency function.
Note: FREQUENCY must be entered as an array formula using Control + Shift + Enter
How this formula works
This is...

Context
You have a start time and an end time, and you want to know how many of the hours in between these two times overlap another time period in the day. For example, you want to know how many hours fall between 8:...

To get the position of the maximum value in a range (i.e. a list, table, or row), you can use the MAX function together with the MATCH function.
In the example shown, the formula in I5 is:
=MATCH(MAX(C3:C11),C3:C11,0...

To get the maximum value from a set of numbers, use the MAX function.
In the example shown, the formula in cell I6 is:
=MAX(C6:G6)
The MAX function is fully automatic. It accepts one or more arguments, which can be...

To force negative numbers to zero without affecting positive numbers, you can use a formula based on the MAX function.
In the example shown, the formula in D5 is:
=MAX(C5-B5,0)
How this formula works
This formula...

Note: these is an experimental formula that uses a hard coded array constant, set down here for reference and comment. Casually tested only, so take care if you use or adapt.
Sometimes you encounter data that mixes...