Channel: MrExcel.com
Category: Howto & Style
Tags: exceltocol function in exceltake function in exceltorow function in excel3-d references in excelmrexcelignoring errors with tocol in excelhstack function in excelignoring blanks with tocol in excelmicrosoft excelbill jelenvstack function in excel
Description: 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