• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

Excel 2000 advanced filtering question

We are working with an excel sheet with a colum that has the name status.

This statusses can be new, in progress and closed.

I want to see only the rows that have the status new or in progress .
(or NOT closed)

How can I achieve this ?
0
itbabe
Asked:
itbabe
  • 2
1 Solution
 
sstampfCommented:
> Apply Autofilters
> Select Custom
> In the description select "Does Not Equal"
> In the value box select "Closed"
0
 
sstampfCommented:
2nd Solution:

> Apply Autofilters
> In the column for name status select "Custom" for autofilter
> In the first description select "Equals" then select "New"
> Check on the "OR" button
> In the second description select "Equals" then select "In Progress"
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now