Excel Dynamic Array Formula Help

[mazher]

Hi Excel Gurus,

I need sone help / suggestion and explanation

I am using the below formula and is working fine. (Excel 365)

=UNIQUE(Pending[[INVOICE NO]:[CONTRACT]])

Column N is the INVOICE Number
Column M Is the CONTRACT

I am using this formula in O5 = MID(N5,5,3) and is working fine

Is there a way I can just use
=MID(UNIQUE(Pending[INVOICE NO]), 5-3)

I need to use the MID function only first column spilled range

Thanks is advance

 

[Fluff]

How about

=LET(u,UNIQUE(Pending[[Invoice No]:[Contract]]),HSTACK(MID(INDEX(u,,1),5,3),INDEX(u,,2)))

 

[shaowu459]

another option for your reference. change A1:B2 to your actual table reference.

工作簿1
	A	B	C	D	E	F
1	abcd123t	def		123	def
2	ccccggy2	hhhh		ggy	hhhh
3
Sheet1

Cell Formulas
Range	Formula
D1:E2	D1	=MID(A1:B2,{5,1},{3,99})
Dynamic array formulas.

 

[mazher]

Thanks @Fluff and @shaowu459

 

[Fluff]

Glad we could help & thanks for the feedback.