Forum Discussion
Eliben
Dec 15, 2020Copper Contributor
EXCEL PROJECT: Work Distribution help
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
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
4 Replies
Sort By
- DevendraJainIron ContributorAt the end got a little confusing but it's simple
- DevendraJainIron ContributorConnect with me in private I will explain u
Better to explain all people on this forum who could have similar question.
If without formulas, what is the formal logic to calculate amount, is that the sum of amount from left table for the given name and file type or something else?