d4vem
06-04-2006, 06:06 AM
I am trying to do the following and I think I may need a function.
I have a list of people assigned to a task. In some instances some have an assigned percentage and some don't. What I need to do is calculate the assignees that don't have a percentage against assigness that do. Example
1) AA(50%),BB,CC,DD(25%)
Expected Result
1) AA 50%
2) BB 12.5%
3) CC 12.5%
4) DD 25%
As AA and DD equals 75% the remainding spare equals 25% divided by 2 unassigned people (BB & CC) equals 12.5%
Thanks
I have a list of people assigned to a task. In some instances some have an assigned percentage and some don't. What I need to do is calculate the assignees that don't have a percentage against assigness that do. Example
1) AA(50%),BB,CC,DD(25%)
Expected Result
1) AA 50%
2) BB 12.5%
3) CC 12.5%
4) DD 25%
As AA and DD equals 75% the remainding spare equals 25% divided by 2 unassigned people (BB & CC) equals 12.5%
Thanks