| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
finding the cell adjacent to the max value in a row with formula
I think I can find the column of the max value in a row using
=column(max(L5:iv5)) is there a way to select the value in the cell immediately to the left of this cell, so column-1. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add adjacent cell value to existing CountIF formula | Excel Worksheet Functions | |||
| VLOOKUP not finding adjacent columns | Excel Discussion (Misc queries) | |||
| Finding repeated data in adjacent cells | Excel Discussion (Misc queries) | |||
| Finding a string/using adjacent data question | Excel Discussion (Misc queries) | |||
| Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions | |||
Threaded Mode
