Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in array-formulas

How to use importhtml in Google Sheets to import tables from multiple URLS coninuously in same spreadsheet?

Google Sheets: Count number of rows in a column that do not match corresponding row in another column?

Using IF, AND/OR (many condition) with Array formula in Google sheets

Run-time error: 1004 Unable to set the FormulaArray property of the Range Class

excel vba array-formulas

How to make the formula unique to ignore a column

Fill in blank cells in ={ARRAYFORMULA()}

Merge all cells to one cell and separate with comma

In Google Sheets can you count the number of rows with a certain criteria like WEEKNUM() and YEAR()?

Conditional sum

Is it possible to write ARRAYFORMULA of another ARRAYFORMULA

How to use ARRAYFORMULA for REPLACE function in Google Sheets?

How to calculating Zero Crossing Rate (ZCR) & Mean Crossing Rate (MCR) in an array?

How to give true and false condition if my column have text and number

How to find the maximum value in entire Excel workbook

How to change cell based on another cell value on Google Sheets

Google Sheets ArrayFormula to get INITIALS of arbitrary length name

Dynamic array formula that allows for target table expansion

How to use an arrayformula to calculate balance on each line

How to use IFERROR inside an array formula?