Hello, I'm in need of some help not to professional with excel and still learning.
I have made a simple spreadsheet with regular assignments I do at work and we are trying to distribute those assignments evenly between employees. 1. We have a list of assignment on col. C under file type and the employee name on col. E 2. Now we have a list of names on G7:G11 3. The formula we are using on col E is this (=INDEX($G$7:$G$8,MATCH(A4,$H$7:$H$8,0)) to pull a name that matches the file type they will be working on
The issue is that we can't figure out how to assigned evenly a certain amount to each employee working the same file type.
Attached is the file hopefully I didn't sound to confusing