smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In both columns A and B (A1:A600, B1:B600) I have numbers/indexes in ascending order.
Column A range is from zero up to a 599. Column B could contain negative numbers.
I need to return index from column A for the smallest positive number from column B. Result should be placed in cell C1.
Zero should be treated as negative number in formula.
Column B could repeat the same numbers and it that case return index for the first number.
example.
<tbody>
</tbody>
explanation: One (cells B5 and B6) is the smallest positive number in column B. Result in C1 should be 4 because it's a corresponding index from column A (cell A5).
In both columns A and B (A1:A600, B1:B600) I have numbers/indexes in ascending order.
Column A range is from zero up to a 599. Column B could contain negative numbers.
I need to return index from column A for the smallest positive number from column B. Result should be placed in cell C1.
Zero should be treated as negative number in formula.
Column B could repeat the same numbers and it that case return index for the first number.
example.
A | B | C | |
1 | 0 | -12 | 4 |
2 | 1 | -5 | |
3 | 2 | -1 | |
4 | 3 | 0 | |
5 | 4 | 1 | |
6 | 5 | 1 | |
7 | 6 | 2 | |
8 | 7 | 3 | |
9 | 8 | 3 |
<tbody>
</tbody>
explanation: One (cells B5 and B6) is the smallest positive number in column B. Result in C1 should be 4 because it's a corresponding index from column A (cell A5).