篩選 依照月份非空 (12746)

A11:I15{=OFFSET($A$1,SMALL(IF((LEFTB(LOOKUP("嫻",$A$9:A$9),2)-MONTH($C$1:$J$1)=0)*($C$2:$J$7<>""),ROW($1:$6),99),ROW(A1)),TEXT(MOD(COLUMN(C1),3),"[=2]99;0"))&""



留言