Using Filter, but with additional criteria

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

I'm stumped. I want to programmically filter data in column D that is equal
to * / *, but also if there was any other rows found where column A may
contain the same type of information, include that.

After I finished picking up that information, I'm going to copy and paste to
another sheet but I'm stopped on pulling on this first part because sometime
the information in col. d will contact character / character and the same in
col. a. Sometimes col. a will contain char / char but not in D ...

here's a sample -- 4 rows need to be picked out of this list to copy to new
spreadsheet (row 1,2,4 and 5).

A B C D
a z 3 b / b
a / a z 4 b / b
a z 3 b
b / b e 8 a
g g 1 c / c
a z 3 b

Hoping someone can help with this one!
 
I think you would need to do it in two steps

Filter on d contains / and a does not
copy visible rows
filter on a contains /
copy visible rows and place below the first group.

Otherwise you could create a helper column that tests (use a formula) that d
or a contain / and so indicates

=countif(A1,"*\*)+countif(D1,"*\*")

drag fill down the column.

filter on values in this column greater than 0
 
Back
Top