Select values from cell range, different range output

[NaHo]

Hello all,
I can not figure this out.

In column A there are 1000 values, I need to find max of every 10 values. As a resulted output I need: B1=max(A1:A10), B2=max(A11:A20), etc to cell B100.
What function should I use to make this easier?

Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B
1	111	183
2	87	176
3	173	89
4	19	194
5	29
6	104
7	183
8	18
9	60
10	58
11	24
12	3
13	151
14	94
15	120
16	106
17	176
18	19
19	38
20	87
21	65
22	32
23	18
24	17
25	33
26	23
27	49
28	45
29	64
30	89
31	125
32	171
33	126
34	194
35	113
36	92
37	125
38	172
39	192
40	78
Lists

Cell Formulas
Range	Formula
B1:B4	B1	=MAX(INDEX($A$1:$A$1000,SEQUENCE(10,,ROWS(B$1:B1)*10-9)))

 

[maabadi]

Another Method.
At B1 Input:

=MAX(OFFSET($A$1,(ROW()-1)*10,0,10,1))

And Drag it down.