ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¥­ÉʤÀ°t«á¡A³Ñ¤U¨Óªº¤À°t¤½¦¡

[µo°Ý] ¥­ÉʤÀ°t«á¡A³Ñ¤U¨Óªº¤À°t¤½¦¡

¥»©«³Ì«á¥Ñ koala2099 ©ó 2017-11-2 23:59 ½s¿è

¤À²Õ¦h¥B¼Æ¦rÅܰʦ¸¼ÆÀWÁc
·QÂǥѤ½¦¡¦Û°Ê´«ºâ
¦ý~¤pªº²[¼Æ¯à¤O¦³­­:dizzy:
¨D·|ªº°ª¤â¤j¤j¨ó§U
·P¿E¤£ºÉ¡A3Q
¥­§¡¤À°t«á.rar (7.78 KB)

¦^´_ 1# koala2099

°Ñ¦Ò¬Ý¬Ý
    E4¶ñ¤J¡A¨ä¾l¤U©Ô
  1. =INT(VLOOKUP(B4,$J$4:$K$8,2,FALSE)/COUNTIF(B:B,B4))+IF(C4="1",MOD(VLOOKUP(B4,$J$4:$K$8,2,FALSE),COUNTIF(B:B,B4)),0)
½Æ»s¥N½X

TOP

¦^´_ 2# naruto018


¾Ç²ß¤F⋯⋯
·PÁ¡A§AÅý§Úªº¤u§@§ó¶¶§Q¤]§ïµ½¤F

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD