Assigning Round Robin Based on Criteria

Hi,

I have the attached table:

The first table is the raw data. The second table shows the available pool of case workers.

I am trying to assign the available case workers to the list of patients in table 1. The assigning should in sequence so that all case workers get equal number of patients. However, if there is a case with the same patient name within the same date, then these case should be assigned to the same case worker.

An example of the correct results is in the table below in column C. Is there a formula that could be used in column C to achieve this ? Appreciate all the help.

I have across post here:

https://www.mrexcel.com/board/thread.../#post-5954921