There's a quiet kind of frustration baked into this question, and it's one we recognize well. A user with thousands of accounts, unique relationship IDs, and daily balance shifts of $1,000 or more isn't asking for a miracle, they're asking for a reliable, repeatable process. And the fact that they're on Excel 365 but explicitly wondering if they can avoid Power Query tells us something important: the tool isn't the barrier. The perceived complexity is. That's not a failure on their part. It's a signal that the spreadsheet industry has spent years overcomplicating what should be a straightforward analytical task.
Here's the practical truth: yes, this can be done without Power Query, but the better question is whether it *should*. The user's data, several thousand rows, a unique text-formatted ID, and a daily changing list, is exactly the kind of work that benefits from a structured approach. Power Query would handle the day-over-day comparison elegantly, but we understand the hesitation. It feels like learning a new language when you just want to read the menu. The good news is that Excel 365's dynamic array functions, like `VSTACK` or `XLOOKUP` with a bit of creative formatting, can get you there. If the list changes daily and the stakes are financial, you want a system that's auditable, not just functional. A formula that works today but breaks when a new column appears tomorrow isn't a solution, it's a time bomb.
What stands out to us is the user's clarity about their constraints. They know names aren't unique, so they're relying on the relationship ID. They know the list shifts, so they're not pretending it's static. That's not a novice asking for a shortcut. That's a professional who's already thinking in terms of data integrity and workflow. They deserve a tool that respects that mindset. And while Power Query is the more robust path, the fact that they're even asking the question suggests they're willing to learn the right way, they just want permission to skip the unnecessary detours. We'd say this: don't let the fear of a new interface stop you from using the right feature. But if you're determined to stay formula-only, build your comparison table with structured references and named ranges now, so the logic scales when your data grows.
The real insight here isn't about Excel features at all. It's about the gap between what people think spreadsheets can do and what they actually can do with a little guidance. This user isn't looking for a hack. They're looking for confidence in their daily review process. And that confidence comes from knowing your method won't fail on a Tuesday because someone closed an account on Monday. So here's our concrete recommendation: start with a simple two-sheet setup, one for today's data, one for yesterday's, and use `SUMIFS` or `XLOOKUP` on the relationship ID to calculate the difference. If that feels fragile, invest the 20 minutes to learn Power Query's "Append" and "Group By" steps. The payoff isn't just today's report. It's the ability to trust tomorrow's.