Snasui Excel Forum

Hi Dear,

Good morning, hope you are all doing well.
I need your help how to return multiple times of value base on Next cell .
I can create a helper column and come up with results.

Is there any one way formula to do that without helper?


Thanks

...

G2

=INDEX(B:B,AGGREGATE(15,6,ROW($C$2:$C$4)/(COLUMN($A$2:$Z$2)<=$C$2:$C$4),ROWS($C$2:C2)))&CHAR(ROWS($G$2:G3)-VLOOKUP(ROWS($G$2:G2),A$2:A$4,1)+64)

Norkaz

...

If no need or without column "A"


G2

=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($C$2:$C$4)/(COLUMN($A$2:$Z$2)<=$C$2:$C$4),ROWS($C$2:C2)))&CHAR(ROWS($C$2:C3)-AGGREGATE(15,6,MATCH(ROW($C$2:$C$4),AGGREGATE(15,6,ROW($C$2:$C$4)/(COLUMN($A$2:$Z$2)<=$C$2:$C$4),ROW($C$2:$C$99)-ROW($C$2)+1),0)/((COLUMN($A$2:$Z$2)<=$C$2:$C$4)),ROWS($C$2:C2))+64),"")

Ctrl + Shift + Enter


Norkaz

Thank you