Spreadsheet

Highlight Cells based on multiple Conditions in Google Sheets

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 Conditions in Google Sheets. Here I meant to say two...
How to Highlight Only Texts in Google Sheets

How to Highlight Only Texts in a Column or Row in Google Sheets

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 a vital role in data cleaning and with this tutorial,...
How to Use Month Function in Google Sheets Query

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 Date Functions, the Month Scalar Function behaves differently in Query....
How to Use ISREF Function in Google Sheets

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. It just checks a value for a valid cell reference...
How to Do a Case Sensitive Sumproduct in Google Sheets

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...
Case Sensitive Reverse Vlookup

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 function combo. This is also called backward Vlookup in Google...
Perform a Case Sensitive COUNTIF in Google Sheets

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 look around QUERY or SUMPRODUCT to do this. All you...
How to Use ISNUMBER Formula in Google Sheets

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 ISNUMBER can be a blessing in disguise at certain...