±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 4245  |  »Ø¸´: 11
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

evildran

ÖÁ×ðľ³æ (ÕýʽдÊÖ)

×ÔÈ»

[½»Á÷] ¡¾ÇóÖú¡¿Excel ÖÐÔõÑù¼ä¸ôÈ¡µã£¿¡¾ÒÑÍê½á¡¿

ExcelÖÐÊý¾ÝÌ«¶àÁË£¬ÓÐ8000¶à¸ö£¬ÏÖÔÚÏëÒª´ÓÖÐѡȡһЩµäÐ͵쬻òÕßÊǹ̶¨¼ä¸ôµÄµã×÷ÇúÏß¡£ÓÐʲôºÏÊʵĺ¯Êý°¡£¿£¨×îºÃÊÇÄܼä¸ôÈ¡µãµÄ£¬¾ÍÊÇÿ¸ô¼¸¸öλÖã¬È¡Ò»¸öµã£¬ÄÇÑù×îºÃÁË¡££©

[ Last edited by nono2009 on 2010-1-26 at 16:11 ]
»Ø¸´´ËÂ¥

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

¿ÆÑÐÈí¼þСÉñÆ÷ »æÍ¼×¨ÓÃ

» ²ÂÄãϲ»¶

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

sxlion811

½ð³æ (ÕýʽдÊÖ)

¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï
ÓàÔó³É(½ð±Ò+1):ÐÁ¿à£¡ 1-25 17:44
evildran(½ð±Ò+10):·Ç³£¸Ðл£¡Õæ½â¾öÎÊÌ⣡ 1-25 17:45
ǰ¶Îʱ¼ä£¬ÓиöÈËÎÊÔõôÓÃorigin¼ä¸ôÈ¡µãµÄ¡£µ±Ê±Ñо¿origin£¬¾Í˳±ã°ÑexcelµÄ×ö·¨Ò²¸ã³öÀ´µÄ£¬¼û¸½¼þ£¬Ã¿5¸öµãȡһ¸ö£¬ÓÃOFFSETº¯Êý£¬µ±È»ÆäËûµÄº¯ÊýÒ²Äܰ쵽¡£

   =OFFSET($E$6,(ROW(E6)-ROW($E$6))*5,,)

[ Last edited by sxlion811 on 2010-1-25 at 17:31 ]
¿ªÐÄŬÁ¦Ò»±²×Ó
5Â¥2010-01-25 17:30:33
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 12 ¸ö»Ø´ð

nono2009

³¬¼¶°æÖ÷ (ÎÄѧ̩¶·)

No gains, no pains.

ÓÅÐãÇø³¤ÓÅÐãÇø³¤ÓÅÐãÇø³¤ÓÅÐãÇø³¤ÓÅÐã°æÖ÷

¡ï ¡ï ¡ï
ÓàÔó³É(½ð±Ò+1):ÐÁ¿àÁË£¡ 1-25 09:50
evildran(½ð±Ò+2):лл£¬ÎÒÏëÒª¾ßÌå¹ý³Ì£¬ºÇºÇ 1-25 17:42
×Ô¼ºÂ¼ÖÆÒ»¸ö¼ä¸ôÈ¡µãµÄºê¾Í¿ÉÒÔÁË¡£Å¼ÒÔǰÊÇÕâô×öµÄ£¬²»ÖªÏÖÔÚаæexcelÊÇ·ñ¿ÉÒÔ¸ü¼ÓÈÝÒ×µØ×öÁË¡£
2Â¥2010-01-24 22:43:07
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

jjdg

°æÖ÷ (ÖªÃû×÷¼Ò)

ÓÅÐã°æÖ÷

¡ï ¡ï ¡ï
ÓàÔó³É(½ð±Ò+1):ÐÁ¿àÁË£¡ 1-25 09:51
evildran(½ð±Ò+2):лл£¬ÄÜÏêϸ˵Ã÷²Ù×÷¹ý³ÌÂ𣿻òÕßËùÓú¯Êý 1-25 17:43
Èç¹ûÖ»ÓÐÒ»Áеϰ£¬»¹ÊÇд³ÌÐòÓÃÑ­»·¶Á·½±ã£¡
ŬÁ¦Ñ§Ï°£¡ÒÔÕýµ±Í¾¾¶£¡»ñµÃÐèÒªµÄ֪ʶ£¡
3Â¥2010-01-25 01:22:31
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

magic7004

½ð³æ (Ö°Òµ×÷¼Ò)

