Solved: Calculate time

[d4vem]

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]

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]

Thanks for the response I used your formulas and they worked a treat.

Again Thanks

[Jacob Hilderbrand]

Glad to help

Take Care