What formula could I use that would locate the first numeric value for Part A,B,C, and then give the correct date in which the first numeric value was located? Example, if I wanted to know the due date of Part C, how would I get the formula to return 4/22? Part B to return 4/20? etc Thank you in advance
Part | 4/18 | 4/19 | 4/20 | 4/21 | 4/22 | |
A | 2 | |||||
B | 3 | |||||
C | 5 |