D2:G2下拉{=IFERROR(SMALL(IF(MONTH(DATE(ROW(INDIRECT($B$2&":"&$B$6)),2,29))=2+(D$1=$E$1),ROW(INDIRECT($B$2&":"&$B$6))),IF(COLUMN(A1)=1,ROW(A1),ROW(A1)*3-3+COLUMN(A1)-1)),"")
I2:L2下拉=IF(D2="","",MID("甲乙丙丁戊己庚辛壬癸",MOD(D2-4,10)+1,1)&MID("子丑寅卯辰巳午未申酉戌亥",MOD(D2-4,12)+1,1))
利用D:L對照表 B9=INDEX(I:L,SUMPRODUCT((D$2:G$99=A9)*ROW($2:$99)),SUMPRODUCT((D$2:G$99=A9)*{1,2,3,4}))
留言
張貼留言