H
Haggisdog
I am struggling with writing an Excel formula that I would greatl
appreciate some help on.
In theory this sounds quite simple. I have a table which shows ho
long it takes in months to move from one 'level' to the next. Anothe
larger table shows how a number of 'starting' individuals woul
progress through their levels based on the progression table mentione
earlier.
The challenge is that I can use a formula lik
=INDIRECT(ADDRESS(16,IF($B$3-1>=0,3,1))) to accurately identify ho
long a person will be at one level but I can't quite figure out how t
write an elegant formula that can correctly identify when one group a
a level moves to another level and joins another group (at least fo
the period of time before that group moves to another level).
I have attached a sample spreadsheet to show what I am trying to do.
Any help would be great appreciated. Please feel free to email me wit
solutions or post your ideas in this forum.
Thanks in advance for any assistance.
Bryan Campbell
(e-mail address removed)
appreciate some help on.
In theory this sounds quite simple. I have a table which shows ho
long it takes in months to move from one 'level' to the next. Anothe
larger table shows how a number of 'starting' individuals woul
progress through their levels based on the progression table mentione
earlier.
The challenge is that I can use a formula lik
=INDIRECT(ADDRESS(16,IF($B$3-1>=0,3,1))) to accurately identify ho
long a person will be at one level but I can't quite figure out how t
write an elegant formula that can correctly identify when one group a
a level moves to another level and joins another group (at least fo
the period of time before that group moves to another level).
I have attached a sample spreadsheet to show what I am trying to do.
Any help would be great appreciated. Please feel free to email me wit
solutions or post your ideas in this forum.
Thanks in advance for any assistance.
Bryan Campbell
(e-mail address removed)