Tag: Google Doc

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

How to Use MAX Function in Google Sheets [With Examples]

I have a spread sheet containing the names of cricket players who have scored more than 9999 runs in Test Cricket. I'm using this sheet as my example sheet to explain you how to...
How to Use Vlookup Across Different Sheet Tabs in Google Sheets

How to Use Vlookup Across Different Sheet Tabs in Google Sheets

Just make a search on this site to see plenty of Vlookup related tutorials vary from basic to advanced one. Here is another addition to these awesome Vlookup tutorials. In this Google Doc Spreadsheet...
How to Create a McKinsey Style Waterfall Chart in Google Sheets

How to Create a McKinsey Style Waterfall Chart in Google Sheets

Google has silently added Waterfall Chart in Google Sheets. That means, with one click you can now create Waterfall charts. Here in this Google Sheets tutorial, let's learn how to Create a McKinsey Style...