Our summary plan description for a retirement plan has the following component:
"Your Highest Five-Year Average Compensation is the average of your Compensation for the 60 highest paid consecutive months of employment during the last 120 months before retirement or termination. If you have less than 60 months of employment, compensation is averaged over your actual months of service from your date of hire until your termination."
It sounds simple but what would be the excel formula to calculate the average assuming, A1:A200 contains the data series?
Thanks in advance.
Bookmarks