group percentages

hi

simple task but I cant work it out and no one to sit with me to help

basically 3 groups of 12 numbers (well, 12 12 13) put into its own colour group. by entering a number at a time, id like to see what colour group has most %

interestingly I would like to see if the colour groups would shift so out of the numbers entered (0-36) would it calculate the highest % group?!

attached

thanks

number 0-36 split into 3 groups - yellow, blue, green.

if I entered 10 numbers from 0-36 I would like to know which colour group has most %

the most numbers. the sheet I attached should be easy to understand?

Originally Posted by shg

Once again, what is the expected result for your example?

H3 box... enter a number - example 32 - D6 would say 100%

because its the only number entered into H3 so far and that's in the yellow group

Originally Posted by GeneralDisarray

Does that mean, you plan to enter more than one number into H3 and need to keep track of how many times a number is 'hit' in each group?

Correct, looking to see which group has most hits

thats awesome thanks very much.

dont suppose theres a way so it can automagically assign its own groups so if you entered 10 numbers it shows the optimal group?

Highest percentage yes

so this would be the next x amount of spins (roulette wheel) and the new colours are new groups, red is the most hit group. can this be automatic so the sheet knows to look for a highest group of 12 or 13?