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

[µo°Ý] ¦p¦ó­pºâ¯B°Ê¦C¼Æ½d³òªº¥­§¡­È

[µo°Ý] ¦p¦ó­pºâ¯B°Ê¦C¼Æ½d³òªº¥­§¡­È

¥»©«³Ì«á¥Ñ jsleee ©ó 2013-1-15 21:59 ½s¿è

½Ð±Ð¥ý¶i
    ¦pªG§Úªº¤u§@ªí¦pªþ¥ó©Ò¥Ü¡A
    ²Ä¤@Ä欰¶µ¥Ø¡A²Ä¤GÄ榳¼Æ­È¡A§Ú·Q­n¦b²Ä¤TÄæ¶À¦â°Ï°ì
    ®I¤J¤½¦¡­pºâ²Ä¤GÄ檺¼Æ­Èªº¥­§¡
    ¦ý ¨C­Ó¶µ¥Øªº¦C¼Æ¥i¯à¨C¤@¦¸³£¤£¤@¼Ë...
    ´«¥y¸Ü»¡¡A¥Ø«eAAªº¦C¼Æ¦³4¦C¡A
    ¦ý¤U¤@¦¸AA¥i¯àÅܦ¨6¦C©Î¨ä¥Lªº¦C¼Æ
    ¨ä¥L¶µ¥Ø¤]¬O¤@¼Ë¡A¦C¼Æ³£·|¯B°Ê
    ¤£ª¾¹D³o¼Ëªº¨ç¼Æ¦p¦ó¼g¡HÁÙ¬O¥u¯à¥ÎVBA¡H
    §Úªº§xÂZ¬O ¤£ª¾¥Î¬Æ»ò¨ç¼Æ¨Ó¾÷°Ê§PÂ_ ©Ò»Ýªº½d³ò¦C¼Æ...
    ³Â·Ð ¥ý¶i­Ì«üÂI°g¬z¡AÁÂÁÂ

JS

¯B°Ê¦C¼Æ­pºâ.rar (5.92 KB)

