Dynamic Cumulative in a Range

Here is a rough idea of what I described above. I have a lot of helper columns here.

Column R finds the biggest value for the week.

Column S is the day of the week associated with this value.

Column T is the second largest value.

Column U is the day of the week associated with this value.

Column V is the total number for the week.

Column W is for you to fill out. For example, The best days for delivery for Item 1 are Friday and Saturday. It doesn't make much sense to deliver on two consecutive days, so roll them both into Friday. Item 2 indicates Tuesday and Saturday. You will have to make a judgement call based on Columns S and U.

Column X and Y and Z and AA are used to split the deliveries based on what percentage of sales occur on those days. Column Y is the amount to deliver on the smaller of the days. Column X is the amount to deliver on the bigger of the days (everything that isn't delivered in the other delivery). if there is only one delivery, deliver the total on that day,.

I can see one tweak to add. For the last item on the list, there is a tie for the day with the most sales. The current model finds the first occurrence. The model has to be modified that in the case of a tie, the second delivery day is based on the second occurrence of the value. I'm not doing that now.