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
▶︎
SECRET Excel Named Range Shortcuts to Save Time
▶︎
When Should You Use the Hash Sign in Excel Formulas?
▶︎
8 Tiny Excel Symbols That Replace Messy Formulas
▶︎
XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks)
▶︎
I don't use OFFSET Anymore! I Use Another Function Instead.
▶︎
7 Excel Tricks You Wish Someone Had Shown You Years Ago
▶︎
Make Excel Formulas Dynamic with the Hash Sign
▶︎
Judge LOSES IT After Discovering What She Did
▶︎
10 Excel Formula Symbols You Wish You Knew Years Ago
▶︎
Microsoft Excel - Spilled Array Formulas
▶︎
She Was Sleeping in 8A — When the Captain Asked if Any Combat Pilots Were on Board
▶︎
STOP Believing These 9 Excel Myths Right Now
▶︎
Excel LAMBDA Function: How & When to Use It (Beginner-Friendly)
▶︎
Why The Russian Accent Terrifies Everyone
▶︎
Say Goodbye to IF Statements in Excel with SWITCH
▶︎
Using dynamic arrays in a Table : 4 methods | Excel Off The Grid
▶︎
Excel’s Hidden Trick to Self-Updating Filters (File Included)
▶︎
Dot Operator will CHANGE how you Write Formulas in Excel | TRIMRANGE Function
▶︎
THIS Is What Happens When You Attack a US Aircraft Carrier
▶︎