moved from the big boys forum to here. apologies for cross posting...
I have a single worksheet of over 8000 lines. They are all transaction that are identified by an email address. Every 'in' should have an associated 'out' on the same email address. How do I run a query (and is that the best way..?) 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.
Administrative Note:
- Thank you for implying we are a lesser forum, but…
- Please see Forum Rule #8 about cross posting and adjust accordingly...
- Added for you this time, but please do it in the future…Thanks.
- Cross post
Bookmarks