Functions

How to Add Up A Column in Google Sheets

Today, we will look at how to add up a column in Google Sheets. It is the most common form of calculation that any user does in a spreadsheet. But ...

Match Multiple Values in Google Sheets (An Easy Guide)

At a professional level, spreadsheet searches can get quite complex with the amount of varying data they might have. Thus, we have to look for viable ...

Match from Multiple Columns in Google Sheets (2 Ways)

Today, we will look at how to perform a match from multiple columns in Google Sheets. This process is useful if you want to extract values based on ...

INDEX-MATCH with Multiple Criteria in Google Sheets (Easy Guide)

We are already aware of how powerful the INDEX-MATCH combination is when extracting data in Google Sheets. If not, please visit our Using INDEX MATCH ...

Google Sheets: Conditional Formatting with Multiple Conditions

When we think about multiple conditions, the first thing that comes to mind is its logical formatting. So it comes to no surprise that when creating ...

Google Sheets: Conditional Formatting Row Based on Cell

Conditional formatting is quite a versatile function in any spreadsheet application. And today we will see the conditional formatting of a row/rows ...

Using Conditional Formatting With Custom Formula in Google Sheets

Today we will look at how we can use conditional formatting with custom formula in Google Sheets. Let’s get started. Basics of Using Custom ...

How to Apply a Custom Sort in Google Sheets

It is not uncommon that a spreadsheet user may need to apply custom conditions for sorting and organizing data. Understanding that, we will look at ...

Sort by Row in Google Sheets (2 Basic Ways)

There are no definite or built-in ways to sort by row in Google Sheets. All we can do is look for workarounds to sort this unique arrangement of ...

How to Sort by Value in Google Sheets (With Examples)

In this article, we will look at all the ways in which we can sort by value in Google Sheets. Let’s get started. The 2 Types of Values that ...

How to Sort by Number in Google Sheets (4 Ways)

In this article, we look at a few ways in which we can sort by number in Google Sheets. To fully cover everything, we have used multiple approaches ...

Using the SORT Function in Google Sheets (With Examples)

The SORT function in Google Sheets is a fundamental, yet very handy function to know about. And we are going to be breaking down its uses in this ...

SORT Function for Multiple Columns in Google Sheets

Today, we will look at how we can use the SORT function to sort for multiple columns in Google Sheets. We will look at different use cases that are ...

How to Sort Numerically in Google Sheets (3 Ways)

Today, we will look at the different ways to sort numerically in Google Sheets. We will be using both in-application options and functions to achieve ...

How to Sort by Multiple Columns in Google Sheets (3 Ways)

Today, we will look at how to sort by multiple columns in Google Sheets. While most users will think about the Sort Range option, which we will be ...

OfficeWheel
Logo