Filter Per Relative Criteria

E

Eileen

Is there an easy way that I can filter out those rows
that meet certain relative criteria? Let's say, I have
column A (min), column B (max)and my results are in
column C. I need to filter out C4 (A4<C4<B4), C8
(A8<C8<B8)....., rows that between Min and Max.

Thanks
 
A

Andy B

Eileen

If I understand this correctly, try this in D4
=IF(AND(A4<C4,C4<B4),"Between","Not between")

Andy.
 
W

Willem van Kalsbeek

Eileen,

Create an "autofilter" in the Data menu
when you click on the arrow, the third entry from the top is what you need
there you can giva an upper and lover level of the data

Succes

Willem
 
Top