I have three categories,
Strike
Expertise
Capability
If a cell has a value of "Human", it will will have an associated strength value of 3,2,1, or 0
How could I create a list for each of the three categories that would allow the values to be selected (either 3,2,1, or 0)?
Would it be possible to subtract the value once selected (eg 2 of 3) and have only the remainder value possible for the subsequent lists? In the example either 1 or 1 for the remaining two categories.
Thanks,
Bookmarks