A problem in array formula

[ieumts]

hi everyone
in my excel file, please write an array formula in yellow cells like samples

[Olly]

Your workbook doesn't provide much explanation of what you want. But given the examples:


In B2, then copy down:

Please Login or Register  to view this content.

In B2, then copy down:

Please Login or Register  to view this content.

[samba_ravi]

see the attached file