Скачать или смотреть This NEW Excel Function is NOT for Beginners (unless you watch this)

In this video, I will show you how to use a new SCAN function in Excel.

SCAN is unlike any other Excel function as it allows you to keep track of the previous result, which can be extremely useful in many scenarios.

While most people use the SCAN function to calculate running totals, I've covered one example that will show you how you can use it in other scenarios where it can actually be more useful.

⬇️ Download Example File: https://www.dropbox.com/scl/fi/z8x6rb...

00:00 Intro
00:36 SCAN Function Demo (Running Total)
06:23 SCAN Function with Dynamic Running Total
08:07 Find Consecutive Values

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

#Excel #ExcelTips #ExcelTutorial #SumitBansal