Kelli Webb
Member
Hello,
There is nothing like another challenge before Christmas....
I would love some assistance to create a formula using columns A & B to identify who the turnover is for & what the turnover is.
The calculation then is the Sum of Terminations (Last 12 months) / the Average Headcount (Last 12 months).
The outcome should be as per O17:Z22, highlighted green - I know the formula I have used works, but it isn't robust and if one tab changes the sort for example, this will not be fit for purpose.
If you need anymore information, please don't hesitate to reach out to me.
thank you, and stay safe over the holidays!!
Kelli
There is nothing like another challenge before Christmas....
I would love some assistance to create a formula using columns A & B to identify who the turnover is for & what the turnover is.
The calculation then is the Sum of Terminations (Last 12 months) / the Average Headcount (Last 12 months).
The outcome should be as per O17:Z22, highlighted green - I know the formula I have used works, but it isn't robust and if one tab changes the sort for example, this will not be fit for purpose.
If you need anymore information, please don't hesitate to reach out to me.
thank you, and stay safe over the holidays!!
Kelli