LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Trying to reconcile a column

I have approximately 3000 lines of data that includes both positive and
negative numbers. This represents a clearing acount that does not clear to
zero as it should. Of the 3000 lines I have approx 100 of these that are
negative numbers. I need to find out what Positive numbers match the
negative numbers to zero when added. There are no formulas in this sheet.
Can Excel give me that answer?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a row to reconcile to a new worksheet Galen[_2_] Excel Worksheet Functions 1 October 31st 09 07:27 PM
form for bank reconcile Michele Charts and Charting in Excel 1 December 1st 07 05:42 PM
reconcile two months statement? achilles Excel Discussion (Misc queries) 0 March 17th 06 03:47 AM
How do I reconcile two sheets with in a .xls book? momy2cmt New Users to Excel 2 December 28th 05 03:15 PM
How do I reconcile bank statements? RONCPA Excel Worksheet Functions 2 September 12th 05 08:06 PM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"