I need to set up a spreadsheet that keeps track of the total hours worked of
three groups. Within those groups are 10 employees. The trick I need
addressed is that while each individual has a total number of hours worked
for the year, we call the person with the lowest number of total hours for
the year.

Sometimes we use only one group, sometimes all three, to find the person
with the lowest total hours. It depends on their class and which group has
qualified for the hours to be worked.

I would like to simply click on something, like the yellow and green group,
and the correct calling order from lowest to highest hours would be indicated
somehow. Thus, after entering a number of hours one employee worked, that
amount would be reflected in her/his total hours and that person would be
moved down the list.

Do you think this can be done on Excel or do you have any other suggestions?

I appreciate your assistance! CP