Excel has a new operator. The # operator (also known as SPILL Operator) is how you can access the dynamic array ranges in Excel. In this short but in-depth video, learn,
◉ What is the # operator?
◉ When to use it?
◉ How to use the # operator?
◉ 2 Advanced Tips on working with # operator
◉ Accessing spill ranges with functions like INDEX()
SAMPLE WORKBOOK 📗👇
======================
Please download the sample workbook for this video here - chandoo.org/wp/wp-content/upl...
➕MORE ON THE DYNAMIC ARRAYS
==============================
VIDEOS
Getting started with the dynamic arrays in Excel - • Learn about the *NEW* ...
Dynamic arrays live stream (2 hrs) - • Beginner to Pro ~ Exce...
FILTER Formula Explained - • I don’t use filters in...
ARTICLES
Dynamic arrays in Excel - how to use them - chandoo.org/wp/dynamic-array-...
XLOOKUP (also DA function) - chandoo.org/wp/xlookup-examples/
⏱VIDEO CHAPTERS & TIME STAMPS 👉
=================================
0:00 - What is the new # SPILL Operator
0:25 - Setting up for the # operator
2:10 - Using the Spill # Operator in formulas
3:42 - Using # operator in named ranges for Dynamic Data Validation List
7:04 - Using Spill Ranges and # with INDEX
That is all. May your day SPILL with joy 😀
#Spillberg #Excel
7 авг 2024