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

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

heygriz@gmail.com wrote:
>
> 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

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

heygriz@gmail.com wrote:
>
> 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

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*

heygriz@gmail.com wrote:
>
> 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