incrementing rows for matching debits/credits
 

Hello:

I have a huge spreadsheet representing accounting journal entries. The
problem is that there is not a column for journal entries, so I have to
create one.

One column contains debits and the next column contains the corresponding
credits. This spreadsheet has over 16,000 rows. If you are familiar with
accounting, you know that a journal entry will match each set of matching
debits and credits. So, as you can imagine, there are thousands of potential
journal entries in this spreadsheet.

Is there a way to create a column of journal entries beginning with 1 and
incrementing by 1 for each set of matching debits and credits? Having to
manually type and create these journal entries in a column is taking hours
and I don't have that kind of time.

Thanks!

childofthe1980s

incrementing rows for matching debits/credits
 

Give an example of your data.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"childofthe1980s" wrote in
message ...
Hello:

I have a huge spreadsheet representing accounting journal entries. The
problem is that there is not a column for journal entries, so I have to
create one.

One column contains debits and the next column contains the corresponding
credits. This spreadsheet has over 16,000 rows. If you are familiar with
accounting, you know that a journal entry will match each set of matching
debits and credits. So, as you can imagine, there are thousands of
potential
journal entries in this spreadsheet.

Is there a way to create a column of journal entries beginning with 1 and
incrementing by 1 for each set of matching debits and credits? Having to
manually type and create these journal entries in a column is taking hours
and I don't have that kind of time.

Thanks!

childofthe1980s

incrementing rows for matching debits/credits
 

Hi Childofthe1980s,

If you (already) have the journal entries in sequence, then the response
provided by JE McGimpsey in your earlier (Incrementing every two rows)
thread should work.

If this sequential disposition does not pertain, then you need to provide
additional information. For instance what unique information identifies the
pairs of jounal entries such that these entries can be paired? Without
seeing your data, one would have expected date and reference keys. Armed
with an identifier, your problem resolves to a sorting operation, followed
by the implementation of JE's suggestion.

---
Regards,
Norman



"childofthe1980s" wrote in
message ...
Hello:

I have a huge spreadsheet representing accounting journal entries. The
problem is that there is not a column for journal entries, so I have to
create one.

One column contains debits and the next column contains the corresponding
credits. This spreadsheet has over 16,000 rows. If you are familiar with
accounting, you know that a journal entry will match each set of matching
debits and credits. So, as you can imagine, there are thousands of
potential
journal entries in this spreadsheet.

Is there a way to create a column of journal entries beginning with 1 and
incrementing by 1 for each set of matching debits and credits? Having to
manually type and create these journal entries in a column is taking hours
and I don't have that kind of time.

Thanks!

childofthe1980s