sasUrbanexcel
New Member
- Joined
- Jun 14, 2012
- Messages
- 2
Hello,
I'm trying to return the first date when the numbers in Row 2 exceed Row 3. I can see the first date is 2/1/15 (when 236,151>215,653), but i dont know how to write the formula.
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>
Thank you
I'm trying to return the first date when the numbers in Row 2 exceed Row 3. I can see the first date is 2/1/15 (when 236,151>215,653), but i dont know how to write the formula.
Row 1 | 09/01/14 | 10/01/14 | 11/01/14 | 12/01/14 | 01/01/15 | 02/01/15 | 03/01/15 | 04/01/15 | 05/01/15 | 06/01/15 | 07/01/15 | 08/01/15 |
Row 2 | - | - | 9,962 | 75,058 | 140,210 | 236,151 | 302,123 | 303,614 | 303,661 | 304,876 | 306,308 | 307,814 |
Row 3 | 210,644 | 212,614 | 214,284 | 215,653 | 216,565 | 217,164 | 217,761 | 218,364 | 218,966 | 219,568 |
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>
Thank you