Closed Thread
Results 1 to 3 of 3

single sheet, list of transactions- in and out. How to identify incomplete transactions?

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    15

    Smile single sheet, list of transactions- in and out. How to identify incomplete transactions?

    I have asingle worksheet of over 8000 lines. They are all transaction that are identified by an email address. Every 'in' shoudl have an associated 'out' on the same email address. How do I run a quesry (is that the bestway..?) to identify the 'in' transactions that dont have a corresponding 'out' transaction?

    Yes, you guessed, I am almost complete novice to using excel other than for adding up and taking away long lists of numbers.

    Any help. suggestions, tutorials, previous posts much appreciated.

    Thanks for your time.

  2. #2
    Registered User
    Join Date
    09-17-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: single sheet, list of transactions- in and out. How to identify incomplete transactio

    just realised there is a sub forum for new users/basics. Will move post there...

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,196

    Re: single sheet, list of transactions- in and out. How to identify incomplete transactio

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort by Stock Name then list by Oppsite Transactions
    By SMJE in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-19-2011, 06:57 PM
  2. pay pal transactions
    By networkmom in forum Excel General
    Replies: 1
    Last Post: 02-18-2008, 01:42 AM
  3. Match a single deposit to seperate transactions
    By clap4thehandica in forum Excel General
    Replies: 3
    Last Post: 01-16-2008, 02:18 PM
  4. Help with sorting transactions
    By networkmom in forum Excel General
    Replies: 3
    Last Post: 01-23-2007, 12:00 AM
  5. [SOLVED] Creating a budget from a list of transactions
    By Mctabish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2005, 10:05 PM

Tags for this Thread

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