PDA

View Full Version : Solved: Calculate time



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

Jacob Hilderbrand
06-04-2006, 05:52 PM
If you have those values in A and B, try something like this.

Number of blanks:
COUNTA(A:A)-COUNTA(B:B)

Remaining percentage:
1-SUM(B:B)

Percentage for each blank:
(1-SUM(B:B))/(COUNTA(A:A)-COUNTA(B:B))

d4vem
06-06-2006, 06:23 AM
Thanks for the response I used your formulas and they worked a treat.

Again Thanks

Jacob Hilderbrand
06-06-2006, 07:41 AM
Glad to help :beerchug:

Take Care