Netting off
If I have following excel data. I want to net off column D by cancelling +ves
& -ves. Please let me have a formula/macro which will only pick the last 3
lines in the following example (b/c 1st two nets off).
I actually have a 2000+ line report to analyse and look at the details
(name) for those which stays in once I have netted of the rest.
I want all the columns (ie A to D) to show.
A B C D
Name1 date1 No1 £100
Name2 date2 No2 -£100
Name3 date3 No3 £150
Name4 date4 No4 £300
Name5 date5 No5 -£100
Thanks for your help in advance.
|