Recursive Offset ? (Formula Problem )

[alex0182828]

Hello All, I have a problem that i need to solve it needs an offset or something that i am not able to grasp i am afraid. I need to populate Column AO with the highest value from AN for that row and all the prior blank rows. In the example below AO is populated with the correct answer.
Any help would be super, it cant be a macro i am afraid ! Thanks
Column AM Column AN Column AO 10 25 ORDERID111111 45 45 16 18 21 12 ORDERID121212 4 21 ORDERID221212 50 50 <tbody> </tbody>

<tbody>
</tbody>

 

[Sancdar]

Would it be possible to replace the blanks with the ORDERID they are tied to, or do they need to stay as blanks?

 

[Marcelo Branco]

If there are no column headers then put a header (text) in row 1 and try this

AM AN AO

Header1	Header2	Header3
	10
	25
ORDERID111111	45	45
	16
	18
	21
	12
ORDERID121212	4	21
ORDERID221212	50	50

<colgroup><col style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;" width="105"> <col style="width: 48pt;" span="2" width="64"> <tbody>
</tbody>

Formula in AO2
=IF(AM2="","",MAX(AN2:INDEX($AN:$AN,MATCH(REPT("z",255),$AM$1:AM1)+1)))
copy down

M.