how to find a max value from excel

A

Alexander14

New Member
Joined
Nov 1, 2020
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
please i need help
how can I find the maximum value for each 44 line interval like the example in the image below. The maximum value of (P4: P6 and P12: P14) with the interval is 44 and the maximum value for the next row (P48: P50 and P56: P58), for a total of 1728 rows. so I just have to drag the cursor automatically until I get the desired value to the bottom line
( sorry my english bad )
1604236087012.png
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You must log in or register to reply here.

Similar threads

T
  • Question
How to find maximum value in a range of more than 255 numbers? MAX does not work
Replies
6
Views
815
Peter_SSs
Peter_SSs
ajjava
  • Question
Procedure to find MAX VALUE in a SPECIFIC pivot table value field, in the case of MULTIPLE pivot table value fields
Replies
0
Views
825
ajjava
ajjava
H
  • Solved
Delete all rows including cells in column "A" that are identical to the values in cells "D1", "E1","F1" and "A6".
2
Replies
10
Views
262
Peter_SSs
Peter_SSs
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
392
AndyEd
A
E
  • Solved
Finding the Count in # of Months between the next highest in the range of values.
Replies
2
Views
214
EVANWIT84
E

Forum statistics

Threads
1,214,832
Messages
6,121,849
Members
449,051
Latest member
excelquestion515

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top