?
Solved

Excel 2000 advanced filtering question

Posted on 2011-02-16
2
Medium Priority
?
214 Views
Last Modified: 2012-05-11
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
Comment
Question by:itbabe
  • 2
2 Comments
 
LVL 12

Accepted Solution

by:
sstampf earned 2000 total points
ID: 34904935
> Apply Autofilters
> Select Custom
> In the description select "Does Not Equal"
> In the value box select "Closed"
0
 
LVL 12

Expert Comment

by:sstampf
ID: 34905003
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This article presents several of my favorite code snippets.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question