first time posting and looking for some help (please be nice :D)!
I am looking for an array formula to return an array, if the values in a range contain certain text.
For example, in the table below, I have a Lookup range in the left column. I wish to return the values containing "Country", and the end result would be an array with the relevant values, as per the right column. Furthermore, I only want to return the values containing "Country", and not have any blank spaces within the resulting array.