Thank you so much, Norbert. Such an elegant and simple solution!
Thanks also for the link on cohort analysis, very helpful.
EDIT: This approach is very helpful in calculating general retention at the program level. However, I still need help with a part of the problem. Specifically, I need to calculate retention of students new to program into the second calendar year, for only those students who registered in the second year (status = "registered" in first year +1).
Appreciate any ideas
Nipun, thank you for your reply, much appreciated.
While your workbook does calculate retention since first year, I also need to take account of the first year in any given program, since students can switch programs.
NICE:) Glad I could help out! Thanks for the "Awards".