Line Item Sequence No

Hi Guys,

One of the document i have received it should put a line item sequence Number(Please check the attachment) on each line item as a 10,20,30 etc...by now i entered it manually.please tell me if there have any formula how to do that. because i have more than one thousand data has to put a line sequence numbers in daily basis.

Thank you
dan

As long as the sheet is sorted so that all same invoice numbers are together (even if not in order).

Formula:

Please Login or Register  to view this content.

If they could be mixed, then

Formula:

Please Login or Register  to view this content.

Which over thousands of rows will be much slower to calculate.

Originally Posted by Special-K

Shouldn't that be B$3:B3 (I've not seen it written that way before) ?

No different to using Z100:A1 in a formula, excel will 'correct' it without errors.

Hi guys

It doesn't work for me.when i tried in my excel it gave me result as #NAME?
Please help me.

Thank you
Dan

Did you try the alternative that I suggested as well?

Which language is your PC set up for?

The suggestions provided might need translating if not English.

Hi Jason,

Actually C3 column is the result column that i want.it wasn't not in the original sheet.i really want sequence number for the one invoice line.it like this

15-10-00001 = 10
15-10-00001 = 20
15-10-00002 = 10 (This should comes again 10 Number Format)
15-10-00002 = 20
15-10-00002 = 30
15-10-00002 = 40
15-10-00003 = 10

Like this.
i thing you are clear about what i mean sir,

Thank you,
Dan

In your sample file, the formula goes in C3.

=IF(B3=B2,C2+10,10)

B3 refers to the invoice number in the same row, B2 refers to the heading, "Ref No" and C2 refers to the heading "S_ORD_ITEM".

As you copy it down, everything moves with the formula so the first part always looks at the same row as the formula, the second and third parts look 1 row above the formula.

Thanks Jason it works for me.