Drop down list from 3 or 2 or 1 or 0 number selection

This is very good, thank you for your help.

The whole idea of assigning points from an available pool is to strengthen the unit. So we have 3 points available from making the unit all humans. The player can then assign either 3 points to one of the categories, or 1 point to each of the categories or 2 and 1 and 0 respective.

I see that the formula offered will have a drop down menu based upon a predetermined list of 0 1 2 3, but what if there are only 2 points available? For example if the unit of humans has a creature attached it only gets 1 bonus point. This latter part has already been figured out in my sheet, thanks again to the community.

Also, in the attached file if I select the number 2 from the pull down list on my first category, it will have 0 1 3 on the list of my next category and that should be 0 1.

I notice that the list does not leave a formula footprint in a cell, and when I tried to find list in formula its not there. hmm,

Cheers,