Formulas > =MAX()
How to Use MAX() in Google Sheets
Description
How To Actually Use MAX() in Sheets
MAX(value1, [value2, ...])
Try MAX yourself
Use the MAX() function to find the highest value in the range B1:B10. Your formula should return that maximum value.
Hints (2)
-
Remember to select the correct range of cells.
-
The MAX function only works with numeric values.
6 Better Sheets Tutorials
Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4
Create awesome progress bars with sparkline formula. You can make progress bar colors can change based on the input.
COUNTIF()
MAX()
SPARKLINE()
TRUE()
Use Min and Max for More Average Averages
What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.
AVERAGE()
MAX()
MEDIAN()
MIN()
Use Index Match when you want Vlookup
If you find Vlookup a difficult formula to understand, this formula combination might be better. It's also much more flexible than Vlookup. Index/Match is the best. It's one of my favorite formula combinations.
INDEX()
MATCH()
MAX()
VLOOKUP()
Better Domain Portfolio Template
Create a better list of domains.
COUNTA()
FILTER()
INDEX()
MATCH()
MAX()
+1 more
Create a Summary Tab with Min and Max
Free tutorial for finding Minimum and Maximum data points.
INDEX()
MAX()
MIN()
How to Iterate Counting Blank Cells in Google Sheets
Count different types of blank cells. Cells with nothing in them.
ARRAYFORMULA()
IF()
ISBLANK()
MAX()
Learn more about the MAX() formula:
Generate a MAX() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MAX(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MAX() formula