Hi,

im having problems as to what formula to use in excel. I want to get the average scores of a person for 6 months rolling data but seems that I cannot find the correct formula to use.

**the person may be listed on a different cell per month as they are ranked.

please help.

thanks!