How to Freeze Cell in Importrange in Google Sheets [Lock Cell...

Normally locking cell reference is not possible with Google Sheets Importrange function. But there are two workarounds. You can freeze cell in Importrange in...

How to Highlight Cells based on multiple Conditions in Google Sheets

I know the title is bit confusing for you. So let me first explain what I meant by saying Highlight Cells based on multiple...

How to Highlight Only Texts in a Column or Row in...

Let's see How to Highlight Only Texts in Google Sheets. I am beginning few Google Sheets tutorials related to conditional formatting. Conditional formatting can play...

How to Use Month Function in Google Sheets Query

You can use MONTH function in Google Sheets Query to return month number from Date. Compare to the Month Function which is part of...

How to Use ISREF Function in Google Sheets [Formula and Examples]

People get confused over the use of ISREF function in Google Sheets. In real sense, the ISREF function in Google Sheets has limited role....

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...

Inspirational - Random Posts

20 Quotes That Can Help You to Rebuild Your Lost Confidence

As a blogger I'm greatly inspired by quotes of people who were tasted the bitterness of failure but succeeded eventually in achieving great level of...

Google Sheets - Random Tutorials

Restrict or Force Text Entry to All Caps, All Lower Case...

In Google Sheets you can restrict or control the input of data using Data Validation. You can validate the entry in several ways. Here...