CHOOSEROWS function


Excel » Functions » Array manipulation » CHOOSEROWS function »

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