Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Netting off to zero | Excel Worksheet Functions |