Find the Cell Address of a Last Used Cell in Google Sheets
There is no built-in functions to find the cell address of a last used cell in Google Sheets. But I've two custom formulas to do this. Keep one thing in mind if you opt to use any of them. Both formula may fall short of returning a perfect result if there is any blank cell in the 'primary' column...
Usage of Google Sheets CELL Function and Examples
Google Sheets CELL function is related to gathering limited information about any Cell in a Spreadsheet. But don't undermine this function as it can be a useful tool on certain occasions. In this new Google Sheets tutorial we can learn what are those information Google Sheets CELL function can return. To use CELL Function in Google Sheets, first you should...
Dynamic Ranges in Google Sheets Without Helper Cell
Here you can learn a unique way of creating DYNAMIC RANGES in Google Sheets. It's possible to create Dynamic Ranges in Google Sheets without Helper Cell. By saying Helper Cell, I mean the formula itself can handle dynamic ranges without referring to any additional cell. Similar: Virtual Helper Column in Google Doc Spreadsheets This is a combination of functions that make...
How to Count Until a Blank Row in Google Sheets
I decide to write this tutorial realising many people require such a formula for their different use. Today I faced one such situation where I want to identify the first blank row in my data range. I realised it can do with a count. Then how to count until a blank row in Google Sheets. Here we go. With the...
How to Use ADDRESS Function in Google Sheets
Honestly I thought It was a waste of my time for me learning the ADDRESS function in Google Sheets. But later I realised the worthiness of this function. I will come to that. First you should learn how to use Address Function in Google Sheets. After learning the use of this formula, we can go to an awesome tutorial...
Google Sheets LARGE Function and Difference With MAX
Google Sheets LARGE function is better than its MAX function. Both these functions are related to finding the Maximum value in a data range. You can say LARGE is just opposite to SMALL function. Purpose of Large Function in Google Sheets: LARGE Function Syntax: LARGE(data, n) When you want to find the nth largest value from a range or array, you can use...
How to Find Rank of a Non Existing Number in an Existing Data Range
Here is an advanced use of Google Sheets RANK function. I'm going to provide you a custom Google Sheets formula that you can use to find Rank of a non existing number in an existing data range. To explain this, let me directly go to an example. I've the score of few participants in a game as below in a...
Array Based Running Total Formula in Google Sheets
I've extensively used cumulative sum or running total to plot S Curves as part of Progress Reports related to my job. You can get a running total in Google Sheets in different ways. Here I am providing you three different formulas to do running total in Google Sheets. There are normal as well as array based running total formula...