-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Automatically letter debits/credits
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
What does your source data look like ?
Is it obvious how entries are paired, or do we have to identify the pairs somehow ?
Is it obvious how entries are paired, or do we have to identify the pairs somehow ?
Upvote
0
Hello,
For example, take a look at this journal entry:
\\jacksonnational.com\homedir\npcuser1\vxh0615\My Pictures\Capture.MHT
For each pair of debits and credits (+/-), I would like to letter categorize, starting with A, then B, etc.
Upvote
0
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,463
- Office Version
- 365
- Platform
- Windows
That file appears to be located on a local (to you) server that is not accessible by the general public on the web... you will need to use OneDrive, DropBox or some other public file sharing facility to post your picture.
Last edited:
Upvote
0
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
And some forum users, including me, can't or don't want to follow links to files on public file sharing facilities.
The easiest way may be for you to enter some sample data directly into the text of a forum post.
Also, can you answer my earlier question please - is it obvious which entries are paired, or do we need to somehow identify paired items ?
The easiest way may be for you to enter some sample data directly into the text of a forum post.
Also, can you answer my earlier question please - is it obvious which entries are paired, or do we need to somehow identify paired items ?
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,171
- Office Version
- 365
- Platform
- Windows
Note that you can use the tools mentioned in Section B here to post images of your data: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html
Use the "Test Here" forum if you would like to practice posting with those tools before posting the image in this thread.
Use the "Test Here" forum if you would like to practice posting with those tools before posting the image in this thread.
Upvote
0
Forgive me for my noob-ness.
Basically, I have a set of data with debits and credits. Sometimes they will be in pairs, sometimes they won't. For example:
<tbody>
</tbody>
In this scenario:
- Example A would need to be marked "A" with a red circle (there is one credit of $1000 and one debit of $1000).
- Example B would need to be marked with a "B".
- Example C would need to be marked with a "C". (the 100,-50,-50 sum to 0 for my credit/debits)
-Example D would need to be marked "D".
Does this help?
Basically, I have a set of data with debits and credits. Sometimes they will be in pairs, sometimes they won't. For example:
| Description | Amount |
| Example A | 1000 |
| Example A | -1000 |
| Example B | 200 |
| Example B | -200 |
| Example C | 100 |
| Example C | -50 |
| Example C | -50 |
| Example D | 20 |
| Example D | 20 |
| Example D | -40 |
<tbody>
</tbody>
In this scenario:
- Example A would need to be marked "A" with a red circle (there is one credit of $1000 and one debit of $1000).
- Example B would need to be marked with a "B".
- Example C would need to be marked with a "C". (the 100,-50,-50 sum to 0 for my credit/debits)
-Example D would need to be marked "D".
Does this help?
Upvote
0
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Hmm, so we have some pairs of three, interesting . . . 
Is the data already sorted in such a way that all members of the same group are next to each other ?
Is it possible that you could also have a "pair" like this . . .
Example E 100
Example E 10
Example E -50
Example E -60
... ?
Is the data already sorted in such a way that all members of the same group are next to each other ?
Is it possible that you could also have a "pair" like this . . .
Example E 100
Example E 10
Example E -50
Example E -60
... ?
Upvote
0
Similar threads
- Question
- Question
