Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,468
    Thanks
    132
    Thanked 7 Times in 7 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
    3,045
    Thanks
    145
    Thanked 541 Times in 516 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,468
    Thanks
    132
    Thanked 7 Times in 7 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
  •