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
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