Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
The LARGE function in Google Sheets returns the n-th largest value from a dataset.
For example, you could use large to determine the 5th largest value in a dataset, the 10th largest, the 50th largest, etc.
The formula to find the 5th largest value in this example is:
=LARGE(A1:A10,5)🔗 Get this example and others in the template at the bottom of this article.
The SORTN function in Google Sheets sorts your data and returns the first n results.
One common use case is to find the top n or the bottom n values in a dataset.
For example, here’s how you use SORTN to extract the top 5 values in a dataset:
with this formula:
=SORTN(A2:C21,5,0,3,FALSE)🔗 Get this example and others in the template at the bottom of this article.
In this post, you’ll learn how to find and highlight the top 5 values in Google Sheets.
For all the examples that follow, we’ll use this dataset, which is available in the downloadable template at the end of this post:
We’ll see how to highlight the rows with the top 5 values, as well as how to extract those values using SORTN.
Continue reading How To Highlight The Top 5 Values In Google Sheets With Formulas
The Google Sheets checkbox is an interactive widget in a cell that can be checked or unchecked.
A checkbox in Google Sheets has a value TRUE when checked and FALSE when unchecked.
Checkboxes open up all sorts of opportunities to make your Sheets more interactive, which you’ll see further down this post. All the examples are also available in the free template linked at the bottom of this post.
In this post, we’ll look at how to mimic radio buttons with formulas and checkboxes in Google Sheets.
This formula method has one limitation: you have to uncheck the current selection before you can check a different one.
With true radio buttons, when you click any button it will unselect the other one for you. You don’t have to do the extra step of manually unselecting it first.
For that reason, I recommend using an Apps Script method to create true radio buttons in Google Sheets.
However, the formula method presented in this post is useful if you don’t have access to Apps Script or simply don’t want to add code to your project.
Continue reading How To Mimic Radio Buttons With Formulas and Checkboxes
