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?

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)

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)