TOCOL function


Excel » Functions » Array manipulation » TOCOL function »

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 TOCOL function

The TOCOL function lets you rearrange values in a 2D cell range to a single column. Dynamic array formula in […]

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