top of page

Microsoft Excel's Pretty New "TOCOL" Function

The TOCOL Function takes an array of data and turns it into a Column of data.

You can also nest the TOCOL function with other functions like the SORT and UNIQUE Functions.


Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web


=TOCOL(array, [ignore], [scan_by_column])

The TOCOL function syntax has the following arguments:

-- array The array or reference to return as a column.

-- ignore Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following:

0 Keep all values (default)

1 Ignore blanks

2 Ignore errors

3 Ignore blanks and errors

-- scan_by_column Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.


Download XLSX • 20KB

429 views0 comments

Recent Posts

See All

Check out the video below on how to create Dynamic, Cascading Drop-Down Menus in a Microsoft Excel list. This method of creating Dynamic Drop-Down Menus uses the built-in Data Validation list tool, Na

bottom of page