Spreadsheet

How to Use the function ISFORMULA in Google Sheets

How to Use the Function ISFORMULA in Google Sheets

Straight to the point. Learn how to use the function ISFORMULA in Google Sheets. Actually there is nothing in detail to learn about this function. So I'm directly going to the syntax part, purpose...
How to Use MINA Function in Google Sheets

How to Use MINA Function in Google Sheets and Difference With MIN

MINA is a statistical function in Google Sheets to find the minimum value in a range. Don't use this function as an alternative to MIN or SMALL. Let's see how to use MINA function...
How to Use IF Function to Test a Sentence for a Text

How to Use IF Function to Test a Sentence for a Text in Google...

You can learn here an awesome trick using IF, the popular Logical Test function in Google Sheets. With this tutorial titled how to use IF Function to test a sentence for a text, I...
Extract Top N Number of Items From a Data Range

Extract Top N Number of Items From a Data Range in Google Sheets

I have a sales report in Google Sheets where I want to extract only the top 5 items based on sales volume. Is it possible, and if possible, how to do that? Yup! It's...
Find Minimum Value and Return Value from Another Column

Find Minimum Value and Return Value from Another Column [Google Sheets]

As you know, the function MIN can return minimum value in a numeric data set. But the question is can we use MIN to return adjacent cell values other than minimum value? Didn't get?...
How to Use MIN Function in Google Sheets

How to Use MIN Function in Google Sheets and Difference with SMALL

There are several functions focusing on the minimum values in Google Sheets. You can find Database as well as statistical functions in the list. SMALL, MIN, MINA, DMIN are some of them. You can...
How to Exclude 0 From MIN Function Result in Google Sheets

How to Exclude 0 From MIN Function Result in Google Sheets

If you ask me what is the solution to exclude 0 from MIN function result in Google Sheets, my answer would be either by using a Filter function or a QUERY function together with...
Use Dynamic Ranges in SUMIF Formula in Google Sheets

How to Use Dynamic Ranges in SUMIF Formula in Google Sheets

You can use dynamic Ranges in Google Sheets formulas with the help of the OFFSET function. By saying Dynamic Ranges, I mean the range in a formula that accommodates values in any rows that...

Google Sheets Formulas

How to Find Distinct Rows in Google Sheets Using Query

Here I am talking about distinct rows not unique rows. Yes, we can find distinct rows in Google Sheets using Query. I know I...

Inspiration

10 Best Pleasant Quotes with Pictures to Kick Start Your Day

"Be pleasant until Ten O'clock in the morning and the rest of the day will take care of itself," American writer Elbert Hubbard once...