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

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

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

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

1.¨Ì·Óªþ¥ó¸ê®Æ,¥iª½±µ¥Î"¸ê®Æ­åªR"©Î"¦r¤¸¨ú¥N"  ±N"J" ¥þ³¡®ø°£
2.¤½¦¡¿é¤J¦p¤U
01¦Ü08        =COUNTIF(A1:A22,"<=8")
09¦Ü17        =COUNTIF(A1:A22,"<=17")-COUNTIF(A1:A22,"<=8")
18¦Ü24        =COUNTIF(A1:A22,"<=24")-COUNTIF(A1:A22,"<=17")

TOP

C1=SUMPRODUCT((LOOKUP(--RIGHT($A$1:$A$22,2),{0,9,18},{1,2,3})=ROW(A1))*1)
¦V¤U½Æ»s¦ÜC3
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

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

¥»©«³Ì«á¥Ñ 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

¦^´_ 6# mmggmm


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

TOP

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

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

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

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD