Hi (Excel 2010)
In my pivottable I have a list of names.
Now I want to show only the rows with names including "ete" or "eve". I can set up af filter for each, but how do I filter for both of them.
Furthermore I would like to show the rows with "Johnsson" Is there a way to do it.
Something like : Select * from names where (names like %ete% or names like %eve%) and names like %Johnsson%
John Adams (Not to to be shown) Peter Grandjean (To be shown) Eric Hansen (Not to be shown) Evelyn Bond (To be shown)