Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: contra entries

  1. #1
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a list of transactions against various accounts. Is it possible to quickly take out contra entries, e.g those with both a positive and a negative value in the same account.

    Help much appreciated as I have thousands of lines


  2. #2
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 07:59, crimlet wrote:
    I have a list of transactions against various accounts. Is it possible to quickly take out contra entries, e.g those with both a positive and a negative value in the same account.

    Help much appreciated as I have thousands of lines

    Just picked this from the bottom of the screen with no replies...so thought I would raise it.

    You could do it with code...
    Search recursively through the accounts,
    Find all matching accounts
    Check each value against others if equal and opposite then Mark in new column as Contra (perhaps better than deleting since we like audit trails...and you can always filter them out)
    loop through values
    loop through accounts.

    This will do it but will be slow.

    If its anything like an accounting system I worked on the system generated a text field for reversals therefore using other fields you may be able to limit the repetitive nature.

    Anyone have any other ideas?

    _________________


    [ This Message was edited by: s-o-s on 2002-05-03 08:58 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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