A short video explaining how to extract nonblank or nonzero values from an array without using an array formula.
The Excel file can be downloaded at the following link: http://www.asimplemodel.com/reference...
If this video moves a little to quickly, please see the videos available at this link for a more gradual introduction to the concepts required to build this formula: https://www.asimplemodel.com/referenc...
Overview of ASM Financial Modeling Courses:
https://www.asimplemodel.com/curriculum
Nerdy Updates Sent Directly to Your Inbox:
http://eepurl.com/b6zdCL