Tag: Spreadsheet

How to Total on Each Changes in a Column Value

In Google Sheets How to Total on Each Changes in a Column Value

As of now, there is no option in Google Sheets similar to Excel's Group or Subtotal command. This command enables users to add total on each changes in a column value. In Google Sheets the...
How to Convert Month in Number to Month Name in Text

Google Sheets Query: How to Convert Month in Number to Month Name in Text

Month wise summary is something you may badly require to create monthly reports in your office. In Google Sheets, it’s possible in so many ways. The most efficient way of crating month wise summary...
How to Expand Count Results in Google Sheets

How to Expand Count Results in Google Sheets Like Array Formula Does

There are chances that you want to count the values in a row instead of an entire range and auto repeat the same in other rows. See the below image where I've highlighted the...
How to Use Google Sheets MAXIFS Function

How to Use Google Sheets MAXIFS Function [Practical Usage]

The advantage of Google Sheets MAXIFS function is its multiple conditions filtering capability unlike MAX or LARGE. There are alternative functions in Google Sheets that can give you the same result. For example you...
MMULT Instead of SUMIF in Google Sheets for Array Result

MMULT Instead of SUMIF in Google Sheets for Array Result

This tutorial is in line with my earlier tutorial where I've detailed the use of criteria in MMULT. In that tutorial, I've explained how to use criterion in MMULT especially as equal to SUMPRODUCT and return...
How to Use MINIFS Function in Google Sheets

How to Use MINIFS Function in Google Sheets [Advanced Use]

Do you know where to use MINIFS function in Google Sheets? When you want to return a minimum value based on certain criteria you can use MINIFS. I think the word MIN IF also...
Conditional MMULT in Google Sheets

How to Do Conditional MMULT in Google Sheets [MMULT with Criterion]

You can use Condition or Criteria in MMULT in Google Sheets similar to SUMIF or SUMPRODUCT. This's little tricky. So this time I'm with you with a new tutorial on how to do conditional...
Find the Cell Address of a Last Used Cell in Google Sheets

Find the Cell Address of a Last Used Cell in Google Sheets

There is no built-in functions to find the cell address of a last used cell in Google Sheets. But I've two custom formulas to do this. Keep one thing in mind if you opt...