How to list the rows that match a particular query?
 

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?

How to list the rows that match a particular query?
 

datafilterautofilter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"david.karr" wrote in message
...
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?

How to list the rows that match a particular query?
 

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
--
Max
Singapore

"david.karr" wrote in message
...
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?