Excel2000 Data AutoFilter 3 or more criteria. How to?

[BobG]

Background: One worksheet, five columns. First column (A)
(text) lists the month and year over a four year span.
Example: May 1999, Dec 2003, etc. The other four columns
contain data relating to column A.

Objective: To filter column A and capture data for any
period May through Aug regardless of year. My four
criteria: May, Jun, Jul, Aug.

Desired reult: Data for May 1999, May 2000, May 2001, May
2002, May 2003; Jun 1999...; Jul 1999...; through Aug 2003.

Problem: Under Data, Auto filter, Custom, my success is
limited to capturing two months at a time. Example:
Criteria "begins with" May Or "begins with" Jun produces
both May and Jun data for all years. That is good. I need
the same result for all of the select months (May, Jun,
Jul, Aug). All other attempts in using "less than, greater
than, parameters did not produce a desired result. Ideas?

 

[Peo Sjoblom]

I believe you have to use a help column, if the dates are real dates the way
they would be if you typed in
May 2003 (which will be 05/01/2003) they you can use a help column and a
formula like

=MONTH(A2)

copy down and the use custom on the help column, greater than or equal to 5
AND less than or equal to 8

If they are pure text entries then you can use

=OR(LEFT(A2,3)={"May","Jun","Jul","Aug"})

copy down and filter on the help column and TRUE

Other options might be the advanced filter where you can use formulas etc..

 

[BobG]

Thank you for the solution.

-----Original Message-----
I believe you have to use a help column, if the dates are real dates the way
they would be if you typed in
May 2003 (which will be 05/01/2003) they you can use a help column and a
formula like

=MONTH(A2)

copy down and the use custom on the help column, greater than or equal to 5
AND less than or equal to 8

If they are pure text entries then you can use

=OR(LEFT(A2,3)={"May","Jun","Jul","Aug"})

copy down and filter on the help column and TRUE

Other options might be the advanced filter where you can use formulas etc..

--

Regards,

Peo Sjoblom





.