HomeGoogle DocsSpreadsheetHow to Use MAX Function in Google Sheets

How to Use MAX Function in Google Sheets [With Examples]

Published on

I have a spreadsheet containing the names of cricket players who have scored more than 9999 runs in Test Cricket. I’m using this sheet as my example sheet to explain to you how to use MAX function in Google Sheets.

In addition to the above, you can learn how to use MAX function in a Filtered data in Google Sheets and also how to exclude hidden rows in MAX.

I’ve just imported the above-said sample data from a Wikipedia page with an IMPORTHTML formula. Below is that awesome Google Doc Spreadsheet Formula.

IMPORTHTML("https://en.wikipedia.org/wiki/List_of_players_who_have_scored_10,000_or_more_runs_in_Test_cricket","table",1)

This imported data has so many columns. I have limited the number of columns by additionally using a Query as below. So you can use the below formula for this test.

=query(IMPORTHTML("https://en.wikipedia.org/wiki/List_of_players_who_have_scored_10,000_or_more_runs_in_Test_cricket","table",1),"Select Col2, Col3, Col8")

The below is that sample data which we were talking about.

Max Function in Google Sheets Example

Max Function Syntax

MAX(value1, [value2, …])

How to Use MAX Function in Google Sheets

In the above example, you can use a Max formula in Column C as below to return the highest run scorer in the list.

=Max(C2:C)

It’s that much easy. You can use the arguments in MAX function as comma separated as below which would return the result 12 as it’s the highest value in the example below.

=MAX(10,5,12,4,1,5)

Finally, let us see the use of MAX in filtered data range in Google Sheets.

How to Use MAX Formula in Filtered Data in Google Sheets

When you want to find the maximum value in a filtered data you can use the Max Function number 104 in Subtotal as below.

=subtotal(104,C2:C14)

This’s applicable to hidden rows also.

I suggest all should learn Google Sheets Subtotal function with function numbers. I’ve already detailed how to tame hidden rows or filtered data with the SUBTOTAL function. See the link to that tutorial.

Must Read: What is Function Numbers in Google Sheets

That’s all for now. Enjoy.

Prashanth KV
Prashanth KVhttps://infoinspired.com/about-me/
Introducing Prashanth KV: Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Creating a Running Balance with Dynamic Array Formulas in Excel

For calculating a running balance, we can utilize the SCAN function, which is a...

Comparing the FILTER Function in Excel and Google Sheets

I believe comparing the differences in how the FILTER functions work in Excel and...

Quartile IF in Google Sheets

To calculate quartiles based on conditions, referred to as "Quartile IF," we will use...

Drop Rows and Columns by Index Numbers in Google Sheets

With the help of two simple custom formulas, we can drop rows and columns...

More like this

Quartile IF in Google Sheets

To calculate quartiles based on conditions, referred to as "Quartile IF," we will use...

Drop Rows and Columns by Index Numbers in Google Sheets

With the help of two simple custom formulas, we can drop rows and columns...

Reference a Column by Field Label in Google Sheets QUERY

Here we'll explore the two best methods for referencing a column by its field...

LEAVE A REPLY

Please enter your comment!
Please enter your name here