Find Max Value in a Row when another Row is populated with different enteries

[Sam_D]

Hello,
Please can someone help.
Im trying to create a formula that looks along a row and then where theres an entry it looks at the top row and picks the highest number. I've attached a spreadsheet showing a shrunken version of the excel file, the answer to the formulas are in column F for each row.

Thanks,

[ragulduy]

put:
=MAX(IF(A2:E2<>"",A$1:E$1))
in f2 as an array formula (confirm with ctrl+shift+enter) and copy down.

[Sam_D]

Thanks Again

[Ace_XL]

Non-array alternative

=MAX(INDEX((A2:E2<>"")*A$1:E$1,0))