top of page

Google Sheets Max Formula: A Comprehensive Guide

Struggling to find the highest number or latest date in a Google Sheet? Look no further.


From basic number comparison to finding the most recent date in a dataset, this guide has you covered.


We will show you how to use the Google Sheets MAX formula in no time!


In this guide, you'll learn how to:

  1. Use the MAX formula to find the highest number in a range

  2. Apply MAX across multiple columns and rows

  3. Use MAX to find the latest date in a list

  4. Incorporate MAX in more complex Google Sheet functions

A guide to using the MAX formula in Google Sheets


Basics of the MAX Formula in Google Sheets


Before diving into the examples, let's get familiar with the MAX formula's basic syntax:


The formula typically looks like this:

=MAX(number1, [number2, ...])

Here, number1, number2,... can be numbers, cell references, or a range of cells. Pretty straightforward, right?


Now, let's move on to the examples.


Follow the examples by copying the spreadsheet.



1. Finding the Maximum Number in a Range


The most basic use of the MAX formula involves finding the highest number in a specified range.

Using the MAX function to find the highest number in a range

Example:

Say you have test scores in cells A2 to A6. You want to find the highest score.


  1. Select the cell where you want the highest score to appear, for instance, D2

  2. Type =MAX(A2:A6) and press Enter


The highest score from A2 to A6 will instantly appear in cell D2.



2. Applying MAX Across Multiple Columns and Rows


Sometimes, you might want to find the maximum value from a 2D range, covering multiple columns and rows.

Applying the MAX formula across many columns and rows

Example:

Suppose your data ranges from A2 to C6.


  1. Choose a cell for your result, say F2

  2. Enter =MAX(A2:C6) and press Enter


The highest number in that 2D range will be displayed in F2.



3. Using MAX for Date Values: Finding the Latest Date


You're not limited to numbers; the MAX formula can also help you find the latest date in a range.

google sheets max date

Example:

Imagine you have dates from A2 to A11 and want to find the most recent one.


  1. Select the cell where you want the latest date to show, like D2

  2. Type =MAX(A2:A11) and press Enter


Google Sheets will display the latest date from A2 to A11 in cell D2.



FAQ

What is the MAX Formula?

The MAX formula is a simple yet powerful function in Google Sheets that returns the highest number in a range of cells. Essentially, it checks a series of numbers you provide and points out the highest one for you.

Why Use the MAX Formula?




Comentarios


bottom of page