How to list the rows that match a particular query?

  • Thread starter Thread starter david.karr
  • Start date Start date
D

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?
 
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
 
Back
Top