Hi Ron...clueless here...
my criteria range is defined in range B1:D3 as follows:

COL B.......COL C.....COL D
row 1..... ......MM-YY.... MM-YY
row 2..... TRUE.....=200212.....<=200305
row 3..... TRUE..... =200312

the TRUE field contains the formula u provided - =LEN(A7)<=8
A7 is where my DATA starts
A6 is where the HEADERS begin - would that be it?

any suggestions?
sandi

"Ron Rosenfeld" wrote in message
...
On Wed, 27 Oct 2004 21:14:30 -0400, "Gauthier"

wrote:

Hi Ron...thanks for getting back to me! the columns aren't are parsed
together...just so i have it right, the =LEN(A8)<=8 is the first criteria
column (yes, with no header)?

It can be in any column in the Criteria Range that does NOT have a header
(or
that has a header that is not one of the column labels).

It needs to be entered on each of the rows, so in my example, I had
specified
the criteria range as being A1:C3. The formula would be entered in A2 and
again in A3.


i tried it, and it didn't work

Must be something different about how you have things set up. Make sure
your
criteria range doesn't have a blank line in it. It worked here on the
data you
posted, filtering out the REGION's with more than 8 digits.


also (sorry if i should have mentioned earlier) does it matter if i used
Advanced Filter - Copy to Another location
the RESULTS are actually on sheet two

That should not make any difference.

-----------------------------------
Here is the criteria range (in A1:C3) and the data (REGION is in A7):

MM-YY MM-YY
=LEN(A8)<=8 =200212 =<200305
=LEN(A8)<=8 <=200312



REGION MM-YY
------------------------------
1234 200212
123401 200212
12340101 200212
1234010101 200212
123402 200212
12340202 200213
1234020201 200213


The criteria cells with the formula actually show as FALSE, since the
formula
is being evaluated.

The result:

REGION MM-YY
1234 200212
123401 200212
12340101 200212
123402 200212
12340202 200213


--ron