Opv
06-28-2015, 05:20 PM
I have a database that I've configured Advance Filter to more easily filter the data. The criteria range is defined as A1:BB3, thus allowing for two rows of potential criteria. Where more than one criteria row is defined, are criteria required in at least one cell on both rows before the filter will work?
For some reason, when I type one surname in the appropriate column on Row 2 the filter doesn't work until I type in an additional criteria on Row 3. Is that the expected behavior?
For some reason, when I type one surname in the appropriate column on Row 2 the filter doesn't work until I type in an additional criteria on Row 3. Is that the expected behavior?