Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts

    Formula or Macro to Match Values

    I have debit values in Col B & credit values in Col C

    I would like to set up a formula or macro to match the values that are the same and to delete the rows where these match
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    see attached file for formulas which will help.

    For any particular value, if the number of debits and credits is exactly the same for that particular value, then you could mark them all for deletion (e.g. if there are ten debits of $100 and ten credits of $100 they can all be deleted).
    However, if the counts don't match, you don't know which ones to pair off (unless you say keep the latest date values??)

    zeddy
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    Thanks for the help, match appreciated


    Howard

Posting Permissions

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