Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1769.xlsx
Learn Accounting and Financial Spilled Array Formulas when the formula uses a Relative Cell Reference, One Cell Above, as an Accumulator like in investment value from period to period (multiplicative) or a checkbook balance from period to period (additive) using the SCAN and LAMBDA functions.

1. (00:00) Introduction
2. (00:42) Old School Excel Formula with Relative Cell Reference, One Cell Above, to calculate an investment value in each row
3. (01:10) SCAN and LAMBDA to calculate a running balance for an investment account in a multiplicative process.
4. (03:38) Old School Excel Formula with Relative Cell Reference, One Cell Above, to calculate a checkbook balance in each row
5. (04:06) SCAN and LAMBDA to calculate a running balance for a checkbook account in an additive process
6. (04:46) Summary
7. (05:05) Closing and Video Links

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunTue, December 28, 2021 7:44pm