Excel 2002: How to use Auto Filter ?
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 |
Excel 2002: How to use Auto Filter ?
Have you looked in Help. Try the index for AUTOFILTER
-- Don Guillett Microsoft MVP Excel SalesAid Software "Mr. Low" wrote in message ... 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 |
Excel 2002: How to use Auto Filter ?
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 "Mr. Low" wrote: 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 |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com