¡ï ¡ï ¡ï
ÓàÔó³É(½ð±Ò+1):ÐÁ¿àÁË£¡ 1-25 09:51
evildran(½ð±Ò+2):ÈÔÈ»¸Ðл£¡ 1-25 17:43
Ã²ËÆÖ»ÓÐÒ»Áеϰ£¬Ö±½ÓÓù«Ê½¾Í¿ÉÒÔÄñ~~

ps£ºÓÃÄǸö¹«Ê½ÎҾͲ»ÖªµÀÁË...
Á÷Ã¥²»¿ÉÅ£¬¿ÉŵÄÊÇÁ÷Ã¥ÓÐÎÄ»¯£¬ÓÐÎÄ»¯ÓÖBHµÄÁ÷Ã¥ÎÞµÐ~~£¡
4Â¥2010-01-25 02:43:00
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 324Çóµ÷¼Á +6 hanamiko 2026-03-26 8/400 2026-03-27 04:40 by wxiongid
[¿¼ÑÐ] Ò»Ö¾Ô¸Ö£´ó085600£¬310·ÖÇóµ÷¼Á +3 Àîäì¿É 2026-03-26 3/150 2026-03-27 03:39 by wxiongid
[¿¼ÑÐ] 316Çóµ÷¼Á +4 ½­´Ç666 2026-03-26 4/200 2026-03-27 00:33 by wxiongid
[¿¼ÑÐ] Ò»Ö¾Ô¸Ö£ÖÝ´óѧ£¬080500ѧ˶£¬×Ü·Ö317·ÖÇóµ÷¼Á +4 ¾Ù¸öÀõ×Óoi 2026-03-24 5/250 2026-03-26 23:15 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] 08¹¤Ñ§µ÷¼Á +13 Óû§573181 2026-03-20 20/1000 2026-03-26 21:22 by Óû§573181
[¿¼ÑÐ] 329Çóµ÷¼Á +5 1() 2026-03-22 5/250 2026-03-26 20:40 by fmesaito
[¿¼ÑÐ] 081200-11408-276ѧ˶Çóµ÷¼Á +3 ´Þwj 2026-03-26 3/150 2026-03-26 19:57 by nihaoar
[¿¼ÑÐ] Çóµ÷¼Á +8 Auroracx 2026-03-22 8/400 2026-03-26 19:55 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] 292Çóµ÷¼Á +9 ¶ì¶ì¶ì¶î¶î¶î¶î¶ 2026-03-25 10/500 2026-03-26 16:27 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] 263Çóµ÷¼Á +6 yqdszhdap£­ 2026-03-22 10/500 2026-03-26 13:11 by ¹«èªåÐÒ£
[¿¼ÑÐ] Çóµ÷¼Á +3 QiMing7 2026-03-25 3/150 2026-03-25 21:13 by ¸øÄãÄã×¢ÒâÐÝÏ¢
[¿¼ÑÐ] »úеѧ˶×Ü·Ö317Çóµ÷¼Á£¡£¡£¡£¡ +4 Acaciad 2026-03-25 4/200 2026-03-25 19:59 by hanserlol
[¿¼ÑÐ] 296Çóµ÷¼Á +4 Íô£¡£¿£¡ 2026-03-25 7/350 2026-03-25 16:41 by Íô£¡£¿£¡
[¿¼ÑÐ] 086003ʳƷ¹¤³ÌÇóµ÷¼Á +6 íµíµ111 2026-03-24 6/300 2026-03-25 10:29 by 3Strings
[¿¼ÑÐ] 289²ÄÁÏÓ뻯¹¤£¨085600£©BÇøÇóµ÷¼Á +4 ÕâôÃû×ÖÕ¦Ñù 2026-03-22 5/250 2026-03-25 08:20 by mx.yue
[¿¼ÑÐ] 306Çó0703µ÷¼ÁÒ»Ö¾Ô¸»ªÖÐʦ·¶ +10 Ö½Óãly 2026-03-21 11/550 2026-03-24 17:22 by qingfeng258
[¿¼ÑÐ] 307Çóµ÷¼Á +5 ³¬¼¶ÒÁ°º´óÍõ 2026-03-24 5/250 2026-03-24 15:46 by ÐÇ¿ÕÐÇÔÂ
[¿¼²©] 26É격×Ô¼ö +3 whh869393 2026-03-24 3/150 2026-03-24 09:55 by 21018060
[¿¼ÑÐ] 319Çóµ÷¼Á +4 СÁ¦Æøçæçæ 2026-03-20 4/200 2026-03-22 15:53 by ColorlessPI
[¿¼ÑÐ] 285Çóµ÷¼Á +6 ytter 2026-03-22 6/300 2026-03-22 12:09 by ÐÇ¿ÕÐÇÔÂ
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û