| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a value
I have this formula:
=OFFSET(INDIRECT(ADDRESS(MATCH(MAX(B1:B26),B1:B26, 0),2)),0,-1) It looks up the value one cell left of the largest value in B1:B26, and it works OK, but 1) Can it be done in an easier way? 2) It only works if the column starts in row 1. as Match find the row within the array and Address demands the row in the sheet. Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding * | Excel Discussion (Misc queries) | |||
| Finding non-zero value | Excel Discussion (Misc queries) | |||
| Finding Max or Min Value | Excel Discussion (Misc queries) | |||
| finding the "end" | New Users to Excel | |||
| finding the last value | Excel Discussion (Misc queries) | |||
Threaded Mode
