How to Do a Case Sensitive Sumproduct in Google Sheets

Case Sensitive Sumproduct is possible in Google Sheets but not the way you are doing it in Excel. I'll come to that. I've recently written...

Case Sensitive Reverse Vlookup Using Index Match in Google Sheets

I believe Case Sensitive Reverse Vlookup Using Index Match is new to you. Reverse Vlookup in Google Sheets is Possible with Index / Match...

How to Perform a Case Sensitive COUNTIF in Google Sheets

Earlier we have learned the use of Case Sensitive SUMIF. Likewise, we can also use Case Sensitive COUNTIF in Google Sheets. No need to...

How to Use ISNUMBER Formula in Google Sheets [Practical Use]

You may wonder why this tutorial about ISNUMBER is required as this function is so simple to use. Just wait! I will tell you...

How to Do a Case Sensitive SUMIF in Google Sheets

It's possible to do case sensitive SUMIF in Google Sheets! Yes, you heard it right. Many people think that Case Sensitive SUMIF in Google...

Case Sensitive Vlookup in Google Sheets [Solved]

As you know Vlookup function is case insensitive. That means it treats small case as well as upper case letters as same. It's not...

How to Create a Virtual Helper Column in Google Sheets

In this tutorial I am trying to make you clear the virtual helper column concept in Google Sheets and its pros and cons. Let's...

How to Use Exact Function in Google Sheets [Case Sensitive and...

I think first we should know why Exact function in Google Sheets is essential. After that we can learn the use of it. Exact...

How to Use IMPORTHTML Function in Google Sheets [Advanced Use]

I think the IMPORTHTML function in Google Sheets is very useful for collecting data form external webpages like Wikipedia for creating different charts as well...

Multi Row Dynamic Dependent Drop Down List in Google Sheets

We can create multi row dynamic dependent drop down list in Google Sheets that without Scripts. I am just going to use only built-in...

Inspirational - Random Posts

Aesop’s Fables Children Quotes, Morals and Sayings

Aesop's Fables has plenty of moral stories for all age group. So we tried to bring the essence of such moral stories and sayings...

Google Sheets - Random Tutorials

How to Use IMPORTFEED Function in Google Sheets

You can create your own feed reader to read the latest contents from your favourite blogs. With IMPORTFEED function in Google Sheets, you can...