Google Docs

Usage of Google Sheets CELL Function and Examples

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...
Dynamic Ranges in Google Sheets Without Helper Cell

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...
How to Count Until a Blank Row in Google Sheets

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...
How to Use ADDRESS Function in Google Sheets

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...
Google Sheets LARGE Function and Difference With MAX

Google Sheets LARGE Function and Its 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...
How to Find Rank of a Non Existing Number in an Existing Data Range

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...
Array Based Running Total Formula in Google Sheets

Normal and 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...
How to Do a Case Sensitive DSUM in Google Sheets

How to Do a Case Sensitive DSUM in Google Sheets

It's possible to do a Case Sensitive DSUM in Google Sheets. But at the same time I wish to make it clear that you can use Query function to get the same result as...