Advanced filtering
 

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

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

The Database Range is a list of 152 rows that get evaluated and
filtered. The problem I am having is that when I add additional rows
to the Database Range, they do not get included in the filtered
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 of
the new rows. Still, it does not include rows that clearly should be
included in the filtered range.

Any help would be greatly appreciated. If it is allowed, I would be
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 me
at 703-850-2352.

John Glass




--
glassjo
------------------------------------------------------------------------
glassjo's Profile: http://www.excelforum.com/member.php...o&userid=27330
View this thread: http://www.excelforum.com/showthread...hreadid=470574

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?

glassjo wrote:
I have built a relativel simple spreadsheet that includes an advanced
filtering function.

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

The Database Range is a list of 152 rows that get evaluated and
filtered. The problem I am having is that when I add additional rows
to the Database Range, they do not get included in the filtered
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 of
the new rows. Still, it does not include rows that clearly should be
included in the filtered range.

Any help would be greatly appreciated. If it is allowed, I would be
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 me
at 703-850-2352.

John Glass






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