Looking for a formula that allows me to find the date for the first value given >0.
For example, P/N 70032 want to find 7/29/2019 date.
<tbody>
</tbody>
For example, P/N 70032 want to find 7/29/2019 date.
P/N | Past Due | 7/8/2019 | 7/15/2019 | 7/22/2019 | 7/29/2019 |
70025 | 30 | 0 | 0 | 0 | 0 |
70028 | 0 | 0 | 0 | 0 | 0 |
70032 | 0 | 0 | 0 | 0 | 172 |
70042 | 0 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>