Excel TOCOL Handles 3D References And Ignores Errors – 2474

Today, a deeper dive into the new Excel functions TOCOL and TOROW.

Table of Contents
(0:00) Ignore errors with TOCOL
(0:46) Non-contiguous ranges with TOCOL
(0:56) 3-D Ranges with TOCOL
(1:26) Using TAKE and HSTACK
(2:01) VSTACK for Headings