I'm wondering if anyone may have some suggestions on the best way to do
the following filter of specific lines from a very large excel dataset.

If I have a table with several field headings, for example:

year data type subgroup value
1981 labour force age 1 to 5 203
1982 census age 1 to 5 545
1981 population age 1 to 5 676
1983 labour force age 6 to 8 339
1983 census age 6 to 8 432
1983 population age 6 to 8 532
1985 labour force age 10 to 15 666

How could I arrange to filter out the lines which correspond to all of
the following criteria (not only one of the criteria):

1) year is 1981,1982 or 1985; and
2) data type is labour force or census; and
3) subgroup is: age 1 to 5, age 3 to 5, age 7 to 10, or age 10 to 15

Is it possible to to set up the criteria along the following lines and
do an advanced filter on it? (or is there an easier way or another way
to do this which is more advisable ie. VB macro):

year data type subgroup
1981 labour force age 1 to 5
1982 census age 3 to 5
1985 age 7 to 10
age 10 to 15

How could it be indicated that the data line must meet the criterion for
each of the fields (year, data type, subgroup) and not that it need meet
the criterion for only one of the fields. An example of datalines which
meets all the criterion is:

year data type subgroup value
1981 labour force age 1 to 5 203
1985 labour force age 10 to 15 666


Thank you, and I look forward to hearing from you.

Best regards,

Anne Nasser




*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!