Hi

I have the following data-set:

A B
20 Absconded
21 Voluntary
22 Voluntary
23 Voluntary
23 Absconded
23 Voluntary
27 Voluntary
27 Voluntary
27 Absconded
27 Voluntary

Where Column A = Week Numbers of a Calender Year & Column B is Reasons for
Service Terminations.

I need to report as follows:

Week 22:
Absconded = 0%
Voluntary = 100%

Week 23:
Absconded = 33%
Voluntary = 66%

Week 27:
Absconded = 25%
Voluntary = 75%

I need a formula that will calculate the % as indicated above, from the data
set provided. Thanks! Awesome Forum!!!