Excel has finally addressed this pain point with the introduction of a new function called SCAN.| Spreadsheet Point
