Help w/array formula
Posted by Jim on December 03, 2001 11:43 AM
This formula is in M21 and subtracts G21 from the last non-blank value above H21.
Now my problem: Assume H15 contains a value and H16:H20 are blank. Column A is filled with dates. How would I reference A15 (the date associated with H15 as the last non-blank cell above H21) in a formula to subtract it from the date in A21?