### 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

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

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...

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 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

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...

### 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

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...