假设 你的 y1 输入 在另外一个表的 A1 ,而表一的名字为sheet1 则:B1=IF(A1="","",MAX(IF(Sheet1!A2:A15=A1,Sheet1!B2:B15,"")))C1 =IF(A1="","",SUMPRODUCT((Sheet1!A2:A15=A1)*(Sheet1!B2:B15=MAX(IF(Sheet1!A2:A15=A1,Sheet1!B2:B15,0)))*Sheet1!C2:C15))D2=IF(A1="","",MODE(IF(Sheet1!$A2:$A15=$A1,Sheet1!D2:D15,""))) 向E、F 复制……以上都是数组公式 即:输入完工时光标在编辑栏 ... |