Excel Hash Sign Operator - What is it + ADVANCED Tricks!
The hash sign spill operator enables you to reference spilled arrays returned by dynamic array formulas. In this video I share some little known tricks for using it in data validation and defined names.
⬇️ Download the file here: https://www.myonlinetraininghub.com/h...
0:00 Introduction
0:29 What is a spilled array
0:58 Referencing spilled arrays with #
2:21 Referencing spilled arrays in Data Validation
7:03 # sign in Defined Names
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy
Watch video Excel Hash Sign Operator - What is it + ADVANCED Tricks! online without registration, duration hours minute second in high quality. This video was added by user MyOnlineTrainingHub 21 October 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 61,67 once and liked it 2.6 thousand people.