Davers
Well-known Member
- Joined
- Sep 17, 2002
- Messages
- 1,165
This might get interesting....I am trying to figure out annualized attrition. I think I have it working correctly, except for my totals column seen here:
The total annualized attrition rate, cell O19, should match what is in the latest entry for annualized attrition, in this example, cell D19. But I haven't figured out what the formula needs to be. Right now it is just figuring out average attrition so far for the year. I don't want to use a lookup formulae where you have to type in what month you are in...I would just like it to automatically know how many months are filled in and return the annualized attrition up to and including that month...Any idea's??? You guys have been great by the way answering all my newbie questions...I really appreciate it! I can't wait to have an answer to someone's EASY question....
Thanks,
Dave M.
BAC AttritReport.xls | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
15 | 2002 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | ||
16 | EOMHeadcount | 85 | 85 | 85.0 | ||||||||||||
17 | CSCAttrition | 3 | 1 | 2.00 | ||||||||||||
18 | MonthlyAttrition% | 3.53% | 1.18% | 2.35% | ||||||||||||
19 | AnnualizedMCCAttrition | 42.35% | 28.24% | 2.35% | ||||||||||||
20 | 2001MonthlyAttrition | |||||||||||||||
21 | 2002vs.2001% | 3.53% | 1.18% | 2.35% | ||||||||||||
CRC |
The total annualized attrition rate, cell O19, should match what is in the latest entry for annualized attrition, in this example, cell D19. But I haven't figured out what the formula needs to be. Right now it is just figuring out average attrition so far for the year. I don't want to use a lookup formulae where you have to type in what month you are in...I would just like it to automatically know how many months are filled in and return the annualized attrition up to and including that month...Any idea's??? You guys have been great by the way answering all my newbie questions...I really appreciate it! I can't wait to have an answer to someone's EASY question....
Thanks,
Dave M.