Hi all:
Thanks in advance for your help.
I have the following issue:
I'm trying to search for string "Intel" in an array A1:A100
However, in the array, "Intel" doesn't always appear as "Intel", sometimes it's "abcIntel" or "Intelproject1" or " Intel xyz"
I've used the address function and tried to combine it with the FIND/Search function, but with no success.
Any thoughts on how to set this up without VBA?
Thanks!
Thanks in advance for your help.
I have the following issue:
I'm trying to search for string "Intel" in an array A1:A100
However, in the array, "Intel" doesn't always appear as "Intel", sometimes it's "abcIntel" or "Intelproject1" or " Intel xyz"
I've used the address function and tried to combine it with the FIND/Search function, but with no success.
Any thoughts on how to set this up without VBA?
Thanks!