Advanced Filters not working

[GRAPL]

Any help would be appreciated...

I cannot seem to get Advanced Fileter to work. It keeps
returning all rows in my database list after applying
Advanced Filter.

I'm using Using Excel 2002 and believe I have religeoulsy
followed the instructions under "Filter by using Advanced
Criteria" in the online help.

1) Inserted range called "Criteria" which uses rows $1:$5.
$1 contains the criteria labels - formatted bold & with an
underline border.

2) Inserted range called "Database" which uses cells
$A$7:$N$3571.
Row $7 contains the list labels - formatted bold & with an
underline border.

3) Entered text values in the Criteria cells as shown in
Online help.

Job Claim
----------------
="XXXX"
="YYYYY"

4) Placed cursor in first data cell of the list i.e. $A$8,
and tried to Advanced Filter dialogue using the Filter in
Place option. All list rows are returned and the status
display shows "3564 of 3564 records found". Get the same
result list when filtering to a different location....

Job Name Claim ........
--------------------------------------------------
Data starts here

Knowledge base doesn't have any entries that shed any
light.

Thanks in advance for any help.
GRAPL

 

[notsureofthatinfo]

On Tue, 14 Oct 2003 22:57:38 -0700, "GRAPL" <[email protected]>
wrote:

you say the criteria is in rows $1:$5 ?
how many columns? and which? it appears you may have more rows for
the criteria than are necessary.
If Job is in A1
Claim in B1
="XXXX" in A2
="YYYYY" in B2

if the following range is part of your criteria A3:B5
and they are empty then that will bring up all the records as you are
experiencing.
Just a possible explanation.

 

[Myrna Larson]

For the criteria range, you must specify only those cells that contain criteria. In this case it
would be A1:B3. You specified rows 4 and 5 in addition, and here the cells are blank, telling
Excel that anything is acceptable for the job and claim. Hence all rows are returned.

In addition, you shouldn't need a formula: just put XXXXX and YYYYY in the cells, not ="XXXXX".
NOte, however, that will returns rows where the entries begin with XXXXX and YYYYY,
respectively.

 

[GRAPL]

Many thanks to both (e-mail address removed) and
(e-mail address removed) for the solution.

I guess this means whenever one's criteria profile
changes, then the Critria range needs to be redefined.
That's the bit I'd not picked up.

Hope I can return the favour one day
GRAPL