| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What is wrong on the fomular: Offset(MIN(A1:A10),,-1)?
I have a huge spread sheet, in which I need to extract the value from the
cell, which sits right to the lowest value in the whole row. E.g.: Example row: 2|4|7|3|0.3|10 Expected extract value: 3 I was thinking of using the OFFSET functionality in combination with the MIN functionality: =OFFSET(MIN(A1:A6),,-1) However, this is not working. Anybody any idea why not? Or a better solution at all? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| after entering certain number of times wrong password file can cur | Excel Discussion (Misc queries) | |||
| What's wrong with my array formula | Excel Discussion (Misc queries) | |||
| What is wrong with this =AVERAGE(IF formula? | Excel Worksheet Functions | |||
| multi-level subtotals are in the wrong position | Excel Worksheet Functions | |||
| Logic statement returns wrong answer. | Excel Worksheet Functions | |||
Threaded Mode
