Hi guys, I've been struggling with this for a few hours, not certain if I'm dumb or not lol.
Assume I have a cell with text. I need to check if any of the values within a specified range are inside that cell.
Ideally return that value within the range.
Example:
Cell content = "I have this text string inside"
Range of values:
this
inside
test
word
I have 23k rows I need to check, and manually selecting the values (total of 90) could lead to errors.
How can I achieve the goal?
Thank you
Assume I have a cell with text. I need to check if any of the values within a specified range are inside that cell.
Ideally return that value within the range.
Example:
Cell content = "I have this text string inside"
Range of values:
this
inside
test
word
I have 23k rows I need to check, and manually selecting the values (total of 90) could lead to errors.
How can I achieve the goal?
Thank you