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