Max of Two Rows in a Column

[ddudley88]

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.

 

[Oeldere]

This is an option.

Excel Workbook
	A	B
1	2
2	5	5
3	8
4	9	9
5	7
6	12	12
Blad1

Cell Formulas
Range	Formula
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),"")

 

[Rick Rothstein]

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))