Nov 29 2021 08:07 PM
Hi,
Im needing to find a formula that will look for the first occurrence in each row of a number (in this case 12434, 12351 or 12363 which must fall AFTER 42002. If it occurs before, it is disregarded. On the first occurrence in each row of these numbers after 42002 I need to know the first date they occur (in column G). Would anyone be able to assist with the correct formula for this? It would be much appreciated :)
A B C D E F G
01/01/2022 | 02/01/2022 | 03/01/2022 | 04/01/2022 | 05/01/2022 | 06/01/2022 | Result |
42002 | 42002 | 12434 | 12434 | 12434 | 12434 | 03/01/2022 |
42002 | 42002 | 42002 | 12351 | 12351 | 12351 | 04/01/2022 |
12351 | 12351 | 12351 | 42002 | 42002 | 12351 | 06/01/2022 |
42002 | 42002 | 12363 | 12363 | 12363 | 12363 | 03/01/2022 |
Dec 01 2021 01:58 PM