View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DACLEMEN
 
Posts: n/a
Default How do I find clearing items in a column in Excel?

I have a column of values. Each month some items clear eachother. For
example: there may be a positive $1,000 entry and two entries that are meant
to clear the $1000 like ($400) and a ($600). However, this is an extremely
easy example. Is there any sort of function I could use that searches a
column for entries that sum eachother to "0" like the example above???
Please let me know if anyone has any suggestions or ideas. Thanks