Hsieh

¦^´_ 1# chen890708

G2°}¦C¤½¦¡
=IF(ROW(A1)>SUM(1/COUNTIF($A$2:$A$49,$A$2:$A$49)),"",INDIRECT("A"&MIN(IF(ISERROR(MATCH($A$2:$A$49,$G$1:G1,0)),ROW($A$2:$A$49),""))))
H2°}¦C¤½¦¡
=IF(G2="","",MAX(IF(($A$2:$A$49=G2)*($D$2:$D$49+$E$2:$E$49>0),$B$2:$B$49,"")))
¦V¤U½Æ»s¤½¦¡

I2=IF(G2="","",MAX(IF(($A$2:$A$49=G2)*($D$2:$D$49+$E$2:$E$49>0),$B$2:$B$49,"")))
¦V¥k¦V¤U½Æ»s¤½¦¡
  

¤U¸ü (21.47 KB)

2012-7-28 23:55

Hsieh

¦^´_ 5# chen890708

G2°}¦C¤½¦¡
=IF(ROW(A1)>SUM(1/COUNTIF($A$2:$A$49,$A$2:$A$49)),"",INDIRECT("A"&MIN(IF(ISERROR(MATCH($A$2:$A$49,$G$1:G1,0)),ROW($A$2:$A$49),""))))
¦V¤U½Æ»s

H2°}¦C¤½¦¡
=IF($G2="","",INDIRECT("R"&MAX(IF(($A$2:$A$49=$G2)*($D$2:$D$49+$E$2:$E$49>0),ROW($C$2:$C$49),""))&"C[-6]",0))  
¦V¤U¦V¥k½Æ»s

¤U¸ü (19.26 KB)

2012-7-29 23:27

Hsieh

¦^´_ 7# chen890708
³o©Î³\¬O§A½Æ»sªº³¡¤À¤£¥u¬O¤½¦¡¡A§t¥]§t¤F´«¦æ¦r¤¸©Ò­P
§A¸ÕµÛF2­«·s½s¿è¬Ý¬Ý
·í¥X²{¿ù»~«á¡A±N¤Ï¶Âªº¦r¤¸§R°£¸Õ¸Õ¬Ý