Hi guys,
Is there any way to search a cell for text words that the words do not have to be in order? I can get this formula to work using if everything i type is in the exact order, but not if i try to switch some words around.
Formula using search: =isnumber(search(trim(C1),A1))
See example:
<tbody>
</tbody>
This returns a "True", however see next example:
<tbody>
</tbody>
This returns "False".
Anyway to get this to be true? Im open to helper columns if needed as well. Thanks for looking!
Is there any way to search a cell for text words that the words do not have to be in order? I can get this formula to work using if everything i type is in the exact order, but not if i try to switch some words around.
Formula using search: =isnumber(search(trim(C1),A1))
See example:
A | B | C | |
1 | the dog runs fast | dog runs | |
2 |
<tbody>
</tbody>
This returns a "True", however see next example:
A | B | C | |
1 | the dog runs fast | runs dog | |
2 |
<tbody>
</tbody>
This returns "False".
Anyway to get this to be true? Im open to helper columns if needed as well. Thanks for looking!