garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Good Afternoon,
I am looking for a formula in B3 which will look at C3 and if its a date will put this date in Column B3. The formula will then copy this data until the next date in Column C and repeat the same logic.
I do not have XLSBB.
I have manually simulated in Column A how it should look.
I am looking for a formula in B3 which will look at C3 and if its a date will put this date in Column B3. The formula will then copy this data until the next date in Column C and repeat the same logic.
I do not have XLSBB.
I have manually simulated in Column A how it should look.
Manual Input | Formula | |
27/11/2022 | 27/11/2022 | |
27/11/2022 | ||
27/11/2022 | TEST1 | |
27/11/2022 | TEST2 | |
27/11/2022 | TEST3 | |
27/11/2022 | TEST4 | |
27/11/2022 | 4555555 | |
27/11/2022 | 555555 | |
27/11/2022 | ||
28/11/2022 | 28/11/2022 | |
28/11/2022 | ||
28/11/2022 | TEST1 | |
28/11/2022 | TEST2 | |
28/11/2022 | TEST3 | |
28/11/2022 | TEST4 | |
28/11/2022 | 4555555 | |
28/11/2022 | 555555 | |
28/11/2022 | ||
29/11/2022 | 29/11/2022 |