How to VLOOKUP from bottom with IMPORTRANGE...

More compact or better way to write a function that SUM multiple COUNTIFS with same criteria...

Group data by columns and show all rows that meet criteria...

Use custom MD5 formula with ARRAYFORMULA...

How to use a custom function in an ARRAYFORMULA for a range of cells?...

Excel: Dynamic range within certain rows + data validation update...

Aggregating by columns and then by rows in Google Sheets without adding columns...

Put column data in rows grouped by ID...

Google Sheets regex keep part of text in each cell...

query against concatenated array in Google Sheets...

Why vlookup in excel either returned NA or mismatched?...

A formula to look up values in column depending on dropdown...

Does ARRAYFORMULA in Google Sheet Distinguish Between Hard-Coded Ranges and CONCATENATEd Ranges...

Remove " and =+ from cells in Google Sheets...

How to make Google Sheets search a range and return -all- rows that are "partial duplicates&quo...

How to transpose this data in Google Sheets...

Split and Join with special symbol...

How to create an Google Sheets arrayformula which contains ranges...

How can I dynamically fill a column in Google Sheets that is producing the smallest date value from ...

Search a range and bring back a stacked column of results...

How to use the Growth and Filter functions to make a dynamic range in Google Sheets based on ID and ...

Using MINIF/MAXIF with strings containing numbers?...

Google Sheets function to group and concat rows...

how to convert date and time to just date in Sheets...

Google Appscript VALUE not returned...

How to reference to previous matching record using arrayformula?...

How I can joint 2 cell values in Google sheet with ARRAYFORMULA...

IMPORTRANGE + SUBSTITUTE...

Google Sheets Query sum indeterminate number of columns...

Google Sheets: How to sum multiple unique criteria...