Formula to generate same information multiple times based on numbers given

[rap66]

Hi,
I need help with a formula to generate same information multiple times based on numbers given.
The details are in the attached excel file
Thank you very much for your help

Rap66

[T.I.]

Please try the below formula:
=IFNA(INDEX(C$1:C$7,MATCH(TRUE,MMULT(--(ROW(C$1:C$7)>=TRANSPOSE(ROW(C$1:C$7))),$A$1:$A$7)>=ROWS(L$1:L1),0)),"")
Confirmed with the CTRL+SHIFT+ENTER.

[rap66]

Thank you. I inserted the formula in column L1. It showed an error. See attachment. Please advise

[T.I.]

I suppose you did not read my instruction about pressing the CTRL+SHIFT+ENTER and not just ENTER
Array formulas need to be confirmed with 3 keys. This is not required in new offices (since 2021).

[rap66]

You're right! New at this.
thank you very much
Solved