|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
开一个长火车,
=PRODUCT(INDEX(A:A,MAX(IF(MAX(A2:A16)=A2:A16,ROW(A2:A16),0))),MAX(IF(ROW(B2:B16)<>MAX(IF(MAX(A2:A16)=A2:A16,ROW(A2:A16),0)),B2:B16,0)),MAX(IF((ROW(C2:C16)<>MAX(IF(MAX(IF(ROW(B2:B16)<>MAX(IF(MAX(A2:A16)=A2:A16,ROW(A2:A16),0)),B2:B16,0))=B2:B16,ROW(B2:B16),0)))*(ROW(C2:C16)<>MAX(IF(MAX(A2:A16)=A2:A16,ROW(A2:A16),0))),C2:C16,0)),MAX(IF((ROW(C2:C16)<>MAX(IF(MAX(IF(ROW(B2:B16)<>MAX(IF(MAX(A2:A16)=A2:A16,ROW(A2:A16),0)),B2:B16,0))=B2:B16,ROW(B2:B16),0)))*(ROW(C2:C16)<>MAX(IF(MAX(A2:A16)=A2:A16,ROW(A2:A16),0)))*(ROW(D2:D16)<>MAX(IF(MAX(IF((ROW(C2:C16)<>MAX(IF(MAX(IF(ROW(B2:B16)<>MAX(IF(MAX(A2:A16)=A2:A16,ROW(A2:A16),0)),B2:B16,0))=B2:B16,ROW(B2:B16),0)))*(ROW(C2:C16)<>MAX(IF(MAX(A2:A16)=A2:A16,ROW(A2:A16),0))),C2:C16,0))=C2:C16,ROW(C2:C16),0))),D2:D16,0))) |
|