Home Tags Google Doc

Tag: Google Doc

Finding the Last 7 Working Days in Google Sheets (Array Formula)

0
This post contains the formula to find the last 7 working days from the current date in Google Sheets and its explanation. If you have...

XMATCH Function in Google Sheets (Formula Examples)

0
The XMATCH is one of the functions in the recently launched function bundle that includes XLOOKUP, LAMBDA, and Lambda helper functions (LHF) in Google...

How to Use the XLOOKUP Function in Google Sheets

0
The purpose of the XLOOKUP function in Google Sheets is to find things in a range by row or column. For example, you can...

How to Use the MAKEARRAY Function in Google Sheets

3
This post is about the MAKEARRAY Lambda function in Google Sheets. It requires a LAMBDA or a Named Function as input. When I went through...

How to Use the MAP Function in Google Sheets

0
The MAP function in Google Sheets maps each value in an array(s) to a new value by applying a LAMBDA function. As far as I...

How to Use the REDUCE Function in Google Sheets

0
The REDUCE function in Google Sheets is easy to understand if you know the SCAN function. Do you know why? Both are LAMBDA helper functions...