¦^´_ 1# jsleee
½Ð°Ñ¦Ò
1¡B«ØijAÄæ»PBÄæµ¹¤©Äæ¦ì¦WºÙ¡A¦pAÄ欰¶µ¥Ø¦WºÙ¡ABÄ欰¼Æ¶q¡C
2¡B«Øij¦bBÄ榳¼Æ¾Úª¬ªp¤U¡AAÄæÀx¦s®æ¤ÅªÅ¥Õ¡A§YÄݩ󶵥ئWºÙ¬°AAªº¼Æ¾Ú¡A¨ä¹ïÀ³©óAÄæªÌÀ³¦³4­ÓAA¡C(¯q³B¡G¸ê®Æ²M·¡)
3¡B±µ°õ¦æ¡u´¡¤J_¼Ï¯Ã¤ÀªRªí¡v¡A±Ä¡u¥­§¡¼Æ¡v§e²{§Y¥i¡Cº¸«á­ì©l¤u§@ªí­Y¦³·s¼W¦C®É¡A¥u­n­«¾ã¼Ï¯Ã¤ÀªRªí§Y¥i§ó·s¤ÀªRµ²ªG¡C

TOP

½Ð±Ð¥ý¶i
    ¦pªG§Úªº¤u§@ªí¦pªþ¥ó©Ò¥Ü¡A
    ²Ä¤@Ä欰¶µ¥Ø¡A²Ä¤GÄ榳¼Æ­È¡A§Ú·Q­n¦b²Ä¤TÄæ¶À¦â°Ï°ì
   ...
jsleee µoªí©ó 2013-1-15 21:57


½Ð°Ñ¦Ò¨ºÀÉ®×,¬O¨º·N«ä¶Ü?

¯B°Ê¦C¼Æ­pºâ.rar (3.63 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-1-16 13:43 ½s¿è

¦^´_ 3# zz5151353
µo°ÝªÌ(1#¼Ó¥D)ªº»Ý¨D¦ü¥GÀH®É·|´¡¤J¤@¦C·s¼W¸ê®Æ¡A­Y¨Ì±z(3#¼Ó¥D)ªº«Øij¡Aºâ¦¡¥i¯à·|¥X°ÝÃD¡C

TOP

¦^´_ 3# zz5151353

zz¤j¤jªº¦^ÂЦü¥G¥i¦æ...
¦ý¦³ÂI¤£¸Ñ¸Ó¤½¦¡ªº²[¸q¡A¤£ª¾¯à§_µy·L¸ÑÄÀ¤@¤U
·P¿E¤£ºÉ

JS

TOP

¦^´_ 1# jsleee
©w¸q¦WºÙ
x=FREQUENCY(ROW(y),IF((y<>"")+(ROW(y)=21),ROW(y),""))
y=OFFSET(¤u§@ªí1!$A$1,,,COUNTA(¤u§@ªí1!$B:$B)+1,)
C1Àx¦s®æ¤½¦¡
=IF(A1="","",AVERAGE(OFFSET(B1,,,INDEX(x,COUNTA($A$1:A1)+1))))
¦V¤U½Æ»s
¯B°Ê¦C¼Æ­pºâ.rar (6.45 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh

½Ð±Ð ¶W¯Åª©¥D
¹ê¦b¤£¦n·N«ä¡A¦]¬°¬Ý¤£¤ÓÀ´
¯à§_ ¼·ªÅ¥Î ¸û¥Õ¸Üªº¤è¦¡ »¡©ú ¤½¦¡³]©w
¨ä¤¤ ½d³ò x ªº³]©w & "C" Ä檺¤½¦¡ ¤ñ¸ûµLªk²z¸Ñ....
©Î¬O¦³¬Æ»ò ¨ä¥Lªº°Ñ¦Ò¸ê°T¥i¥H°Ñ¦Ò
·P¿E¤£ºÉ

JS

TOP

¦^´_ 7# jsleee
½d¨Òªº°µªk¬°°t¦X¸ê®Æ¶qÅÜ°Ê
x¦WºÙªº¤½¦¡§ï¬°=FREQUENCY(ROW(y),IF((y<>"")+(ROW(y)=ROWS(y)),ROW(y),""))

x¦WºÙªº¥Î·N¦b¶Ç¦^¨C­Ó¤ÀÃþ¸ê®Æ¶q
¥HÀɮ׸ê®Æ¨Ó»¡¡A·|¶Ç¦^°}¦C{1,4,2,6,3,5}
©Ò¥H­Y¥HAÄ欰«DªÅ®æªº¬Û¹ïBÄæ¦ì¸m¡A¦V¤UÂX®iªº¸ê®Æ§@¥­§¡´N¬O¦U¤À²Õªº¥­§¡

¥HC1¦Ó¨¥¡AA1¶µ¥Øªº¸ê®Æ¶q¬Oxªº²Ä2­Ó­È=4
©Ò¥HOFFSET(B1,,,INDEX(x,COUNTA($A$1:A1)+1))
¤¤½d³òªº¦C¼Æ¬OINDEX(x,COUNTA($A$1:A1)+1)
´N¬O­pºâAÄæ«DªÅ®æªº¼Æ¶q¥[1¨Ó«ü©wx°}¦C¤¤ªº§Ç¦C¼Æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh

«D±`ÁÂÁ ¶W¯Åª©¥D ­@¤ßªº»¡©ú¡AµL©` ·M¶wªº§ÚÁÙ¬O¤@ª¾¥b¸Ñ
§Ú¹Á¸Õ®M¥Î³o¼Ëªº§@ªk¦bªþ¥óªº ´ú¸Õ Àɮפ¤
¦ý¥u¦³´X¦Cªº¼Æ¾Ú¬O¥¿½Tªº¡A¤§«áªº¼Æ¾Ú´N¥X°ÝÃD...

ªþ¥ó¤¤ ªº JÄæ ¬O§Ú­nªºµ²ªG¡A
                  JÄæ=IÄæ¼Æ­È¬Û­¼ªºµ²ªG¡A¬Û­¼ªº¨Ì¾Ú¬O®Ú¾Ú CÄ檺¶µ¥Ø
                  KÄæ «h¬OÅçºâ
¨ä¤¤ ²Ä14¦C~30¦C µ²ªG³£ÁÙ¥¿±`¡A¦ý±q 31¦C¶}©l¡A¼Æ¾Ú´N¥X²{°ÝÃD...

¯à§_¦b³Ò·Ð ¶W¯Åª©¥D ¨ó§U½T»{¤@¤U§Úªº°ÝÃD¬O¥X¦b­þ¸Ì¡H
·P¿E¤£ºÉ

JS

´ú¸Õ.zip (20.38 KB)

TOP

¦^´_ 9# jsleee
¦]¬°¸ê®Æ½d³ò¨Ã«D±qE1¶}©l
©Ò¥HROWS(y)¨Ã¤£·|¬O50
©w¸q¦WºÙx¤½¦¡§ï¬°
=FREQUENCY(ROW(y),IF((y<>"")+(ROW(y)=ROWS(y)+ROW(y)-1),ROW(y),""))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD