²é¿´: 2728  |  »Ø¸´: 2

shuyuan8239

ľ³æ (ÕýʽдÊÖ)

[ÇóÖú] originÊý¾Ý¹ý¶à£¬Ïë¸ô5¸öÊý¾Ý²É¼¯Ò»¸öÊý¾Ý£¡£¡

ÔÚÍøÉÏ¿´µ½ÁËÒ»ÖÖ·½·¨ÈçÏ£º
ÔÚ7.5ÖÐ ÏÈÔÚdataÀïÐÂÌí¼ÓÒ»ÁУ¬Ìî³äÐòºÅ£¨1£¬2£¬3.¡£¡£¡££© È»ºóAnalysis-----Extract  worksheets data ÔÚÌõ¼þ£¨if£©Àï±àдÈçÏ£º mod(col(ÐÂÌí¼ÓÁÐ)£¬n)=0 PS£ºÈ«²¿ÔÚÓ¢ÎÄ״̬ϱàд     nΪÄãÒªµÄ¼ä¸ô£¬±ÈÈçÄãÒª¸ô5¸öÊý¾Ý²É¼¯Ò»¸öÊý¾Ý£¬n=5 do it ¾Í»áÉú³ÉеÄData £¬   ¼´ÄãҪȡµÄÊý¾Ý£¬  ÕâÑù²úÉúµÄÊý¾Ý¾ÍÊǸôÒ»¶¨¾àÀëÈ¡³öÀ´µÄ¡£


ÎÒÊÔÁ˺ܶà´Î£¬»¹ÊÇûÓгɹ¦¹þ£¡ÎÒ±àдµÄ³ÌÐòÈçÏ£º
mod(col(J),5)=0
ÐÂÔö¼ÓµÄΪJÁУ¬Ã¿¸ö5¸öµãȡһ¸öµã£¡´íÔÚÄÄÀïÁËÄØ£¿£¿£¿


[ Last edited by shuyuan8239 on 2013-5-4 at 21:19 ]
»Ø¸´´ËÂ¥

» ÊÕ¼±¾ÌûµÄÌÔÌûר¼­ÍƼö

¿ÆÑÐ֪ʶ

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

646468128

Ìú¸Ëľ³æ (ÖøÃûдÊÖ)

̽·Õß......

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
shuyuan8239: ½ð±Ò+2, ¡ï¡ï¡ïºÜÓаïÖú, ллÄãµÄ°ïÖú£¡ 2013-05-05 09:33:37
ÇëÄãÏêϸ¿´ÏÂÃæÕâ¸öÌû×Ó£¡
²ÉÓÃexcellÒ²ÄÜʵÏÖ£¡

http://muchong.com/bbs/viewthread.php?tid=1816419&from=portal
Measure,whatismeasurable,andmakemeasurablethatwhichisnot.
2Â¥2013-05-04 23:47:06
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zbdfwq5777

ľ³æÖ®Íõ (ÎÄѧ̩¶·)

ÖÁ×ðɽÑò

