Return Maximum from Column directly above Maximum in Row

C

Code Numpty

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?
 
S

smartin

Code said:
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?
Click to expand...

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value Y axis - Not to start from zero 2
Pivot Table: Return Value From Same Row 5
Search for maximum set of values 5
Pull a column header from a row of numbers 1
Select max value from 9 cells, copy cell col heading to other cell 6
Lookup value then return result from other column, varying row num 5
max value from multiple rows of similar information 5
Find Largest and Return Column Name 2

Top