Q最大值下方输入下面公式：=MAX(IF(Q2="",-9^9,INDIRECT("F" & (MATCH(Q2,A2:A5,0)+1)&":P" &(MATCH(Q2,A2:A5,0)+1))),IF(R2="",-9^9,INDIRECT("F" & (MATCH(R2,B2:B5,0)+1)&":P" &(MATCH(R2,B2:B5,0)+1))),IF(S2="",-9^9,INDIRECT("F" & (MATCH(S2,C2:C5,0)+1)&":P" &(MATCH(S2,C2:C5,0)+1))),IF(T2="",-9^9,INDIRECT("F" & (MATCH(T2,D2:D5,0)+1)&":P" &(MATCH(T2,...
|
