Formula for queue that reset once completed an order

[studentlearner]

So currently am working for a queue system that which reset the queue to number 1 once fulfilled the value

This is what i'm working with:

Username ID	Buyers ID	Buyers Total Order
T03	99	02
T01	98	03
T02	97	04

Once data entry is completed, there will be a button that triggers a formula and should look something like the bottom table:

Queue ID

Q99-T03-01

Q99-T03-02

Q98-T01-01

Q98-T01-02

Q98-T01-03

Q97-T02-01

Q97-T02-02

Q97-T02-03

Q97-T02-04

Question is if there is a formula which can have the queue extract the first table data onto something like the second table.
Any help would be great thank you!!

 

[Peter_SSs]

Could we use a helper column (it could be hidden)?
I have assumed that the values in the Buyers Total Order column are actually text values since they have leading zeros.

21 10 15.xlsm
	A	B	C	D	E	F
1	Username ID	Buyers ID	Buyers Total Order	0		Queue ID
2	T03	99	02	3		Q99-T03-02
3	T01	98	03	6		Q99-T03-02
4	T02	97	04	10		Q98-T01-03
5						Q98-T01-03
6						Q98-T01-03
7						Q97-T02-04
8						Q97-T02-04
9						Q97-T02-04
10						Q97-T02-04
11
12
Q

Cell Formulas
Range	Formula
D2:D4	D2	=SUM(--C$2:C2)+1
F2:F12	F2	=IF(ROWS(F$2:F2)>=MAX(D:D),"","Q"&TEXTJOIN("-",,INDEX(A:C,MATCH(ROWS(F$2:F2),D:D)+1,{2,1,3})))

 

[studentlearner]

Yeh i'll be using a helpers column, however i still need the Queue ID to reset once the buyer orders has been fulfilled

 

[Peter_SSs]

i still need the Queue ID to reset once the buyer orders has been fulfilled

What does that mean?

 

[studentlearner]

Instead of having the last digits with a fixed value

Queue ID

Q99-T03-02

Q99-T03-02

Q98-T01-03

Q98-T01-03

Q98-T01-03

Q97-T02-04

Q97-T02-04

Q97-T02-04

Q97-T02-04

It should be more like in a queue and resetting it once fulfilled particularly the last digits:

Queue ID

Q99-T03-01

Q99-T03-02

Q98-T01-01

Q98-T01-02

Q98-T01-03

Q97-T02-01

Q97-T02-02

Q97-T02-03

Q97-T02-04

 

[Peter_SSs]

Try this version.

studentlearner.xlsm
	A	B	C	D	E	F
1	Username ID	Buyers ID	Buyers Total Order	0		Queue ID
2	T03	99	02	3		Q99-T03-01
3	T01	98	03	6		Q99-T03-02
4	T02	97	04	10		Q98-T01-01
5						Q98-T01-02
6						Q98-T01-03
7						Q97-T02-01
8						Q97-T02-02
9						Q97-T02-03
10						Q97-T02-04
11
12
Q

Cell Formulas
Range	Formula
D2:D4	D2	=SUM(--C$2:C2)+1
F2:F12	F2	=LET(rws,ROWS(F$2:F2),pref,"Q"&TEXTJOIN("-",,INDEX(A:B,MATCH(rws,D:D)+1,{2,1})),IF(rws>=MAX(D:D),"",pref&TEXT(COUNTIF(F$1:F1,pref&"*")+1,"-00")))

 

[studentlearner]

That works great!! Thank You!!

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.