Moving Average for Multiple Employees

[david gabra]

Hello

I have a question about moving average. I have seen there are many posts on moving average, but I have not been able to apply this to my need, based on it having to be per employee (column A), as can be seen in my attached excel.

I would like a to have a moving average on a 4 monthly basis and identify/highlight any averages where the 4-monthly average is greater than 48.

Please can you assist me with this.

Attached in a snippet, please where you show how this is done manually to show the expected results.

Thank you

David.

 

[Hui]

E22: =IF(COUNTIFS($A$2:$A$25,A2,$C$2:$C$25,"<="&C2,$C$2:$C$25,">="&EDATE(C2,-3))<4,"-",AVERAGEIFS($D$2:$D$25,$A$2:$A$25,A2,$C$2:$C$25,"<="&C2,$C$2:$C$25,">="&EDATE(C2,-3)))
copy down

also Cell A14 should be 22 not 11

 

[david gabra]

Hello Hui
You are right. Corrected cell A14.
You are truly amazing - its perfect!!!!