How do Excel set the maximum value for 5 numbers?

Excel in the use of the process will encounter the number of miles between the maximum number, you can use the function mod judgement, row range, with Max to take the maximum response range, the following demo

1, the data, as shown in the figure, to find the maximum number of 5, the idea is as follows, Excel has a mod function, used to take the remainder, if the remainder is 0, then, the interval number of 5, you need to calculate the maximum value, the following detailed demo

2, in the B6 input function formula, =if (mod (ROW ()-1), 5) =0,max (A2:A6), where mod is used to find the remainder, Max is used to find the maximum value in a certain range, if the condition is judged, when the condition satisfies the 5 number of intervals, Find the maximum value in 5 digits

3, the right mouse click B6, mouse over the B6 cell in the lower right corner, double-click the right mouse button, automatically fill B6 the following cells, as shown in the picture

4, the above only provides a method, you can use another one, see the following figure

Note: Take the maximum number of intervals, the formula entered the first position is more important, this method can be extended to any number of maximum value, pay attention to modify parameters.

        Note : more Wonderful tutorials please focus on the Triple Office software tutorial section, triple Computer office group: 189034526 Welcome to join