Compound Criteria
Posted by Ray on October 09, 2001 12:39 PM
I have a rather large database consisting of a
couple dozen columns and 9,000 rows. I'd like
to extract a RANGE of data (values) from the DB
utilizing the advance filter mechanism
(not the auto filter). This I believe is
compound criteria? Can't seem to get it right. Looking
to extract a range >=56000 and <=59000.
Posted by Aladin Akyurek on October 09, 2001 12:59 PM
Ray,
What follows is an example similar to your data:
{"Value","Value";
">=25","<=60";
"","";
"Share","Value";
"share-1",28;
"share-2",32;
"share-3",10}
"" stands for empty cell.
The above occupies the range A1:B7.
A4:B7 houses the actual data.
A1:B2 houses the criteria range. Note that the label/column heading of interest is repeated in this range. The criteria are entered as is (that is, as text values).
To use Advanced Filter, activate A4, activate Data|Filter|Advanced Filter, and enter the ranges that are asked for in the Advanced Filter window.
Aladin
========
