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 Query is case sensitive. Still I dedicate this tutorial for those who wish to know how to do a case sensitive DSUM in Google Sheets....
How to Use MAX Function in Google Sheets
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 use MAX function in Google Sheets. In addition to the above, you can learn how to use MAX function in a Filtered data 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 tutorial, let's learn how to use Vlookup across different sheet tabs in Google Sheets. That means, we can use Vlookup with search key in one...
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 Waterfall Chart in Google Sheets. I am following the latest approach in Google Sheets to create the Waterfall chart. It's quick, simple and even first...
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 FALSE in IFS, you may have already got some idea about this tutorial. By default, Google Sheets IFS function can't return a value when a logical...
Extract Multiple Words Using Regexextract
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 formula in Google Doc Spreadsheets. I think it's not necessary to explain why such type of text extraction is required as it purely depends your job....
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 am sharing you how to limit a column total within a specific value. I hope it can be a new addition to your spreadsheet use...
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 To" Command in Google Doc Spreadsheets. In Excel, it's easy to highlight cells with formulas with the Go To command (Ctrl+G) Special. This temporarily highlights the...