Hsieh

¦^´_ 1# baiecesi

°}¦C¤½¦¡
A3°}¦C¤½¦¡
=MATCH(A$2,ROW($50:$900),0)
B3°}¦C¤½¦¡
=MATCH(B$2,ROW($50:$400),0)       
C3°}¦C¤½¦¡
=MATCH(C$2,ROW($1:$76)-1,0)
A4°}¦C¤½¦¡
=MATCH(A$2,ROW($100:$1500),0)       
B4°}¦C¤½¦¡
=MATCH(B$2,ROW($100:$450),0)       
C4°}¦C¤½¦¡
=MATCH(C$2,ROW($1:$151)-1,0)
A5°}¦C¤½¦¡
=MATCH(A$2,ROW($50:$3500),0)       
B5°}¦C¤½¦¡
=MATCH(B$2,ROW($300:$1100),0)       
C5°}¦C¤½¦¡
=MATCH(C$2,ROW($1:$251)-1,0)
D3¤½¦¡=IF(SUMPRODUCT(ISNUMBER(A3:C3)*1)=3,ROW(A1),"")¦V¤U½Æ»s¨ìD6
E1¤½¦¡=IF(ROW(A1)>COUNT($D$3:$D$5),"",SMALL($D$3:$D$5,ROW(A1)))¦V¤U½Æ»s¨ìE3
©w¸q¦WºÙx=OFFSET(¤u§@ªí1!$E$1,,,COUNT(¤u§@ªí1!$E$1:$E$3),)
G1ÅçÃÒ=x

¤U¸ü (8.15 KB)

2012-8-17 15:09