Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating Values from a worksheet
Hello I am hoping someone online here can help me with my delima.
I have a huge worksheet of values in US dollars, and these values are both positive and negitive. I would like to know if their is a way to eliminate the lines which cancel each other out. Bascially I am trying to sum the values but eliminate the values which cancel each other out. For example line 10 is $100 line 200 is -$100 Is there some type of function i can use to eliminate all values which sum to 0 ? Thanks in advance for any help or advice offered Cheers, Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminating the high 4 values | Excel Worksheet Functions | |||
Excel 2003-eliminating blank rows in target worksheet | Excel Discussion (Misc queries) | |||
Eliminating 0 values when using the Small formula | Excel Worksheet Functions | |||
Eliminating rows in Excel worksheet | Excel Worksheet Functions | |||
Identifying/Eliminating Worksheet References | Excel Discussion (Misc queries) |