Next Invoice No.

[Sahak]

Hi All,

My Records

Descript Qty Invoice Number
Pen Red 525 SAM-041918-1
Can Led 328 SAM-041918-2
Pen Red 422 SAM-041918-2
Map Big 630 SAM-041918-3
Pen Red 245 SAM-041918-4
Map Big 600 SAM-041918-4

for 6 (six) records above I already created 4 (four) invoices
Invoice #: SAM-041918-1 (1 record)
Invoice #: SAM-041918-2 (2 records)
Invoice #: SAM-041918-3 (1 record)
Invoice #: SAM-041918-4 (2 records)

I need a formula to get next invoice No. The next invoice number should be SAM-041918-5 (no matter how many records will be included in that invoice)

Thank you in advance

 

[jtakw]

Hi,

If you only need a formula to generate the Next invoice number:

Excel 2010
	A
1	SAM-041918-1
2	SAM-041918-2
3	SAM-041918-3
4	SAM-041918-4
5	SAM-041918-5
Sheet18

Cell Formulas
Range	Formula
A2	=LEFT(A1,11)&MID(A1,12,255)+1

First invoice number manually entered, A2 formula copied down.
Let us know if that's not what you need, or there're more requirements.

 

[Sahak]

Thank you very much for your reply

I make invoices to different clients, in my example is SAM, it can be BNN, MBS, ABC …
I know for which client I should make an invoice. From my database I can get main part: SAM-041918, but I should know what is the maximum number of last part (after second dash), in my example it is “-4”, if I will know this, I will add 1 to 4 & will get 5 & add it to main part & it will become to SAM-041918-5