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