Advanced filter for groups to in Excel

[heygriz]

Hello - I have a server inventory list that I'm trying to organize for
end users based on what group the servers belong in. Some servers
belong exclusively in our "Staging 1" environment, some servers belong
exclusively in our "Staging 2" environment, and some are shared
between the two. I have a column that is named, "Environment" and
right now I have assigned the exclusive servers to their appropriate
groups however the ones that are shared need to be categorized by
something like, "Staging 1 and 2." The problem I'm facing is that I
want someone using the spreadsheet to be able to filter based on no
more than the two environments - Staging 1 or Staging 2. If someone
filters to view either one of those groups then he or she should see
the servers in the "Staging 1 and 2" group as well because they're
shared across both.

Does anyone have a solution? Thanks in advance!

Charlie

 

[Dave Peterson]

How about using a custom filter: Contains 1 (or Contains 2)?

 

[Dave Peterson]

Ps. That suggestion is ok only if you're using data|filter|Autofilter.

 

[Dave Peterson]

If you really wanted to use advanced filter, you could use a criteria
range--match the header for the table in the top cell of the criteria range and
use *1* or *2* as the second cell.

Environment
*1*

or
Environment
*2*