thisisthebear
New Member
- Joined
- Aug 3, 2007
- Messages
- 6
Heres the challenge;
I need to return the cell address on the first occasion that the following two conditions are met;
When Column A = 100
And
Column B is equal to or greater than 13
Column A Column B
101 --------- 10
102 --------- 10
103 --------- 11
104 --------- 13
100 --------- 10
101 --------- 10
102 --------- 11
103 --------- 11
104 --------- 11
100 --------- 13
101 --------- 11
102 --------- 11
103 --------- 10
104 --------- 12
100 --------- 14
101 --------- 11
102 --------- 11
103 --------- 10
104 --------- 12
In the above example I want to return the answer B10.
(Please ignore the ---------)
I need to return the cell address on the first occasion that the following two conditions are met;
When Column A = 100
And
Column B is equal to or greater than 13
Column A Column B
101 --------- 10
102 --------- 10
103 --------- 11
104 --------- 13
100 --------- 10
101 --------- 10
102 --------- 11
103 --------- 11
104 --------- 11
100 --------- 13
101 --------- 11
102 --------- 11
103 --------- 10
104 --------- 12
100 --------- 14
101 --------- 11
102 --------- 11
103 --------- 10
104 --------- 12
In the above example I want to return the answer B10.
(Please ignore the ---------)