I entered his table data and in cell F2 (creating a helper column = to TRUE
or FALSE - that He could filter-on) I entered:

=AND(NOT(ISBLANK(B2)),NOT(ISBLANK(D2)),B2<1,D2-1)

and Got True in F4, F5 and F6.

Oh well,,,


"Mike Fogleman" wrote:

Jim, I believe the op wants to apply both criteria to each number.
=IF(ABS(SUM(A1:D1))2,"visible","hidden")

Mike F
"Jim May" wrote in message
...
I would like to be able to hide Row D because the values in column A and C
are < 1 and -1.
Applying the above test Row C and E also meet this test. Best to redefine
what you are wanting to get. I'm sure we can help you.


"Craig147" wrote:

Here is the scenario;
A B C D
A 50 25
B 10 9
C 0.5 6
D 0.26 -0.36
E -5 0.99

I would like to be able to hide Row D because the values in column A and
C
are < 1 and -1. Please note that row C and E should not be hidden
because
in one of the columns the value is 1 or < -1.

I would really appreciate any help thanks

Craig