LinkBack URL
About LinkBacks
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?
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?
Last edited by oceanorigami; 02-28-2014 at 03:37 PM.
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
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks I'll try this tomorrow and let you know!
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
Last edited by martindwilson; 03-02-2014 at 06:55 AM.
I found another method using a macro but thanks I will try this at some point later I'm burned out :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks