A repeatable Excel macro workflow can import a bank CSV, clean dates and amounts, normalize merchant names, apply categories, ...
Excel formulas are powerful, but they have their limits. I used to rely on complex nested formulas that take forever to build and are difficult to troubleshoot, but I have started leaning more heavily ...