Eight columns are in criteria range. For this particular filter, there is
only computed criteria in one row..all other cleared
"Debra Dalgleish" wrote:
How many columns are in the criteria range?
Do you have all the applicable criteria in each row?
For example, if you have Product and Region columns in your criteria range,
Region Product
East Desk
Chair
Any record would be retrieved that is either a Desk in the East region,
OR a chair in any region.
With East in both rows:
Region Product
East Desk
East Chair
Any record would be retrieved that is either a Desk in the East region,
OR a chair in the East region.
Tina wrote:
Initially using 3 row criteria range, first with headers and last two for
criteria. Filter worked properly but now extracts all data from source
unless I reduce the criteria to just one row of input. Tried clearing the
fields and then filter again, still extracts all data.
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com