Auto Generate unique number in serial if some condition match

[Vishaal]

we have the following sheet:-

New Microsoft Excel Worksheet.xlsx
	A	B	C	D	E
1	Unique No	Select	Name	Unique Code	Book Status
2		Call Work	Sevian
3		Work Recd.
4		Call Work	John
5		Work Recd.
6		Review
7		Call Work	Roz
8		Work Recd.
9		Recd/Started		!!SQ360#	Partial
10		Recd/Started		!!SQ360#	Partial
Sheet1

now we want to auto generate a unique number (which will be in serial) in sheet 2 column A if in column B we find "Call Work", check the following sheet

New Microsoft Excel Worksheet.xlsx
	A	B	C	D	E
1	Unique No	Select	Name	Unique Code	Book Status
2	!!SQ350#	Call Work	Sevian
3		Work Recd.
4	!!SQ351#	Call Work	John
5		Work Recd.
6		Review
7	!!SQ352#	Call Work	Roz
8		Work Recd.
9		Recd/Started		!!SQ352#	Partial
10		Recd/Started		!!SQ352#	Partial
11		work pending		!!SQ352#	Partial
Sheet2

Kindly help please

 

[Peter_SSs]

Something like this?

23 05 01.xlsm
	A	B
1	Unique No	Select
2	!!SQ350#	Call Work
3		Work Recd.
4	!!SQ351#	Call Work
5		Work Recd.
6		Review
7	!!SQ352#	Call Work
8		Work Recd.
9		Recd/Started
10		Recd/Started
Unique No.

Cell Formulas
Range	Formula
A2:A10	A2	=IF(B2="Call Work","!!SQ"&(349+COUNTIF(B$2:B2,"Call work"))&"#","")

 

[Vishaal]

Something like this?

23 05 01.xlsm
	A	B
1	Unique No	Select
2	!!SQ350#	Call Work
3		Work Recd.
4	!!SQ351#	Call Work
5		Work Recd.
6		Review
7	!!SQ352#	Call Work
8		Work Recd.
9		Recd/Started
10		Recd/Started
Unique No.

Cell Formulas
Range	Formula
A2:A10	A2	=IF(B2="Call Work","!!SQ"&(349+COUNTIF(B$2:B2,"Call work"))&"#","")

Thank you very much Peter_SSs,​

can we make arrayformula for this
=IF(B2="Call Work","!!SQ"&(349+COUNTIF(B$2:B2,"Call work"))&"#","")

 

[Peter_SSs]

can we make arrayformula for this

Why would you want to do that?