since the 8th column has a negative number.

the eight column has a positive 1 in all cases.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
Ben,

Under your heading of 'show these rows' I would like to show the first two
since the 8th column has a negative number. And under the heading of 'but
not these ones'... assuming your 17h column was meant to be the 18th
column... I would like to show the first row since it has a negative
number
in column 8, and also show the second one because it has a number other
than
8 in column 18.

"ben" wrote:

do you want it to
show these rows
1 1 1 1 1 1 1 1 1 1 1 1 1 -1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1 1 -1 1 1 9

but not these ones?
1 1 1 1 1 1 1 1 1 1 1 1 1 -1 1 1 8
1 1 1 1 1 1 1 1 1 1 1 1 1 5 1 1 9

--
When you lose your mind, you free your life.


"John" wrote:

Ben,

would you mind posting what command would work? If I use
Operator:=xlOr or
Operator:=xlAnd ...it will not do what I am wanting. I want to show
rows
that don't equal 8 and are less than zero.

Thanks again.

"ben" wrote:

because your criteria says OR, excel will hide the row if either of
those
conditions is true, not if BOTH of them are true, therfore hides
when either
criteria is met

--
When you lose your mind, you free your life.


"John" wrote:

If I want to filter the data so that any row that has a value
greater than 0
in column 14 OR does not have a value of 8 in column 18... why
does this code
not work... It gives me only those rows with values less than zero
in column
14 and hides every row that does not equal 8 in column 18!

Sheets("CORPS").Select
Selection.AutoFilter Field:=14, Criteria1:="<0",
Operator:=xlOr
Selection.AutoFilter Field:=18, Criteria1:="<8"

Thanks for the help