| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Maximum value for Specific Month(s) | Excel Worksheet Functions | |||
| Maximum Value in Column | Excel Discussion (Misc queries) | |||
| Maximum Value in column | Excel Discussion (Misc queries) | |||
| Maximum Value in column | Excel Discussion (Misc queries) | |||
| Return Maximum value | Excel Discussion (Misc queries) | |||
Threaded Mode
