
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











![video thumbnail for: A Day at the Beach 1928 - Odessa in 1920s [4K 60fps]](https://i.ytimg.com/vi/HVR529qh7nQ/mqdefault.jpg)

![video thumbnail for: A Day at the Beach 1928 - Biarritz France 1920s | AI Enhanced [60 fps 4k]](https://i.ytimg.com/vi/WJNjKvCP8UY/mqdefault.jpg)

![video thumbnail for: A Walk in the Park - c.1900 | Bois de Boulogne Paris - AI Enhanced [4k 60 fps]](https://i.ytimg.com/vi/4YBbcXKguzA/mqdefault.jpg)

![video thumbnail for: A Day at the Beach - c.1921 | AI Enhanced Film [60 fps 4k]](https://i.ytimg.com/vi/y-6W9xNTe2A/mqdefault.jpg)