How to list the rows that match a particular query?

[david.karr]

I have a worksheet with a lot of rows. I'd like to see all the rows
in the worksheet that match a particular "query", like "column A =
'foo' || column B = 'bar'". How do I do that sort of thing?

 

[Don Guillett]

data>filter>autofilter>>>>

 

[Max]

Use Autofilter, on a helper col, like this:
Put in say E2: =IF(AND(A2="foo",B2="bar"),"x","")
Copy E2 down to cover the extent of source data
Apply autofilter on col E, choose: x to filter out the required rows