四個條件.

這公式有點長，在B3中輸入：

=IF(MAX(($A3&B$1=數(shù)據(jù)表!$H$2:$H$55&數(shù)據(jù)表!$B$2:$B$55)*(DATE(2007,4,1)=數(shù)據(jù)表!$A$2:$A$55)*(數(shù)據(jù)表!$D$2:$D$55))=0,"",INDIRECT("數(shù)據(jù)表!E"&MATCH(MAX(($A3&B$1=數(shù)據(jù)表!$H$2:$H$55&數(shù)據(jù)表!$B$2:$B$55)*(DATE(2007,4,1)=數(shù)據(jù)表!$A$2:$A$55)*(數(shù)據(jù)表!$D$2:$D$55)),($A3&B$1=數(shù)據(jù)表!$H$2:$H$55&數(shù)據(jù)表!$B$2:$B$55)*(DATE(2007,4,1)=數(shù)據(jù)表!$A$2:$A$55)*(數(shù)據(jù)表!$D$2:$D$55),0)+1))

注意：是數(shù)組公式，同時按ctrl + shift + 回車輸入。

然后拖動復制到其他單元格中！

請看附件