'Array manipulation' category
Subcategories
Extract a unique distinct list across multiple columns and rows sorted based on frequency
Cell range B2:E11 contains values, the formula in cell B15 extracts unique distinct values in B2:E11, ignores blanks, and returns […]
Cell range B2:E11 contains values, the formula in cell B15 extracts unique distinct values in B2:E11, ignores blanks, and returns […]
How to use the EXPAND function
The EXPAND function increases a cell range or array by a specified number of columns and rows. Dynamic array formula […]
The EXPAND function increases a cell range or array by a specified number of columns and rows. Dynamic array formula […]
How to use the CHOOSECOLS function
The CHOOSECOLS function returns given columns from a cell range or array. Dynamic array formula in cell B9: =CHOOSECOLS(B2:D5, 2, […]
The CHOOSECOLS function returns given columns from a cell range or array. Dynamic array formula in cell B9: =CHOOSECOLS(B2:D5, 2, […]
How to use the CHOOSEROWS function
The CHOOSEROWS function returns given rows from a cell range or array. Dynamic array formula in cell B9: =CHOOSEROWS(B2:D5, 2, […]
The CHOOSEROWS function returns given rows from a cell range or array. Dynamic array formula in cell B9: =CHOOSEROWS(B2:D5, 2, […]
How to use the DROP function
The DROP function removes a given number of rows or columns from a 2D cell range or array. Dynamic array […]
The DROP function removes a given number of rows or columns from a 2D cell range or array. Dynamic array […]
How to use the TAKE function
The TAKE function returns a given number of rows or columns from a 2D cell range or array. Dynamic array […]
The TAKE function returns a given number of rows or columns from a 2D cell range or array. Dynamic array […]
How to use the WRAPCOLS function
The WRAPCOLS function rearranges values from a single row to a 2D cell range based on a given number of […]
The WRAPCOLS function rearranges values from a single row to a 2D cell range based on a given number of […]
How to use the WRAPROWS function
The WRAPROWS function rearranges values from a single row to a 2D cell range. Dynamic array formula in cell B8: […]
The WRAPROWS function rearranges values from a single row to a 2D cell range. Dynamic array formula in cell B8: […]
How to use the TOROW function
The TOROW function rearranges values from a 2D cell range to a single row. Dynamic array formula in cell B8: […]
The TOROW function rearranges values from a 2D cell range to a single row. Dynamic array formula in cell B8: […]
How to use the TOCOL function
The TOCOL function lets you rearrange values in a 2D cell range to a single column. Dynamic array formula in […]
The TOCOL function lets you rearrange values in a 2D cell range to a single column. Dynamic array formula in […]
How to use the HSTACK function
The HSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell to the […]
The HSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell to the […]
How to use the VSTACK function
The VSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell at the […]
The VSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell at the […]
Rearrange values in a cell range to a single column
This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]
This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]