Mar 4, 2021
11:37:21am
11:37:21am
RE: 120 ish (and growing over time)
If your texts are in column A and your prefixes are column C2:C120, I would add a marker column in B using formula below.
This specific one would be in B2.
=sumproduct(—isnumber(search($C$2:$C$120,A2)))>0
True means it contains the text, false means it doesn’t.
Try that and let me know if it works.
This specific one would be in B2.
=sumproduct(—isnumber(search($C$2:$C$120,A2)))>0
True means it contains the text, false means it doesn’t.
Try that and let me know if it works.
Originally posted on Mar 4, 2021 at 11:37:21am
Message modified by Bin01015 on Mar 4, 2021 at 11:37:37am
Message modified by Bin01015 on Mar 4, 2021 at 11:38:34am
- Bio page
- Bin01015
- Joined
- Feb 4, 2016
- Last login
- May 5, 2024
- Total posts
- 1,522 (2 FO)
Messages
Time
3/4/21 10:33am
3/4/21 11:04am
3/4/21 11:20am
3/4/21 11:37am
3/4/21 3:04pm