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?