Advanced Filter for Text String
In the meanwhile Bob gave a solution!
Stefi
€žDaren€ť ezt Ă*rta:
Thanks, that worked for one of the columns, but when I did it for the other
column, the combined function acted as an "and" statement that only filtered
rows that contained Saturday in both columns. I need the function to show all
rows that contain Saturday in either column D or E. How can I do that?
"Stefi" wrote:
DataAutofilterChoose Custom from drop down listchoose "contains" (last
option) Saturday
Repeat it for the other column!
Regards,
Stefi
€žDaren€ť ezt Ă*rta:
Hello,
I have text values in 2 columns of cells that contain the word Saturday in
any length of values...e.g, The First Saturday, That Saturday was Nice. I
want to be able to use an advanced filter to show any rows that contain the
word Saturday in both columns. How can I do this assuming that Saturday can
appear in columns D and E?
Thanks.
|