|
本帖最后由 lisachen 于 2011-5-5 14:18 编辑
长=INDEX($A$2:$A$101,SMALL(IF(MATCH($A$2:$A$13&"|"&$B$2:$B$13,$A$2:$A$13&"|"&$B$2:$B$13,)=ROW($1:$12),ROW($1:$12),100),ROW(A1)))&""
宽=INDEX($B$2:$B$101,SMALL(IF(MATCH($A$2:$A$13&"|"&$B$2:$B$13,$A$2:$A$13&"|"&$B$2:$B$13,)=ROW($1:$12),ROW($1:$12),100),ROW(A1)))&""
高=SUM(($A$2:$A$11&""=E2)*($B$2:$B$11&""=F2)*$C$2:$C$11)
长在E列 宽在F列 高在G列
数组公式 下拉
|
|