Excel has finally addressed this pain point ... especially with volatile functions like OFFSET. With SCAN, the same task becomes a one-step operation. Instead of applying formulas to each row ...