Google Docs

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...
How to Group a Column Based on First Few Characters in Google Sheets

How to Group a Column Based on First Few Characters in Google Sheets

Grouping a column is very easy than you think in Google Sheets. All you need to know is the basic use of Query Function. But some times, you may want to group a data...