# Line Item Sequence No

1. ## 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

2. ## Re: Line Item Sequence No

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.

3. ## Re: Line Item Sequence No

in C3
=COUNTIF(B\$3:B3,B3)*10
and copy down

4. ## Re: Line Item Sequence No

c3=COUNTIF(B3:B\$3,B3)*10
``Please Login or Register  to view this content.``
Try this and copy towards down

5. ## Re: Line Item Sequence No

Originally Posted by nflsales
c3=COUNTIF(B3:B\$3,B3)*10
``Please Login or Register  to view this content.``
Try this and copy towards down
Shouldn't that be B\$3:B3 (I've not seen it written that way before) ?

6. ## Re: Line Item Sequence No

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.

7. ## Re: Line Item Sequence No

Hi guys

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

Thank you
Dan

8. ## Re: Line Item Sequence No

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.

9. ## Re: Line Item Sequence No

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

10. ## Re: Line Item Sequence No

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.

11. ## Re: Line Item Sequence No

Thanks Jason it works for me.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1