Help req with advanced filter criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimbo - 28 Jan 2005 21:20 GMT

I would like to extract a range of records using 'advanced filter'
The range I would like to extract would be based on a numerical value ...
and the criteria is:
'Greater than or equal to' AND "Less than or equal to"
How do I enter this in the criteria range ?

Regards to all and thanks in advance

Reply to this Message

Earl Kiosterud - 28 Jan 2005 22:05 GMT

Jimbo,

Since cells in the same row have an AND relationship (and cells in the same
row have an OR relationship), you'll need two columns for that particular
heading:

Heading1 Heading2 Heading2 Heading3
>=x <=y

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

>I would like to extract a range of records using 'advanced filter'
> The range I would like to extract would be based on a numerical value ...
[quoted text clipped - 3 lines]
>
> Regards to all and thanks in advance

Reply to this Message

Debra Dalgleish - 28 Jan 2005 22:11 GMT

Earl meant to say, "cells in different rows have an OR relationship" <g>

There are a couple of examples here:

http://www.contextures.com/xladvfilter01.html#Criteria

> Jimbo,
>
[quoted text clipped - 4 lines]
> Heading1 Heading2 Heading2 Heading3
> >=x <=y

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Earl Kiosterud - 28 Jan 2005 22:17 GMT

Debra,

Good damned thing I'm not a doctor! :)

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> Earl meant to say, "cells in different rows have an OR relationship" <g>
>
[quoted text clipped - 10 lines]
>> Heading1 Heading2 Heading2 Heading3
>> >=x <=y

Reply to this Message

Dave Peterson - 28 Jan 2005 22:58 GMT

Was that 12 pills at 1:00 or 1 pill at 12:00?

The CQC is branching out!

> Debra,
>
[quoted text clipped - 24 lines]
> > Excel FAQ, Tips & Book List
> > http://www.contextures.com/tiptech.html

Signature

Dave Peterson

Reply to this Message

Debra Dalgleish - 29 Jan 2005 00:30 GMT

Watch it! You're already on the list.

> Was that 12 pills at 1:00 or 1 pill at 12:00?
>
[quoted text clipped - 28 lines]
>>>Excel FAQ, Tips & Book List
>>>http://www.contextures.com/tiptech.html

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message