Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Excel 2002/2003 Advanced Filter | Setting up and Configuration of Excel | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |