Ditching volatile formulas, using Power Query, and switching to binary formats can make bloated Excel workbooks feel fast ...
Most Excel lookup functions return the first match, but XLOOKUP can reverse the search direction to return the latest record.