Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in array-formulas

Using Office365 excel array formulas, how to remove duplicates, keeping the last value?

How to use COUNTUNIQUE function within ArrayFormula and get a range result?

Simple way to fill in all the cells in a column with the same string

Google Sheets function to group and concat rows

How to use ARRAYFORMULA with OFFSET to previous row without getting circular reference error

Is there a formula in Excel to return multiple values in one cell for multiple lookup values in another cell?

Cannot implement INDIRECT() within an array formula

How to auto-increment in spreadsheets by formula?

Lookup multiple values in a single cell (comma separated) and then return the values to a single cell (also comma separated)

ARRAYFORMULA to sum previous row cell

How can I find the number of concordant/discordant pairs for a given cell in Google Sheets?

Is it possible to use arrayformula to copy the values above if the cell on its left is empty?

regexextract all groups from list as arrayformula

Change Column value from 1 to 0

Google sheets "array_agg"... or equivalent? (join aggregation)

extract a specific field from array in Google Sheets

Google Sheets - ArrayFormula Calculate Difference with Previous Cells