Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text match from web query | Excel Discussion (Misc queries) | |||
if, Isnumber, Match, &index query | Excel Discussion (Misc queries) | |||
index and match query | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
INDEX AND MATCH QUERY ? | Excel Worksheet Functions |