J
JJ
Hi,
I have a table with hundreds of rows and in each of them I need to
search if a specified column has one or more specific words. An
example will ease the explanation:
Excel table
A
B
joao trav casq
pedro kry toog
casq joao brigs
Criteria: I need to find which cells contain the words joao OR casq -
actually, the real criteria will involve around 10 different words so
that cascaded ORs in a SEARCH is a difficult task)
Aimed result:
Excel table
A
B
joao trav casq True
pedro kry toog False
casq joao brigs True
Is there any function that will allow me to achieve this ?
If not, can anyone share how to code this ?
Thanks/Brgds
Joao
I have a table with hundreds of rows and in each of them I need to
search if a specified column has one or more specific words. An
example will ease the explanation:
Excel table
A
B
joao trav casq
pedro kry toog
casq joao brigs
Criteria: I need to find which cells contain the words joao OR casq -
actually, the real criteria will involve around 10 different words so
that cascaded ORs in a SEARCH is a difficult task)
Aimed result:
Excel table
A
B
joao trav casq True
pedro kry toog False
casq joao brigs True
Is there any function that will allow me to achieve this ?
If not, can anyone share how to code this ?
Thanks/Brgds
Joao