Excel SCAN Function

Описание: Don't overlook the SCAN function in Excel for calculating your running totals. By using SCAN with the LAMBDA function, you can create a custom calculation to handle an array of numbers in an iterative process.

It's easy to use, simple to understand, and definitely needs to be added to your ever-expanding skillset!

00:00 What is the Excel SCAN Function?
00:20 Using the SCAN Function
01:35 Using the LAMBDA function with SCAN
02:39 Changing the parameters
03:00 SCAN function availability

Looking for more Excel help? ➡️ https://sheetskunk.com

Let's connect on social! 👨‍💻📲

TikTok ➡️   / sheetskunk  
Instagram ➡️   / sheetskunk  
Pinterest ➡️   / sheetskunk