随单元格下拉完成需求

伤心的雨伞

有一部可以完成的嘛

保税科技

仅限于F列为单字符

陈保安

H3数组公式→关键是数组累加与合并！
=IFERROR(VLOOKUP(ROW(A1),CHOOSE({1,2},SUMIF(INDIRECT("G3:G"&ROW(A$3:A$8)),">0"),F$3:F$8),2,0),H4)

铌克

=IFERROR(INDEX(F$3:F$5,MATCH(1=1,ROW(A1)<=SUBTOTAL(9,OFFSET($G$3,,,ROW($1:$3))),)),"")

高度自律

专说实话

h3=IF(ROW(A1)<=SUM(G$3:G$5),INDEX(F:F,SMALL(IF(COLUMN(A:Z)<=G$3:G$5,ROW($3:$5)),ROW(A1))),"")
数组

彤毅

=LOOKUP(ROW(A1),SUMIF(OFFSET(G$2,,,ROW($1:$4),),"<>")+1,F$3:F$5)&""

又寂寞又美好

=IFERROR(INDEX($A$2:$A$4,MATCH(ROW(A1)-1,SUMIF(OFFSET($B$1,,,ROW($B$1:$B$4)),">0"))),"")