I am looking for a formula to generate a moving average of the last two weeks OR the last 10 data points (whichever produces more data points) conditional upon the presence of data in two other columns. Example.
I want to calculate: The average of column $K for the past two weeks (from today's date) OR the past ten data points (whichever is a larger data set) when column $G=HenkkyG and column $U=LAN.
Effectively I want Player HenkkyG's average over the past two weeks or 10 games (data points).
I am currently using this formula for overall average:
=IFERROR(AVERAGEIF($G:$G,AF2,$K:$K))
where AF2=player name I am drawing data for.