三條件提取數據 (11793)

G8:I8 下拉{=IFERROR(INDEX(B:B,SMALL(IF(($A$2:$A$9=$H$2)*($C$2:$C$9>=EOMONTH($H$1,-1)+1)*($C$2:$C$9<=EOMONTH($H$1,0)),ROW($2:$9)),ROW(A1))),"")

G17:I17下拉{=IFERROR(INDEX(B:B,SMALL(IF(($A$2:$A$9=$H$11)*($C$2:$C$9>=EOMONTH($H$10,-1)+1)*($C$2:$C$9<=EOMONTH($H$10,0)),ROW($2:$9)),ROW(A1))),"")