Home Blog
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 a series of posts related to Case Sensitive Formulas in Google Sheets. You can use the search field on the top navigation bar with the keyword "Case Sensitive" to fetch links to such posts. Advanced, Google...
Case Sensitive Reverse Vlookup
I believe Case Sensitive Reverse Vlookup Using Index Match is new to you. Reverse Vlookup in Google Sheets is Possible with Index / Match function combo. This is also called backward Vlookup in Google Sheets. But what about a Case Sensitive Reverse Vlookup in Google Sheets. Vlookup is the favourite function of all spreadsheets aspirants. But it has few drawbacks....
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 look around QUERY or SUMPRODUCT to do this. All you need is a FIND and COUNTIF combination. Needless to say Countif is a Case Insensitive Function. It treats "Apple" as well as "apple" as identical. Must Read:...
How to Use ISNUMBER Formula in Google Sheets
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 ISNUMBER can be a blessing in disguise at certain occasions. We can learn here not only the use of ISNUMBER formula in Google Sheets, but also its practical use. Syntax: ISNUMBER(value) Purpose: The purpose of ISNUMBER function is...
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 Sheets is not possible. But it's on the contrary. I will explain you how to do a Case Sensitive SUMIF in Google Sheets. No helper column or virtual helper column require in this case. Normally SUMIF...
Case Sensitive Vlookup in Google Sheets
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 possible to use functions like EXACT with VLOOKUP to make a case sensitive Vertical Lookup. Still Case Sensitive Vlookup in Google Sheets is possible. How? A Helper Column can solve this puzzle. If you are 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 see how to create a virtual helper column in Google Sheets. Before that you should know what is a helper column. So here we go. What is Helper Column in Google Sheets? Technically, there is no any...
How to Use Exact Function in Google Sheets
I think first we should know why Exact function in Google Sheets is essential. After that we can learn the use of it. Exact function is all related to case sensitive. When you came to know that majority of the spreadsheet functions are case insensitive, you will realise the importance of Exact function. What are the Case Insensitive Functions in...
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 as presentations. Why this function is required to fetch data from webpages? Can't we copy and paste data directly to Google Sheets? When you try to copy and paste data from a table that you found...
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 Google Sheets functions to create a multi row dynamic dependent drop down list. Why Dynamic Dependent Drop Down Lists Are Useful? I will explain you why a dynamic dependent drop down list in Google Sheets is a...

Inspirational - Random Posts

Inspirational Quotes for Everyday Life [Picture Quotes]

Again I'm back with some amazing inspirational quotes for everyday life. I sincerely hope it can help you to meet your everyday life's challenges...

Google Sheets - Random Tutorials

Add-ons – Another Reason to Try Google Doc Spreadsheet

Google Doc gets add-on support! Get new fonts, style sheets, functions, templates and more additional features in the form of add-ons on Google Doc. Google...