Formula to make queue with text

[studentlearner]

Question is there a formula for the below example?

From this:

Queue	Name	Order No.
	Jack	N01
	Jenny	N02
	Jenny	N03
	Kimmy	N04

To this:

Queue	Name	Order No.
N01Q01	Jack	N01
N02Q02	Jenny	N02
N03Q03	Jenny	N03
N01Q02	Kimmy	N04

1. So A2 gets the value of C2 and add letter "Q" and start a queue of "01".
2. Then subsequently A3 does the same thing, except it checks the above cell "A2" for its last two value which is the bold N01Q01.
3. the subsequent row will be on loop using the step number 2.

 

[KOKOSEK]

=C2&"Q"&ROW()-1

 

[studentlearner]

=C2&"Q"&ROW()-1

Thank You!! appreciate the help!

 

[Peter_SSs]

Welcome to the MrExcel board!

Thank You!! appreciate the help!

How does that produce the results you showed in post #1?
From what I can see, none of the results match yours.

(Also note that if any rows are subsequently added at the top of the sheet, the results will be even more different to yours)

21 10 09.xlsm
	A	B	C	D	E
1	Queue	Name	Order No.		Check
2	N01Q1	Jack	N01		FALSE
3	N02Q2	Jenny	N02		FALSE
4	N03Q3	Jenny	N03		FALSE
5	N04Q4	Kimmy	N04		FALSE
6
7	To this:
8	Queue	Name	Order No.
9	N01Q01	Jack	N01
10	N02Q02	Jenny	N02
11	N03Q03	Jenny	N03
12	N01Q02	Kimmy	N04
Queue

Cell Formulas
Range	Formula
A2:A5	A2	=C2&"Q"&ROW()-1
E2:E5	E2	=A2=A9

 

[mohadin]

What about

A2=C2&"Q"&MID(C2,2,255)

 

[Peter_SSs]

@studentlearner
I noticed that you marked my post (#4) as the solution to this thread. My post does not contain or suggest a solution so I have un-marked it as the solution.
My post was simply pointing out that the earlier suggestion does not produce the results you said you wanted.

BTW, post #5 also does not produce the results you showed in post #1 as what you wanted.

 

[mohadin]

SO

A2=C2&"Q"&MID(C2,2,255)
A3==C3&"Q"&IF(VALUE(RIGHT(A2,2)+1)<=9,"0","")&VALUE(RIGHT(A2,2)+1)

 

[Peter_SSs]

SO

A2=C2&"Q"&MID(C2,2,255)
A3==C3&"Q"&IF(VALUE(RIGHT(A2,2)+1)<=9,"0","")&VALUE(RIGHT(A2,2)+1)

Perhaps the OP has given incorrect expected results(?), but for the 4th row of sample data that gives
N04Q04
The expected results for that row show
N01Q02

That is all I have been trying to point out and hoping that the OP would clarify the expected results or provide some logic for how to arrive at the posted values.

 

[KOKOSEK]

That's typo according to point s 1 & 2 from initial post #1.
In row 4 should be N04Q04.

=C2&"Q"&TEXT(ROW()-1,"#00")