夜雨聆风
=LET(
筛选结果, FILTER(A2:F11,C2:C11="一年级"),
HSTACK(
IF(SEQUENCE(ROWS(筛选结果)), "第二学期"),
CHOOSECOLS(筛选结果,{3,1,2,5})
)
)
【Excel函数】FILTER(行筛选)与CHOOSECOLS(列筛选)之后增加固定的列
=LET(
筛选结果, FILTER(A2:F11,C2:C11="一年级"),
HSTACK(
IF(SEQUENCE(ROWS(筛选结果)), "第二学期"),
CHOOSECOLS(筛选结果,{3,1,2,5})
)
)
