How do I add line numbers to the lines for each transaction on a journal entry report.

In column C I want to add the line number for each line that has the same transaction number in column D. Then start a new set of line numbers for the next transaction number.

Hi,

According to your description, I actually can't understand your issue clarity, would you like to share us a sample file or some screenshots?

I assume the scenario: you want to add the line/row numbers automatically when type a new transaction record. If so, we may use Row formula. For example:

• =ROW(A1) returns the number 1.
• To enter specific sequential number codes. To start a numbered list with 000-001, you enter the formula =TEXT(ROW(A1),"000-000")

Reference:

https://support.office.microsoft.com/en-gb/article/Automatically-number-rows-76ce49e3-d8d2-459b-bd85-ee1d3973e6e6?CorrelationId=7c89eb49-83aa-4ba7-b936-4d94e522cc3c&ui=en-US&rs=en-GB&ad=GB

If I misunderstand something, please feel free let me know.

Regards,

George Zhao
TechNet Community Support