CHOOSECOLS function
Excel » Functions » Array manipulation » CHOOSECOLS function »
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, […]