loudnoiseman
Board Regular
- Joined
- Dec 31, 2004
- Messages
- 218
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
I want to Index only values less than zero in column B, and need to return the Minimum corresponding Matched value in column A.
So in the below data, the correct result would be 3.
Thanks so much!
I want to Index only values less than zero in column B, and need to return the Minimum corresponding Matched value in column A.
So in the below data, the correct result would be 3.
Thanks so much!
Column A | Column B |
13 | -2 |
17 | -8 |
8 | -3 |
3 | -4 |
2 | 5 |
3 | 10 |