This ~NEW~ Excel Function is Shockingly Powerful!

Every heard of SCAN function in Excel? Today, let me show you why you need this function and how it changes the way you solve your data problems. I think SCAN is Magic ✨

You are going learn:
What is SCAN function in Excel
SCAN syntax and application
How to use SCAN to calculate running total quickly
Using SCAN to get Maximum values
SCAN with LAMBDA
Advanced SCAN usage when your data is dynamic


~WHAT IS SCAN FUNCTION~

Scan function in Excel let's us run an operation on a range and returns all the intermediate results.
For example, you can use SCAN function to calculate running total of a range.

~WHAT IS THE SYNTAX OF SCAN~

SCAN(initial_value, range or array, operation)

For example:

=SCAN(0, A1:A10, SUM)
is going to return the running to of the range A1:A10

You can also use LAMBDA functions with SCAN to create more complex calculations.

=SCAN(0, A1:A10, LAMBDA(a, b, SUM(a,b)))
will return the same values as the first SCAN example above.


⏱ Video timestamps:
==================
0:00 - What is SCAN function & Why it is important?
1:46 - Understanding how SCAN works
3:46 - Using SCAN to calculate running MAX
4:57 - Using LAMBDA functions with SCAN
6:38 - How I use SCAN to solve tricky problems

📺 Watch next
============

How to use LAMBDA function in Excel - https://youtu.be/YrMCkE59ef4
How to use FILTER function in Excel - https://youtu.be/JuTdj2j-9Kg
Top 10 Essential Excel functions - https://youtu.be/HgNCvd8IbSc

📁 Sample Workbook:
==================

If you need a file with SCAN examples, download the scandoo.xlsx here:
https://chandoo.org/wp/wp-content/uploads/2024/03/scandoo.xlsx

~

What is the favourite Excel function of a German Shepard 🐶?
LAMBda... 🐑

#Excel #functions