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 ?
itbabeAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.