'Array manipulation' category


You are here: Excel » Functions » Array manipulation »

Subcategories

  • CHOOSECOLS function (1)
  • CHOOSEROWS function (1)
  • DROP function (1)
  • EXPAND function (1)
  • HSTACK function (1)
  • TAKE function (1)
  • TOCOL function (3)
  • TOROW function (2)
  • VSTACK function (1)
  • WRAPCOLS function (1)
  • WRAPROWS function (1)

  • 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 […]
    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 […]
    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, […]
    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, […]
    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 […]
    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 […]
    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 […]
    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: […]
    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: […]
    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 […]
    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 […]
    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 […]
    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 […]

    Excel categories

    FunctionsFormulasExcel TablesAdvanced FilterData ValidationDrop DownNamed RangesExcel SolverChartsConditonal FormattingPivot TablesVBAMacrosUDFsArchive