Home Tags Spreadsheet

Tag: Spreadsheet

Find Product Price Based on Quantity in Google Sheets

0
A combination of Vlookup and Match or Xmatch is the best way to find the product price based on quantity in Google Sheets. All other...

XLOOKUP Visible (Filtered) Data in Google Sheets

0
This post describes how to use the XLOOKUP function in visible data in Google Sheets. We will use a Lambda LHF with the SUBTOTAL...

AGE_CALC – A Named Function to Calculate Age or Duration in Google Sheets

0
The purpose of the AGE_CALC Named Function is to return age in years, months, and days from a birth date to another date in...
REPT_ROWS Named Function - Google Sheets

REPT_ROWS Named Function to Repeat Rows in Google Sheets

2
You can repeat multiple rows n number of times using my REPT_ROWS function, a custom-named function, in Google Sheets. The n can be the same...
GANTT_CHART Named Array Function for Google Sheets

GANTT_CHART Function in Google Sheets (Named Function)

0
Do you want to illustrate your job schedule in a flash within a Google Spreadsheet? Using my custom GANTT_CHART named function, you can now create...
list_all_date_named_function

LIST_ALL_DATES Named Function in Google Sheets (Array Formula)

0
The purpose of the LIST_ALL_DATES custom-named function is to list all dates between a start date(s) and an end date(s) in Google Sheets. This function...