Max of Two Rows in a Column

ddudley88

New Member
I am trying to return the max value from a column every two rows...for example

if the column had these entries

2
5
8
9
7
12
I want the results to be...

5
9
12

I need it to take the max value of rows 1 & 2 and then rows 3 & 4 etc.

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
This is an option.
Excel Workbook
AB
12
255
38
499
57
61212
Cell Formulas
RangeFormula
B1=IF(MOD(ROW(),2)=0,MAX(#REF!),"")
B2=IF(MOD(ROW(),2)=0,MAX(A1:A2),"")
B3=IF(MOD(ROW(),2)=0,MAX(A2:A3),"")
B4=IF(MOD(ROW(),2)=0,MAX(A3:A4),"")
B5=IF(MOD(ROW(),2)=0,MAX(A4:A5),"")
B6=IF(MOD(ROW(),2)=0,MAX(A5:A6),"")

You didn't say where you wanted your output nor what row/column your data starts on. So, taking a guess... assuming your numbers start on Row 1 in Column A, put this formula in B2 and copy it down...

=IF(MOD(ROW(),2),"",MAX(A1:A2))

Replies
1
Views
636
Replies
5
Views
207
Replies
7
Views
381
Replies
7
Views
333
Replies
7
Views
232

1,203,741
Messages
6,057,097
Members
444,905
Latest member
Iamtryingman

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.

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

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