Highest/lowest average of N consecutive rows ignoring blanks

[plotting]

Here is a sample list of data that I want to see if I can find a running list of highest and lowest averages over a given cell count, ignoring blanks

For instance, the highest 3 week period would be A1:A4 = 101.10% and the lowest would be A14:A16 = 89.87%

 

[Eric W]

If you have LET, then try:

Book3
	A	B	C	D	E
1	98.52%		# of consecutive weeks	High	Low
2	103.35%		3	101.10%	89.87%
3
4	101.43%
5	91.59%
6	90.44%
7	90.30%
8	91.67%
9	95.22%
10	96.19%
11	89.15%
12	90.80%
13	92.02%
14	87.98%
15	92.17%
16	89.47%
17	92.59%
18	99.39%
Sheet3

Cell Formulas
Range	Formula
D2:E2	D2	=LET(f,FILTER(ROW(A1:A20),A1:A20<>""),s,SEQUENCE(ROWS(f)-C2+1),ss,INDEX(f,s)-1,sl,INDEX(f,s+C2-1)-ss,AGGREGATE({14,15},6,SUBTOTAL(1,OFFSET(A1,ss,0,sl)),1))
Dynamic array formulas.

If you don't have LET, then I think this will require VBA.

I'd also like to add that averaging averages is mathematically suspect, and should ONLY be done if the number of data points in each average is the same.