Hello All, and thanks in advance for your help...
I am trying to create a formula that searches for many strings in one cell, the problem is these many things are dynamic and are taken from another range:
the formula I am using is below, "things" are taken from a different column, this column has empty cells leading to incorrect results, how can I return an array with all nonempty cells in the range I am using to use replace "things in the formula below?
Please Login or Register to view this content.
I am Hoping this is clear enough and is posted in the right place...
A bit more info, I got this working in Google sheet with this formula:
Thanks...Please Login or Register to view this content.
Bookmarks