Number Distribution in cells

I have been trying to create a matrix that has a maximum of 24 slots in each window and if it exceeds the maximum it takes
the extra slots and puts them in the next most popular window

Before distribution Saturday
Window 1 27
Window 2 22
Window 3 11
Window 4 10
Window 5 6
Window 6 4
Total 80


After distribution Saturday
Window 1 24
Window 2 24
Window 3 12
Window 4 10
Window 5 6
Window 6 4
Total 80


I have been manually changing them, however, is there a way to make excel automatically take out the slots exceeding 24 and put them in the
next most popular window until it has either filled all extra slots or reached 24 and moves onto the next most popular window?

Any help would be much appreciated.

-------------
MODERATOR'S NOTE: Please select the correct forum for posting your questions.