Tag: Spreadsheet

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...
How to Return Value When The Logical Expression is FALSE in IFS

How to Return Value When The Logical Expression is FALSE in IFS

There is a major difference between Google Sheets IFS and IF. I'll explain you what's this difference and how to overcome it. From the title, how to return value when the logical expression is...
Extract Multiple Words Using Regexextract

How to Extract Multiple Words Using Regexextract in Google Sheets

We can extract multiple words in a cell into a row or column in Google Sheets. We can use a REGEXEXTRACT formula for this purpose. So learn the simple steps to extract multiple words using REGEXEXTRACT...
How to Limit a Column Total Within a Specific Value

How to Limit a Column Total Within a Specific Value

Some times you may want to limit the total amount in a column within a specific rage. I can give you several real life examples to this specific use. So, in this tutorial I...
How to Highlight All the Cells with Formulas in Google Sheets

How to Highlight All the Cells with Formulas in Google Sheets

Many Google Spreadsheet users think that it's not possible to highlight all the cells with formulas in Google Sheets. But it's possible. They may think so because there is no alternative to Excel's "Go...