Advanced filtering

[glassjo]

I have built a relativel simple spreadsheet that includes an advance
filtering function.

The Criteria range evaluates from a formula; specifically, it allow
the user to choose from a list of acceptable values (i.e.- a drop-dw
list), and the result is placed in a criteria field.

The Database Range is a list of 152 rows that get evaluated an
filtered. The problem I am having is that when I add additional row
to the Database Range, they do not get included in the filtere
results. I have no idea what is going on here, and I need help.

I have been careful to redefine the Database Range to include ALL o
the new rows. Still, it does not include rows that clearly should b
included in the filtered range.

Any help would be greatly appreciated. If it is allowed, I would b
happy to email my spreadsheet to someone and let them look at it.
This might be the best way to help diagnose my problem.

Thanks so much for any elp you can give me, and feel free to contact m
at 703-850-2352.

John Glass

(e-mail address removed)

 

[Debra Dalgleish]

Maybe the information in the new rows is slightly different than the
information in the previous rows. If you copy one of the old rows, and
paste it at the end of the table, is it filtered correctly?