·Q§ä¥X³Ìªñ¤ë¥÷ªºª÷ÃB

chen890708

¦]¬Y¨Ç³¡«~¦³¨C­Ó¤ë¥Í²£¦³ªº¨S¦³,·Q§ä¥X³Ìªñ¤ë¥÷ªºª÷ÃB

ªþÀɶÀ¦â¬°·Q§ä¥X¤§ª÷ÃB

½Ð°Ý¦³¤½¦¡¥i§ä¥X¶Ü?

ÁÂÁÂ

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

lin

ªþÀɶÀ¦â ¨Ã«D³Ìªñ¤ë¥÷

chen890708

¦^´_ 2# Hsieh


    ±z¦n

¤£¦n·N«ä

§Ú¦³¸ÕµÛ­×§ïÄæ¦ì

¼Ð¾ï¦âªº³¡¥÷ª÷ÃB¦³°ÝÃD

ÀÉ®×¥¼¼Ð¾ï¦â³¡¤À¤]¦³°ÝÃD(º|±¼¥¼¼Ð¥Ü¨ì)

¦A½Ð±Ð¬°¦ó·|¦p¦¹©O?

ÁÂÁÂ

chen890708

¦^´_ 2# Hsieh


    Hsieh ª©¥D

    ·Ð½Ð±z¨ó§U  

     ¦]¹ê»Ú³B²z¸ê®Æµ§¼Æ¬Û·í¥iÆ[  »Ý­n¤½¦¡¨ó§U

     «ô°Uª©¥D¤F

     ÁÂÁÂ

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

chen890708

¦^´_ 6# Hsieh


    ª©¥D¦n

    §Ú½Æ»s¤F¤½¦¡  ¥i¬O¤@ª½Åã¥Ü¿ù»~

     ¥i¥H½Ðª©¥D±N±z´ú¸ÕªºÀɮפW¶Ç¶Ü?

      ª½±µ¥H±zªº¤½¦¡°Ñ¦Ò

     §Ú¨Ì±zµ¹¤½¦¡¿é¤J¥X²{°ÝÃD   ¤£ª¾­ì¦]?

    ÁÂÁÂ

Hsieh

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

chen890708

¦^´_ 8# Hsieh

ª©¥D¦n

¯uªº«ÜÁÂÁ±zªº¨ó§U

¥i¥H¨Ï¥Î¤F

ÁÂÁÂ