0
I have a database and I would like to display all of the rows that have the word "sales" CONTAINED in column B OR D.
I tried using advanced filters, but I was only able to show rows that had cells EQUAL to "sales" in B or D (e.g. it excluded cells containing things like "the sales").
Using the regular filter function I can only do contained in one column or contained in both columns, there is not an option that I could find checks if it is contained in EITHER column.
It may be worth noting that I was also unable to incorporate =ISNUMBER(SEARCH(substring,text)) into a condition for advanced filtering, but that is a way to check if a cell contains a certain text.
Thanks in advance!