More than 2 "Custom Autofilter" conditions? Is this possible?! (ms Excel2002)

[Shiperton Henethe]

Excel 2002/Win2000

Hi

Anyone know if there is any way to use more than
just *two* filter condtions in the (extremely useful)
custom AutoFilter?!

Is this possible?

with thanks


Ship
Shiperton Henethe

 

[Debra Dalgleish]

You're limited to two conditions. You could add a new column to the
table, and use it for the custom filter. For example, if you want to
filter for three names in a list of employees:

List the names in an empty column on the worksheet, e.g. column J
Add a new column to the table, with a column heading, e.g. "InList"
In the first data row of the new column, enter a formula that refers
to the employee name column:
=COUNTIF(J:J,C2)
Copy the formula down to the last row of data.
To filter, select '1' from the dropdown list in the heading of the new
column.

 

[Shiperton Henethe]

Debra

Looks quite clever but drat,
I'm trying to do this without adding extra columns
(because fresh data keeps coming in)

But there's no plug-in or similar to let us do more
than one condition, then?

Similarly what about acheiving a logical AND between
filters on two different columns?!


Ship
Shiperton Henethe

 

[Roy Moore]

Suggest looking at the advanced filter. If your worksheet is continuously
active and you don't want to add a column or rows for the advanced, you may
want to add another worksheet to your workbook and place the filter criteria
range on the separate worksheet.

 

[Mark]

Suggest looking at the advanced filter. If your worksheet is continuously
active and you don't want to add a column or rows for the advanced, you may
want to add another worksheet to your workbook and place the filter criteria
range on the separate worksheet.

I read the above notes regarding an advanced filter situation. I have been
trying to get an answer to my problem for a few days. I've created a
database with the auto-filter that I plan to use for assigning umpires this
spring. Two columns have umpire names, one for the PLATE umpire and one for
the BASE umpire. I'm trying to find a way to filter one umpire's schedule
for the season in chronological order. He may be in the Plate column or the
BASE column. I can't seem to figure a way to set up this filter. When I
filter the PLATE column I can come up with the name I want but when I add
the base column the name can't be summoned.

Can you help?

-Mark

 

[Dave Peterson]

I'd just add an extra helper column and put a formula like:

=A2&"..."&B2

(where column A held the names of the plate umpires and column B held the base
umpires.)

then filter on that column using "Contains".

Hide the column or keep it out of the print range if you need to print.

 

[Mark]

I'd just add an extra helper column and put a formula like:

=A2&"..."&B2

(where column A held the names of the plate umpires and column B held the base
umpires.)

then filter on that column using "Contains".

Hide the column or keep it out of the print range if you need to print.

Thanks for the help. One more question....where in this new column should
that formula you suggested be placed?

 

[Dave Peterson]

I like to use a column out of the way--to the far right (or as a new column A).
(But you could put it anywhere you like (ahem).)

But if you're printing--just hide it or exclude it from the print range.