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

2­Ó¨ç¼Æªº°ÝÃD

2­Ó¨ç¼Æªº°ÝÃD

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-7-23 15:41 ½s¿è

sheet1  §ä¥XA:A¦³¦h¤Ö­Ó¥u©w¼Æ.
sheet2  A:A ³Ì«áªº¸ê®Æ¤U1®æªºB:B¥XE:E©Ò¦³¸ê®Æ.
  
¦]¬°§Ú¥H¥Î¤F1­Ó ¼Æ²Õ¤½¦¡,¤£¯à¥Î²Ä2­Ó(1¥Î·|HAND¾÷><)
½Ð¤j¤jªù«ü±Ð.
KLL.rar (6.59 KB)
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# basarasy


    ²Ä1­Ó°ÝÃD½Ð°Ñ¦Ò¤£­«½Æ²M³æ°Q½×
²Ä2­Ó°ÝÃD
E1=IF(ROW(A1)>LOOKUP("ÅÔ",B:B,ROW(A:A))-LOOKUP("ÅÔ",A:A,ROW(A:A)),"",INDEX(INDIRECT("R"&LOOKUP("ÅÔ",A:A,ROW(A:A))+1&"C2:R"&LOOKUP("ÅÔ",B:B,ROW(B:B))&"C2",0),ROW(A1)))
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-7-23 19:56 ½s¿è

¦^´_ 2# Hsieh


    ÁÂÁÂHsieh¤j¤j.
¦ý§Ú·Q­nªº¬O B:B¥XE:Eªº¼Æ.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# basarasy


    B1=IF((COUNTBLANK($A$1:A1)=0)+(COUNTBLANK($A$1:A1)>LOOKUP("ÅÔ",E:E,ROW(A:A))),"",OFFSET($E$1,COUNTBLANK($A$1:A1)-1,))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-7-23 20:18 ½s¿è

¦^´_ 4# Hsieh


    ÁÂÁ¤j¤j><
§Ú§ä¹L ¤£­«½Æ²M³æ°Q½×¤F,¦ý¬O§ä¤£¨ì§Ú­nªº¤½¦¡.

§Ú«Y·Q­n  a:a¦³¸ê®Æa,b,c,d...   ¦³­«½Æ ¦³¤£­«½Æ   ¦bc:c¥X  a¦³¦h¤Ö­Ó  b¦³¦h¤Ö­Ó.......
§Ú¬Ý¹Lsumif,¦ýsumif¥u¬O§ä¼Æ¦r.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

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

TOP

¦^´_ 6# Hsieh


    ÁÂÁÂHsieh¤j¤j.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD