There is a smarter way to build that roster tool, and it starts with rethinking how you approach data selection in your spreadsheet. The #SPILL error you are hitting isn't a dead end, it is a signal that your current formula is fighting against the very structure you created. You have a working concept, but the execution is fragile because it relies on random row generation and dynamic arrays in a way that Excel wasn't designed to handle cleanly. The fix isn't to keep refreshing and hope for the best; it's to step back and simplify your logic.
What you need is a method that separates the random selection from the filtering step. Instead of pulling a random row and then applying your dropdown filter in one volatile formula, consider using a helper column that assigns a random value to each row in your table. From there, you can sort by that value, apply your criteria, and then return the top matching rows. This approach eliminates the spill error because the array size becomes predictable, you are no longer asking Excel to guess how many results fit into a range that might change with every recalculation. It also makes your tool more robust, because you won't be at the mercy of volatile functions that recalculate at unpredictable times.
The point value bonus you mentioned is not a stretch either. Once your random selection is stable, you can add a running total column that sums the points of your chosen units, then use conditional logic to keep adding rows until you hit your target. This turns a frustrating error into a feature: you are not just building a roster, you are building a balanced one. The key is to stop treating the spreadsheet as a single formula that does everything and instead break it into small, repeatable steps that Excel can handle without throwing a fit.
You are close to something genuinely useful here. The fact that you identified the problem and asked for a better way already puts you ahead of most people who would have just given up. So take the time to restructure your approach, your future self, and your tabletop opponents, will thank you.