Formulas

### How to Use Pivot Table to Count Unique Values in Google Sheets

When dealing with large datasets in Google Sheets, duplicate values are commonly encountered. You might occasionally decide to focus just on the ...

### COUNTIF Function with “Not Equal to” Criterion in Google Sheets

Suppose you are working on a dataset where you need to find out the values which are not equal to the blank cell or a particular cell you are looking ...

### [Fixed!] COUNTIF Function Is Not Working in Google Sheets

The COUNTIF function is a fantastic tool for counting any values based on a single criterion, including text and numeric values. The COUNTIF function ...

### How to Get Opposite of Concatenate in Google Sheets (2 Ways)

Suppose you are working on a dataset where you get combined values. But while executing your work you need separated values in the dataset. So, if ...

### How to Concatenate Double Quotes in Google Sheets (3 Ways)

Google Sheets considers double quotes as text when you connect them in equations with text and the formula utilizes the text without the double ...

### Google Sheets Conditional Formatting with INDEX-MATCH

Conditional formatting is an excellent tool in Google Sheets to highlight specific data. In Google Sheets, the INDEX and MATCH functions allow you to ...

### How to Calculate Hours Between Two Times in Google Sheets

Calculating time duration is very necessary for the business and corporate sections.  In Google Sheets, you can easily track your time by applying ...

### How to Find Uncertainty of Slope in Google Sheets (3 Quick Steps)

From a slope of linear relationship, we can easily calculate the future values. Like, if a car is accelerating from rest at a constant 2 ms-2 we can ...

### How to Find Missing Values Between Two Columns in Google Sheets

Suppose you are working on two datasets at the same time. But the dataset is almost similar and there are some data missing in the second dataset. ...

### Google Sheets QUERY Function to Concatenate Two Columns

When trying to organize a group of data on a single page, Google Sheets' ability to combine columns may be quite useful. It can speed up production, ...

### How to Find Slope of Graph in Google Sheets (With Easy Steps)

We heard the term “Calculus”, didn’t we? One of the most important branches of mathematics. Not only in calculus but also in geometry, we need the ...

### How to Create Aggregate Chart in Google Sheets (with Easy Steps)

Different charts can summarize and represent data in different ways. Using the aggregate chart option in Google Sheets we can create those useful ...

### Conditional Formatting Between Two Values in Google Sheets

Sometimes while working on a dataset you need to highlight some specific data so that you get that data quickly. But completing this work manually is ...

### How to Subtract a Percentage in Google Sheets

In Google Sheets, you can subtract thousands of data at a time by applying functions and formulas. Though there is no specific function for ...

### How to SUMIF Between Two Dates in Google Sheets (3 Ways)

Efficiently tracking business performance is crucial, and one way to do this is by using the SUMIF function in Google Sheets to quickly and easily ...