Filter multiple columns for a single word

[oceanorigami]

I want to run a filter "contains" RND on multiple columns but can't figure out how to do it. I think I need to use a macro or the Advanced Filter. Can anyone help explain how to do it?

[martindwilson]

in a column adjacent to your data assuming data has headers in row 1
so say your data goes from a1:j100
leave k1 blank
in k2 put

=COUNTIF(A2:J2,"*RND*")
select range a2:j100
data/filter/advanced
filter in place
make sure list range is a1:j100
criteria range is $k$1:$k$2
click ok

[oceanorigami]

Thanks I'll try this tomorrow and let you know!

[martindwilson]

Of course the other option is to simply fill
The same formula down to end of data then
Use the normal filter and filter on true

[oceanorigami]

I found another method using a macro but thanks I will try this at some point later I'm burned out :D