Hi all,
I know this problem has been answered more than once, but the solutions I found so far don't work...
The task:
I have a row of values that starts with large negative numbers and in each column the values become smaller until they eventually become positive. I need to automatically find write the lowest negative number and the lowest positive number in this row into specific cells.
For example:
-10, -5, -2, 1, 10 --> I'm looking for the "-2" and "1" value to be written in separate cells
Any help would be appreciated. I tried Index Match, but failed with the "look for the smallest neg. in this row"... I'm a bit rusty when it comes to Excel![Mad :mad: :mad:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f621.png)
Thanks for your support
Heiner
I know this problem has been answered more than once, but the solutions I found so far don't work...
The task:
I have a row of values that starts with large negative numbers and in each column the values become smaller until they eventually become positive. I need to automatically find write the lowest negative number and the lowest positive number in this row into specific cells.
For example:
-10, -5, -2, 1, 10 --> I'm looking for the "-2" and "1" value to be written in separate cells
Any help would be appreciated. I tried Index Match, but failed with the "look for the smallest neg. in this row"... I'm a bit rusty when it comes to Excel
![Mad :mad: :mad:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f621.png)
Thanks for your support
Heiner