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

¥Ò©M¤A¤£¯à¦P¤@¤Ñ½Ð°²ªº³]©w?

¥Ò©M¤A¤£¯à¦P¤@¤Ñ½Ð°²ªº³]©w?

½Ð°Ý¡G
¦b¦P¤@¤Ñ¤º¡A¥Ò©M¤A¤£¯à¦P®É½Ð°²¡A¨º­n¦p¦ó³]©w©O¡H
ÁÂÁ¡I

¦^´_ 1# q1a2z5


    °ò¥»¤W¥i¨Ï¥Î¸ê®ÆÅçÃÒ
½Ð¤W¶ÇÀɮסA¥H¤F¸ÑÅçÃÒ¤½¦¡¸Ó¦p¦ó³]­p
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð°Ý¡G
¦b¦P¤@¤Ñ¤º¡A¥Ò©M¤A¤£¯à¦P®É½Ð°²¡A¨º­n¦p¦ó³]©w©O¡H
ÁÂÁ¡I

­û¤u½Ð°².rar (6.62 KB)

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-3-20 18:55 ½s¿è

¦^´_ 3# q1a2z5

À³¸Ó­n¦³¥N²z¤HÄæ¦ì¤~¯àª¾¹D½Ö¤£¯à½Ð°²


   
­û¤u½Ð°².rar (6.8 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

±N­û¤u¤À¬°¢Ï,B¤G²Õ¡A¦b¤@¤Ñ¤º¢Ï²Õ¥u¯à¦³¤@­Ó­û¤u½Ð°²¡A
¦p¦³²Ä¤G­Ó­û¤u·Q½Ð°²¡A«h·|¥X²{¿ù»~°T®§¡A
½Ð°Ý¡G­n¦p¦ó³]©w©O¡H
ÁÂÁ¡I

­û¤u½Ð°².rar (8.3 KB)

TOP

¦^´_ 5# q1a2z5
¸Õ¸Õ¬Ýªþ¥ó
­û¤u½Ð°².zip (8.21 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-3-24 11:10 ½s¿è

¦^´_ 7# shan0948
  1. ¦WºÙ©w¸q:   ²Î­p¨C¤@²Õ¦P¤@¤Ñ½Ð°²¤H¼Æ        
  2. ¨BÆJ1: ¦WºÙ©w¸q®É, ­«­n¨BÆJ ¡÷ ·Æ¹«¥²»Ý¿ï©w E2                 
  3. ¨BÆJ2: ¨Ì§Ç©w¸q¦p A²Õ =SUM(COUNTIF($G$2:$G$4,B2:D2))        
  4. ¨BÆJ3: ¨Ì§Ç©w¸q¦p B²Õ =SUM(COUNTIF($H$2:$H$4,B2:D2))        
  5. ¨BÆJ3: ¨Ì§Ç©w¸q¦p C²Õ =SUM(COUNTIF($I$2:$I$5,B2:D2))        
  6. ¨BÆJ4: ¨Ì§Ç©w¸q¦p D²Õ =SUM(COUNTIF($J$2:$J$4,B2:D2))        
  7.         
  8. ¦WºÙ©w¸q§¹¦¨«á EÄ椽¦¡
  9. =IF(A²Õ>1,"A²Õ"&A²Õ&"¤H",IF(B²Õ>1,"B²Õ"&B²Õ&"¤H",IF(C²Õ>1,"C²Õ"&C²Õ&"¤H",IF(D²Õ>1,"D²Õ"&D²Õ&"¤H",""))))
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD