Excel 2002: How to use Auto Filter ?


M

Mr. Low

Hi

I have a very long table of 52,000 lines as follows:

A B C D
Date Ref Amt Net
xxx A12 60
A12 -60 0
A13 24 24
B29 100
B29 -80 20
C41 50
C41 -50 0
D27 75
D27 -55
D27 -10 10
....
55000


I would like to see the table from A1: D55000 for the items that has the net
value of not = 0 , the filtered table is to show the data as

A B C D
Date Ref Amt Net
xxx A13 24 24
xxx B29 100
xxx B29 -80 20
xxx D27 75
xxx D27 -55
xxx D27 -10 10

i.e. components of the items that has a net value of 0 are filtered out.

Appreciate very much if you could provide guidance.

Thanks

Low

A36B58K641
 
Ad

Advertisements

Ad

Advertisements

S

Shane Devenshire

Hi,

1. Select all the data and choose Data, Filter, AutoFilter
2. Open the filter drop down in the Net column and choose Custom
3. From the 1st drop down pick does not equal
4. In the box to the right enter 0
5. Click OK

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top