Prev: Printing Problem
Next: Non -matching cells
From: david.karr on 4 May 2010 17:49
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?
From: Don Guillett on 4 May 2010 18:31
data>filter>autofilter>>>>

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"david.karr" <davidmichaelkarr(a)gmail.com> wrote in message
news:22f3d35b-110b-4007-af74-73ad28f483f0(a)s29g2000yqd.googlegroups.com...
>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?

From: Max on 4 May 2010 18:47
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" <davidmichaelkarr(a)gmail.com> wrote in message
news:22f3d35b-110b-4007-af74-73ad28f483f0(a)s29g2000yqd.googlegroups.com...
>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?


 | 
Pages: 1
Prev: Printing Problem
Next: Non -matching cells