ÎÄÏ׽ܳö¹±Ï×

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
cxqtitan: ½ð±Ò+1, лл·ÖÏí 2013-05-05 07:53:13
shuyuan8239: ½ð±Ò+8, ¡ï¡ï¡ï¡ï¡ï×î¼Ñ´ð°¸, лл£¡£¡£¡ 2013-05-05 09:33:46
°Ñ³ÌÐò¸Ä³ÉÕâÑù£ºmod(i,5)<1£¬Ó¦¸Ã¾Í¿ÉÒÔÿ¸ô5¸öѡһµãÁË
3Â¥2013-05-05 00:25:59
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ shuyuan8239 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 289Çóµ÷¼Á +9 »³èªÎÕè¤l 2026-03-20 9/450 2026-03-25 11:02 by userper
[¿¼ÑÐ] 07»¯Ñ§280·ÖÇóµ÷¼Á +7 722865 2026-03-23 7/350 2026-03-25 09:29 by aa331100
[¿¼ÑÐ] 289²ÄÁÏÓ뻯¹¤£¨085600£©BÇøÇóµ÷¼Á +4 ÕâôÃû×ÖÕ¦Ñù 2026-03-22 5/250 2026-03-25 08:20 by mx.yue
[¿¼ÑÐ] Ò»Ö¾Ô¸ÎäÀí085500»úеרҵ×Ü·Ö300Çóµ÷¼Á +3 an10101 2026-03-24 7/350 2026-03-25 00:00 by ɽ¹í0-
[¿¼ÑÐ] 0854È˹¤ÖÇÄÜ·½ÏòÕÐÊÕµ÷¼Á +3 ÕÂСÓã567 2026-03-24 3/150 2026-03-24 19:46 by zhouxuan..
[¿¼ÑÐ] 0854 ¿¼Ñе÷¼Á ÕÐÉúÁË£¡AI ·½Ïò +5 pk3725069 2026-03-19 17/850 2026-03-24 17:30 by zhouxuan..
[¿¼ÑÐ] ²ÄÁÏ¿¼Ñе÷¼ÁÉú +3 »ÆÁ»Ò»ÃÎǧÄê 2026-03-24 3/150 2026-03-24 17:00 by barlinike
[¿¼ÑÐ] 292Çóµ÷¼Á +4 ¶ì¶ì¶ì¶î¶î¶î¶î¶ 2026-03-24 4/200 2026-03-24 16:41 by peike
[¿¼ÑÐ] Ò»Ö¾Ô¸ÖØÇì´óѧ085700×ÊÔ´Óë»·¾³£¬×Ü·Ö308Çóµ÷¼Á +7 īīĮ 2026-03-23 8/400 2026-03-23 20:36 by Creta
[¿¼ÑÐ] ʯºÓ×Ó´óѧ£¨211¡¢Ë«Ò»Á÷£©Ë¶²©Ñо¿Éú³¤ÆÚÕÐÉú¹«¸æ +3 Àî×ÓÄ¿ 2026-03-22 3/150 2026-03-22 21:01 by ÔõôÊÍ»³
[¿¼ÑÐ] 269ר˶Çóµ÷¼Á +6 ½ð¶÷±´ 2026-03-21 6/300 2026-03-22 14:31 by ColorlessPI
[¿¼ÑÐ] 285Çóµ÷¼Á +6 ytter 2026-03-22 6/300 2026-03-22 12:09 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] ²ÄÁÏÇóµ÷¼Á +5 @taotao 2026-03-21 5/250 2026-03-21 20:55 by lbsjt
[¿¼ÑÐ] Ò»Ö¾Ô¸ÄÏ´ó£¬0703»¯Ñ§£¬·ÖÊý336£¬Çóµ÷¼Á +3 ÊÕµ½VS 2026-03-21 3/150 2026-03-21 18:42 by ѧԱ8dgXkO
[¿¼ÑÐ] Äϲý´óѧ²ÄÁÏר˶311·ÖÇóµ÷¼Á +6 77chaselx 2026-03-20 6/300 2026-03-21 07:24 by JourneyLucky
[¿¼ÑÐ] Ò»Ö¾Ô¸Î÷ÄϽ»´ó£¬Çóµ÷¼Á +5 ²Ä»¯ÖðÃÎÈË 2026-03-18 5/250 2026-03-21 00:26 by JourneyLucky
[¿¼ÑÐ] 308Çóµ÷¼Á +3 °¢½ã°¢½ã¼Ò°¡ 2026-03-18 3/150 2026-03-20 23:24 by JourneyLucky
[¿¼ÑÐ] Ò»Ö¾Ô¸Î人Àí¹¤²ÄÁϹ¤³Ìר˶µ÷¼Á +9 Doleres 2026-03-19 9/450 2026-03-20 22:36 by JourneyLucky
[¿¼ÑÐ] 295¸´ÊÔµ÷¼Á +8 ¼òľChuFront 2026-03-19 8/400 2026-03-20 20:44 by zhukairuo
[¿¼ÑÐ] ÕÐÊÕµ÷¼Á˶ʿ +4 lidianxing 2026-03-19 12/600 2026-03-20 12:25 by lidianxing
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û