This is a follow up to the post titled "Excel: Using F9 to Audit Formulas." This video will explain how to extract nonblank or nonzero data from an array without using an array formula.
To download the file referenced in the video click HERE.
should be simple.*