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/hash-sign-in-excel-formulas 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: https://www.linkedin.com/in/myndatreacy/