I have a list of people with 10 years of salary history for each (in ten consecutive columns on the spreadsheet). I need to calculate in excel Example.xlsfor each (if they have less than 5 years with salary, then it should just average the years the do have).
Some people have breaks in service (for five years, there is a blank in that entry). These years should be ignored and skipped in calculating the avergaes.
Could someone please help me? Thank you.
Bookmarks