Generating a random selection of rows based on multiple criteria
I am trying to create a force building tool for a tabletop wargame.
I would like it to generate multiple rows of unit info from a table based on certain criteria and have it working for the most part but keep ending up with #SPILL errors. I am sure that there is a much more efficient way of going about this.
Here's the overview:
The breakdown:
A random rom is selected from a table in the worksheet
Then a filter is applied to sort the results according to what is selected in the dropdown menu at B2
For the most part this method seems to work. The issue is that every few refreshes i get a #SPILL error
I have set this formula to run at the bottom of the sheet and ensured there was no data in any cells to the farthest right and down.
BONUS:
If there is also a way to get this to work and have the random rows be equal to a determined point value. that would be amazing.
[link] [comments]
Want to read more?
Check out the full article on the original site