Automatically letter debits/credits

[tonyjyoo]

Hello,

Random question. Is there any way to automatically put in letters for each pair of debit and credits I have in journal entries within excel?

For example, I would need A, B, C, D, etc. in a red circle.

Thanks,
Tony

 

[Gerald Higgins]

What does your source data look like ?
Is it obvious how entries are paired, or do we have to identify the pairs somehow ?

 

[Krayons]

Please be more specific. A sample of how your data structure is setup and a sample of what you're looking for the result to be, would help.

 

[tonyjyoo]

Please be more specific. A sample of how your data structure is setup and a sample of what you're looking for the result to be, would help.

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.

 

[Rick Rothstein]

For example, take a look at this journal entry:

\\jacksonnational.com\homedir\npcuser1\vxh0615\My Pictures\Capture.MHT

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.

 

[Gerald Higgins]

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 ?

 

[Joe4]

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.

 

[tonyjyoo]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Description[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Example A[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]Example A[/TD]
[TD]-1000[/TD]
[/TR]
[TR]
[TD]Example B[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Example B[/TD]
[TD]-200[/TD]
[/TR]
[TR]
[TD]Example C[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Example C[/TD]
[TD]-50[/TD]
[/TR]
[TR]
[TD]Example C[/TD]
[TD]-50[/TD]
[/TR]
[TR]
[TD]Example D[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Example D[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Example D[/TD]
[TD]-40[/TD]
[/TR]
</tbody>[/TABLE]

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?

 

[tonyjyoo]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Description[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Example A[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]Example A[/TD]
[TD]-1000[/TD]
[/TR]
[TR]
[TD]Example B[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Example B[/TD]
[TD]-200[/TD]
[/TR]
[TR]
[TD]Example C[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Example C[/TD]
[TD]-50[/TD]
[/TR]
[TR]
[TD]Example C[/TD]
[TD]-50[/TD]
[/TR]
[TR]
[TD]Example D[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Example D[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Example D[/TD]
[TD]-40[/TD]
[/TR]
</tbody>[/TABLE]

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?

Anyone??

 

[Gerald Higgins]

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

... ?