This Reddit user isn't asking for a better spreadsheet. They're asking for permission to stop fighting a tool that isn't built for the problem. The request is straightforward, find the combination of values that sums closest to a target, using each value once, and the fact that an experienced user has to post it publicly, hoping someone "smarter" will answer, tells you everything about the gap between what people need and what legacy spreadsheets deliver.
The user's framing matters. They call themselves "bewildered-guineapig," and they ask for help from someone "smarter." That's not humility. That's the sound of a capable person hitting a wall that shouldn't exist. In Excel, solving this requires either brute-force Solver setups, VBA macros, or third-party add-ins, none of which are obvious to someone who just wants an answer. The tool treats the problem as an edge case, but in practice, this kind of combinatorial matching happens constantly: reconciling invoices, allocating budgets, optimizing inventory. It's not niche. It's everyday work that spreadsheets make feel like advanced calculus.
What this reveals is a deeper design flaw. Traditional spreadsheets are built for manual, linear thinking. You enter data, you write formulas, you drag cells. But modern data work is nonlinear. It asks questions like "what combination of these numbers gets me closest to that number", a problem that requires search, not calculation. That's where AI-native tools change the equation. Instead of asking the user to become a programmer or a solver expert, the tool should understand the intent: you have a target and a list, and you want the best match. The AI handles the combinatorial logic. The user stays focused on the outcome.
For the bewildered-guineapig of the world, the practical takeaway is this: You are not the problem. The tool is. When a spreadsheet makes you feel like you need to be smarter to do your job, it's time to explore a solution that meets you where you are. The future of data work isn't about memorizing obscure functions or building fragile workarounds. It's about describing what you need and letting the system figure out the how. Stop summing blindly. Start asking the question directly, and let AI find the match.