Filter Per Relative Criteria

  • Thread starter Thread starter Eileen
  • Start date Start date
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
 
Eileen

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

Andy.
 
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
 
Back
Top