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

[µo°Ý] ¦p¦ó§ä¥X¹ïÀ³º¡¨¬3­Ó±ø¥óªº­È

[µo°Ý] ¦p¦ó§ä¥X¹ïÀ³º¡¨¬3­Ó±ø¥óªº­È

¦³¤@­Ó°ÝÃD·Q½Ð±Ð¦U¦ìª©¥D¡A¦p¦ó¨Ì¾Ú¥N¸¹¡B¤é´Á¡BÄæ¦ì¦WºÙ¡A§ä¥X¬Û¹ïÀ³ªº­È¡A¥Ø«e§Ú¥u°µ¨ì¤é´Á»PÄæ¦ì¡C
test2.rar (95.73 KB)

¦^´_  sujane0701


    4^8=4ªº8¦¸¤è=65536
Hsieh µoªí©ó 2010-6-17 21:35



©ú¥ÕÅo~    ÁÂÁÂHsieh ª©¥D«ü¾É!

TOP

¦^´_ 7# sujane0701


    4^8=4ªº8¦¸¤è=65536
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

B4 °}¦C¤½¦¡ ½Æ»s©¹¥k¤Î¤U¶K

{=INDEX(data!C:C,SMALL(IF(data!$B$2¡G$B$3500=$B$1,ROW($2¡G$3500),4^8), ...
zz5151353 µoªí©ó 2010-6-15 08:22



½Ð°Ý    zz5151353  ¤j®v
{=INDEX(data!C:C,SMALL(IF(data!$B$2¡G$B$3500=$B$1,ROW($2¡G$3500),4^8), ...
¤p§Ì·Q½Ð±Ð¨ä¤¤ 4^8ªº§t¸q,·Ð½Ð«ü¾É!!

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2010-6-15 08:25 ½s¿è

B4 °}¦C¤½¦¡ ½Æ»s©¹¥k¤Î¤U¶K

{=INDEX(data!C:C,SMALL(IF(data!$B$2¡G$B$3500=$B$1,ROW($2¡G$3500),4^8),ROW(1:1)))&""}

A4 °}¦C¤½¦¡ ½Æ»s©¹¤U¶K

{=TEXT(INDEX(data!A:A,SMALL(IF(data!$B$2¡G$B$3500=$B$1,ROW($2¡G$3500)),ROW(1:1))),"yyyy/m/d")}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_  asimov


        ÁÂÁÂasimovª©¥D´£¥Ü¡A§Ú³£§Ñ¤F¨S·Q¨ì¨Ï¥Î¶i¶¥¿z¿ïªº°µªk¡A¤@¬NÆp¬ã¨ç¼Æ°µªk¡A¦] ...
yuch8663 µoªí©ó 2010-6-13 10:43



«Ü°ª¿³¯àÀ°¤W¦£
¤p§Ì¤£¬Oª©¥D°Õ
ª©¥D¥\¤O³£°ª²`²ö´ú­C
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 2# asimov


        ÁÂÁÂasimovª©¥D´£¥Ü¡A§Ú³£§Ñ¤F¨S·Q¨ì¨Ï¥Î¶i¶¥¿z¿ïªº°µªk¡A¤@¬NÆp¬ã¨ç¼Æ°µªk¡A¦]¬°¸ê®Æ¼Æ«Ü¦h20000*30­ÓÀx¦s®æ¡A­è­è¸Õ¹L­Y®M¥Î°}¦C¨ç¼Æ­pºâªº«ÜºC¡A
         ¥t¥~¤]­n·PÁÂvictorlª©¥D¡AÁöµM§Úª¾¹D¼Ï¯Ã¤ÀªRªk³t«×¤S§Ö¤S·Ç¡A¦ý¤£§Q§Ú«á»s§@·~ªº³B²z(¨Ã«D¬O­n¨D²Î­p¼Æµ¥)¡A·|¹L©ó½ÆÂø¡AÁÙ¬O«Ü·PÁÂ!

TOP

§Q¥Î¼Ï¯Ã¥ç¥i§¹¦¨¸Ó®ÄªG


¦]¬°¨C¤@¹ïÀ³Äæ¦ì§¡¬°°ß¤@­È¡A¿ï¾Ü¥[Á`¡B³Ì¤j­È¡B³Ì¤p­È©Î¥­§¡³£¨S¦³®t(ªþ¹Ï¿ï¾Ü"¥[Á`")

TOP

¥»©«³Ì«á¥Ñ asimov ©ó 2010-6-13 01:30 ½s¿è

¦^´_ 1# yuch8663


¤é´Á¤w±Æ¦C¸û²³æ
¤èªk¤@
sheet1ªºa3Àx¦s®æ¿é¤Jsdate
a4=IF(COUNTIF(data!$B:$B,Sheet1!$B$1)>=ROW()-3,OFFSET(data!$A$1,MATCH($B$1,data!$B:$B,0)+ROW()-5,MATCH(A$3,data!$A$1:$G$1,0)-1),"")
¦V¥k¤Î¦V¤U½Æ»s
offset-1.zip (72.05 KB)

¤èªk¤G
¥Î¶i¶¥¿z¿ï²³æ¤S¤è«K
¦bdata¤u§@ªí©w¸q¦WºÙdata,½d³ò=data!$A$1:$G$3042
¥u­n³]©w·Ç«h½d³ò,´N¥i»´ÃP§¹¦¨
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD