Google Sheets

Sort Data by Last Character in google sheets

Sort Data by Last Character in google sheets If you are an avid Google Sheets user, then you may have an urgent task to rank the text value by the last character from the cells; you can do this task manually very easily, which is also feasible, but only for sorting a small list of… read more »

Rank Data with Multiple Criteria in google sheets

If you are an enthusiastic Google Sheets user, then you may have an urgent task to rank a specified datelist based on given multiple criteria; you can easily perform this task manually, which is also feasible, but it only works for ranking a small amount of data. However, when there are multiple pieces of data… read more »

Rank Based on Specific Value in google sheets

This article will guide you how to sort the values in a given column based on a specific value in another column in google sheets. How to sort a range of values in google sheets by using IF function and COUNTIFS function based on a specific value in another column. Rank Based on Specific Value… read more »

Sort Dynamic Data in google sheets

 This article will talk about how to sort the dynamic data in google sheets automatically. How to use RANK formula to sort the data of a given dynamic range in google sheets. Sort Dynamic Data suppose you have a list of data in cell range A1:B5, and you want to sort the dynamic data in… read more »

Reverse Rank Order in google sheets

This article will talk about how to rank the given data in reverse order in google sheets. You can use Google sheets RANK function to rank the data. By default, the largest value in the data table will be ranked as 1. So how do we invert this ranking order? How do we make the… read more »

Rank Numbers without Repetitive Ranks in google sheets

This article will guide you how to rank numbers in a range with unique ranking in google sheets. How to use the Rank function in google sheets to get a unique ranking for ranges with duplicate values. Ranking without Repetitive Ranks Suppose you try to use the RANK function to rank values in a range… read more »

Rank Numeric Values with Duplicate in Google Sheets

Suppose you have an urgent task of ranking a list with duplicate values, what would be the first approach you would think of? Is there a quick and easy way to do this task in Google Sheets? This article will talk about how to rank a given list that contains duplicate values by using the… read more »

Google Sheets COUNTIF Function

This article will introduce you how to use the COUNTIF function in google sheets, and will show you a good example to better understand the usage of the COUNTIF function. Google Sheets COUNTIF Function Description The google sheets COUNTIF function is used to count the number of cells in a cell range that meet a… read more »

Google Sheets Rank Function

This article will introduce you how to use the RANK function in google sheets, and will show you a good example to better understand the usage of the RANK function. Google Sheets Rank Function Description The Google Sheets Rank function is used to return the ranking of a given number from a list. If there… read more »

Calculate Compound Interest using FV Function in Google Sheets

This article will show you how to calculate compound interest in Google Sheets. It will help you calculate the interest you will accrue on a given amount of money. There are several ways to calculate compound interest Google Sheets. One of the simplest is using the FV function in Google Sheets. This function determines the… read more »

Count Attendance and Absence with Google Sheets COUNTIF

In our campus life and work life, we usually record everyone’s attendance. Today we will introduce you the application of Google Sheets COUNTIF function to count the attendance. Using a week as an example, we use the following example to show you how to use Google Sheets COUNTIF function to count attendance. As shown above,… read more »

Find the Closest Data to the Data Provided in Google Sheets

In our daily work, we may encounter such an issue that to find the closest value to a certain value. In fact, google sheets internal functions can help us solve this problem. In today’s article, we will show you how to find the student whose score value is closet to the score provided with help… read more »

Google Sheets MAX function

This post will guide you how to use Google Sheets MAX function with syntax and examples in Google Spreadsheet. Description The Google Sheets MAX function returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array. The MAX function is a build-in function in Google Sheets and it is categorized… read more »

Basic Array Formula With Examples in Google Sheets

Are you searching for an article for getting the basic array formula with different examples for better understanding? Then congratulations because you have just landed on the right article. In this article, you would get to know the basic array formula in google sheets and the use of this formula in different examples with a… read more »

Google Sheets SUMIFS Function

This post will guide you how to use Google Sheets SUMIFS function with syntax and examples in Google Spreadsheet. Description The Google Sheets SUMIFS function sum the numbers in the range of cells that meet a single or multiple criteria that you specify. You can use the SUMIFS function to sum cells that based on… read more »

Google Sheets AVERAGEIFS Function

This post will guide you how to use Google Sheets AVERAGEIFS function with syntax and examples in Google Spreadsheet. Description The Google Sheets AVERAGEAIFS function returns the average of all numbers in a range of cells that meet multiple criteria. The AVERAGEIFS function is a build-in function in Google Sheets and it is categorized as a… read more »

Average Of Numbers With Multiple Criteria in Google Sheets

Have you ever come across a task to calculate the average of the numbers with respect to multiple criteria in google sheets? Are you tired of doing this cumbersome task manually? Are you willing to do this task smartly in just a matter of seconds? Then congratulations because you have just landed on the right… read more »

Calculate Average Of Last 5 Or N Values In Columns in Google Sheets

Suppose you come across a task where you need to calculate the average of the last 2 or 3 numeric values in google sheets, then what would you do? If you are new to google sheets, then your first attempt might be doing this task manually, which is an acceptable way but only when the… read more »

Find And Retrieve Missing Values in Google Sheets

Find and retrieve is a common basic operation in Google Sheets for tables. In out daily work, we may encounter this situation that some data was lost after several operations on a table in Google Sheets. In fact, we can find the missing values by retrieving the original data and comparing it with the existing… read more »

Google Sheets AVERAGEIF Function

This post will guide you how to use Google Sheets AVERAGEIF function with syntax and examples in Google Spreadsheet. Description The Google Sheets AVERAGEIF function returns the average of all numbers in a range of cells that meet a given criteria. The AVERAGEIF function is a build-in function in Google Sheets and it is categorized as… read more »

Sidebar