Link to home
Start Free TrialLog in
Avatar of itbabe
itbabe

asked on

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 ?
ASKER CERTIFIED SOLUTION
Avatar of sstampf
sstampf
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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"