Results 1 to 10 of 10

Reconciliation

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2015
    Location
    Dubai
    MS-Off Ver
    2007
    Posts
    5

    Reconciliation

    I have 20k line items on my sheet which I need to match to reconcile my bank. There are multiple amounts of the same value. I need a formula that will create possible matches based on similar amounts that add up to zero (negative and positive)and highlight them. I have seen one thread with conditional formatting, but that didn't generate desired result and slowed down the excel program terribly. The data that needs matching is in column F of the attachment

    Regards
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Reconciliation
    By Shihab in forum Excel General
    Replies: 2
    Last Post: 01-12-2014, 12:21 PM
  2. Inventory Reconciliation
    By CKU in forum Excel General
    Replies: 10
    Last Post: 07-08-2013, 12:54 PM
  3. Reconciliation
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-22-2008, 05:05 AM
  4. Reconciliation
    By cmt_london in forum Excel General
    Replies: 1
    Last Post: 02-19-2008, 09:14 AM
  5. Reconciliation
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2005, 11:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1