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

[µo°Ý] ¨C¤é¾÷¥x½s¸¹ÀH¾÷¥Ñ²M³æ²£¥Í¡A¨Ã¥B¦P¤@¤Ñ³£¦P¤@¥x¾÷¥x½s¸¹

[µo°Ý] ¨C¤é¾÷¥x½s¸¹ÀH¾÷¥Ñ²M³æ²£¥Í¡A¨Ã¥B¦P¤@¤Ñ³£¦P¤@¥x¾÷¥x½s¸¹

¥»©«³Ì«á¥Ñ jaga0828 ©ó 2018-1-9 10:36 ½s¿è

½Ð¦U¦ì°ª¤âÀ°À°¦£~·PÁÂ~¨ç¼Æ¦p¦ó¦b¶À¦â®æ¤ltry¥X¥H¤U¤º®e

1.¾÷¥x½s¸¹©T©w¬°¥kÃ䪺²M³æ¤º®e¡C
2.¶À©³ªÅ¥ÕÄæÀHµÛ¦P¤@­Ó¤u³æ¡A¦Û°ÊÀH¾÷¶]¥X¦P¤u³æ¦P¤@¥x¾÷¥x¡A¦p¤U¡C
3.¤£¦P¤Ñ¦ý¦P¤u³æ¸¹½X¡A¦Û°ÊÀH¾÷¶]¥X¨Óªº¾÷¥x½s¸¹¤£¥i¸ò¨ä¥¦¤Ñ¦P¤u³æ¸¹½XªºÀH¾÷¶]¥Xªº¾÷¥x¤@¼Ë¡C
4.¦P¤@¤Ñ¤@¼Ëªº¤u³æ¸¹½X¡A¾÷¥x½s¸¹»Ý­n¤@­P¡C

¦^´_ 1# jaga0828


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

®M¥Î¸Ó¤½¦¡«á¡A·í¥L§â¾÷¥x²M³æ¨Ï¥Î¨ì³Ì«á¤@­Ó½s¸¹®É¡A´N¨S¿ìªk¦Û¤v¦A±qÀY§ì¤F¡A¦A³Â·Ð¤j¤j¬Ý¤@¤U¡A·PÁÂ~

20180110.jpg (62.46 KB)

20180110.jpg

TOP

¦^´_ 3# jaga0828
=INDEX($G$2:$G$55,MOD(INT(SUMPRODUCT(1/COUNTIFS($A$2:$A2,$A$2:A2,$B$2:$B2,$B$2:B2)))-1,COUNT($G$1:$G$55))+1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤j¤j½Ð°Ý¤@¤U¡A¦pªG§â¾÷¥x½s¸¹¬°70/50/39 §ï¬°C1H1708020015 ½s½X¡A­n¦p§ï¨ç¼Æ¦³®ÄÅã¥Ü¥X¨Ó©O~
¦^´_ 4# Hsieh

TOP

¦^´_ 5# jaga0828


    =INDEX($G$2:$G$55,MOD(INT(SUMPRODUCT(1/COUNTIFS($A$2:$A2,$A$2:A2,$B$2:$B2,$B$2:B2)))-1,COUNTA($G$1:$G$55))+1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤j¤j§Ú¶K§A·sªº¨ç¼Æ¡A¦ý¬O¥L¥Î§¹¤@½ü¾÷¥x½s¸¹«á¡A¤U¤@­Ó·|¥X²{REF¡A¦A¤U¤@­Ó¤S¥¿±`¤F¡A¦A³Â·Ð¤j¤j¸Ñ¤@¤U~
¦^´_ 6# Hsieh

TOP

¦^´_ 7# jaga0828


    =INDEX($G$2:$G$55,MOD(INT(SUMPRODUCT(1/COUNTIFS($A$2:$A2,$A$2:A2,$B$2:$B2,$B$2:B2)))-1,COUNTA($G$2:$G$55))+1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¤j¤jªºÀ°¦£¡A·P®¦~

¦^´_ 8# Hsieh

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD