A9 陣列公式:
=IF(
COUNTA(A$8:A8)<=COUNTIF(项目明细!C$2:C$45,B$2),
LOOKUP(
MATCH(B$2,项目明细!C:C,)+ROW(A1)-1,
IF((项目明细!C$2:C$45=B$2)*(项目明细!B$2:B$45<>""),ROW($2:$45)),
项目明细!B$2:B$45),
"")
※陣列公式,請記得按Ctrl+Shift+Enter
B9 公式: =IF(A9="","",INDEX(项目明细!D:D,MATCH(B$2,项目明细!C:C,)+ROW(A1)-1,))
C9 公式: =IF(A9="","",INDEX(项目明细!E:E,MATCH(B$2,项目明细!C:C,)+ROW(A1)-1,))
※如果有解決您的問題,再請將帖子設為[已解決]
祝順心,南無阿彌陀佛!
|