incrementing rows for matching debits/credits

[childofthe1980s]

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

 

[Damon Longworth]

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

 

[Norman Jones]

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.