Hi,

I want to filter a specific word in my table range. I can not use the filter because the columns are not side by side.
I just need a formula or a different filter, so that it will check the whole range of my table, find the specific word and display all the rows which had this specific word in it.

Thanks in advance.