Swiftkoala
New Member
- Joined
- Feb 26, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi All,
so what I'm trying to do is to return the text in A1 to L column, but only if it eithers
a) Starts with the letter (likely most ideal solution)
b) Contain specific words
I think both options might work, however I'm not sure how to proceed.
The catch is:
1) I want to return given text only up to the point where another row starts with the letter. At that point, I would like to have new value mirrored
2)Table is irregular, meaning sometimes I would need to return same value 3x and sometimes 5x
Could you help, please?
so what I'm trying to do is to return the text in A1 to L column, but only if it eithers
a) Starts with the letter (likely most ideal solution)
b) Contain specific words
I think both options might work, however I'm not sure how to proceed.
The catch is:
1) I want to return given text only up to the point where another row starts with the letter. At that point, I would like to have new value mirrored
2)Table is irregular, meaning sometimes I would need to return same value 3x and sometimes 5x
Could you help, please?