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

¦p¦ó¦³±ø¥ó²Î­p­Ó¼Æ

¦p¦ó¦³±ø¥ó²Î­p­Ó¼Æ

ASD.rar (1.54 KB) ½Ð°Ý¦ó¥Î¤½¦¡²Î­p
01¦Ü08,09¦Ü17,18¦Ü24¤§¶¡­Ó¼Æ.

¦p¦ó¦³±ø¥ó²Î­p­Ó¼Æ(½Ð Hsieh «ü¾É)

¥»©«³Ì«á¥Ñ mmggmm ©ó 2011-6-9 19:08 ½s¿è

DFG2.rar (26.36 KB) Hsieh¤j¤j½Ð±Ð叧¤@°ÝÃD,½Ð°Ý¦bC256...­pºâC3:C254¤º§tC00~C07,C08~15......¼Æ¶q

TOP

¸Õ¸Õ¬ÝC256°}¦C¤½¦¡
{=SUMPRODUCT(($A$3:$A$254=$A256)*(LOOKUP(IF(ISERROR(--RIGHT(C$3:C$254,2)),25,--RIGHT(C$3:C$254,2)),{0,8,16,25},{1,2,3,4})=COUNTIF($A$255:$A256,$A256)))}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­^¤å¦r¬O¦a°Ï¥N¸¹,¼Æ¦r¬°®É¶¡¥N¸¹¦p07¬°¦­¤W7®É23¬°±ß¤W11®É,¥u­pºâ¨C®É¬q¦³¼Æ­ÈªºÀx¦s®æ­Ó¼Æ,¨S¦³¼Æ­Èªº叧ºâ.¦hÁÂ

TOP

§Aªºªí®æ¬O­nºâ¬Æ»ò¼Ëªº­Ó¼Æ¥[Á`?
Á|­Ó¨ÒC256¬O­nºâA3:A254=A¦Ó¥BC3:C254ªº¼Æ¦r³¡¤À¬O0~7¶Ü?
C3:C254­Y¤£§t¼Æ­ÈªºÀx¦s®æºâ¤£ºâ¦b¤º?
½Ð©ú½T»¡©ú»Ý¨D
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³Â·Ð¤F DFG.rar (15.41 KB)

TOP

¦^´_ 6# mmggmm


    ¤W¶Ç¸ê®Æ¨Ó¬Ý¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ mmggmm ©ó 2011-6-8 14:51 ½s¿è

Hsieh ¦pªGA1:A22¤º¨ä¤¤¦³¤£§t¼Æ¦r´N¤£¯à­pºâ,½Ð°Ý¦p¦ó¸Ñ¨M,叧¦pªG¼Æ¦r¥Nªí¤p®É(24¤p®É¨î)¥i¥H¶Ü?

TOP

¯u¬O¤Ó¼F®`¤F...ÁöµM§Ú¦³·Q¹L¥ÎSUMPRODUCT¤ÎLOOKUPªº¤è¦¡¥h¸Ñ¡A
¤£¹Lê©ó¦h­Ó¼Æ¦rTRY¨ì³Ì«á¤´µL¸Ñ¡A¨S·Q¨ìH¶Wª©¤j¥HROWªº¤è¦¡¨Ó¸Ñ¡A
¯u¬O¤Ó´Î¤F¡I¦¬¤U¾Ç²ß°Õ~THANKS¡I
¨S¨Æ´N¨Ó³}³}

TOP

Hsieh ¦hÁ§Aªº«ü¾É

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD