Return Maximum from Column directly above Maximum in Row
 

I have data in 3 columns.

A B C
114.0 114.6 114.2
227.0 227.4 227.0
341.8 342.0 342.6
457.8 458.4 458.4
574.6 574.8 575.0
690.8 692.0 691.0
807.8 808.6 806.8
924.8 925.8 924.6
0.6 0.2 0.2

I need to take the maximum in row 9 and divide it by the maximum from the
column directly above it, in this instance 0.6/924.8. There may well be empty
rows above row 9 and the figures will not always be in ascending order.

How do return the maximum value from the correct column?

Return Maximum from Column directly above Maximum in Row
 

Code Numpty wrote:
I have data in 3 columns.

A B C
114.0 114.6 114.2
227.0 227.4 227.0
341.8 342.0 342.6
457.8 458.4 458.4
574.6 574.8 575.0
690.8 692.0 691.0
807.8 808.6 806.8
924.8 925.8 924.6
0.6 0.2 0.2

I need to take the maximum in row 9 and divide it by the maximum from the
column directly above it, in this instance 0.6/924.8. There may well be empty
rows above row 9 and the figures will not always be in ascending order.

How do return the maximum value from the correct column?

Here is a two-step process that keeps things simple. Not quite sure if
this is what you want...

In A10: =IF(A9=MAX($A9:$C9),A9/MAX(A1:A8))
(fill right)

In A11: =MAX(A10:C10)

Return Maximum from Column directly above Maximum in Row
 

Spot on smartin! Thank you, I just couldn't get my head round this one.

"smartin" wrote:

Code Numpty wrote:
I have data in 3 columns.

A B C
114.0 114.6 114.2
227.0 227.4 227.0
341.8 342.0 342.6
457.8 458.4 458.4
574.6 574.8 575.0
690.8 692.0 691.0
807.8 808.6 806.8
924.8 925.8 924.6
0.6 0.2 0.2

I need to take the maximum in row 9 and divide it by the maximum from the
column directly above it, in this instance 0.6/924.8. There may well be empty
rows above row 9 and the figures will not always be in ascending order.

How do return the maximum value from the correct column?

Here is a two-step process that keeps things simple. Not quite sure if
this is what you want...

In A10: =IF(A9=MAX($A9:$C9),A9/MAX(A1:A8))
(fill right)

In A11: =MAX(A10:C10)