²é¿´: 624  |  »Ø¸´: 17
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£
¡¾ÐüÉͽð±Ò¡¿»Ø´ð±¾ÌûÎÊÌ⣬×÷Õßliyxok½«ÔùËÍÄú 1 ¸ö½ð±Ò

liyxok

Òø³æ (СÓÐÃûÆø)

[ÇóÖú] excel Êý¾ÝÅÅÐòÎÊÌâ

¸÷λÀÏ´ó£¬Çë½ÌÒ»¸öÎÊÌâ¡£
ÔÚexcelµÄAÁÐÖÐÓÐ1000¶à¸öÊý¾Ý£¬ÏÖÔÚÏë°ÑÊý¾ÝµÄ´ÎÐòµßµ¹Ò»Ï£¬£¨²»ÊǶԴóС½øÐÐÅÅÁУ¬£©²»ÖªÔõô×ö£¿


Ç¿ÁÒ¸Ðл£¡
abc_nm
Í­³æ

½ð±Ò: 56
Ìû×Ó: 75
Á÷Á¿: 0 B  
×¢²á: 2007-10-27
״̬: ÔÚÏß  
ÐÔ±ð: GG
רҵ: »¯Ñ§
ר¼­: µã»÷²é¿´


[ Last edited by liyxok on 2007-11-19 at 22:37 ]

» ²ÂÄãϲ»¶

Blog:http://liyxkkk.blog.163.com/ Ö÷Ò³£ºhttp://n.99081.com/liyxok/
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

tobyjerry

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

µÚÒ»ÖÖ£ºÊý¾Ýµ¼ÈëMATLAB½øÐд¦Àí

µÚ¶þÖÖ£º
±ÈÈçÄãµÄÊý¾ÝÊÇ¡°ÁÐA¡±£¬ÄÇôÔÚ¡°ÁÐB¡±Öн¨Á¢Ò»¸ö¸¨ÖúÐÔµÄÊýÁУ­£­¡°1 2 3 ... 10"£¬È»ºóͬʱѡÖÐÁ½ÁУ¬Ö´Ðв˵¥¡±Êý¾Ý¡°-->¡±ÅÅÐò¡°-->Ñ¡Ôñ¡±°´ÁÐB¡°£¬¡±½µÐò¡°£¬¼´¿É¡£

[ Last edited by tobyjerry on 2007-11-19 at 21:58 ]
2Â¥2007-11-19 21:54:46
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

abc_nm

ľ³æ (ÕýʽдÊÖ)

ÔÚAÁÐǰ²åÈëÒ»ÁУ¬Èç¹ûAÁÐÖÐÓÐ1000¸öÊý¾Ý£¬ÔòÔÚÕâÒ»ÁÐÖÐÊäÈë1£­1000£¬È»ºóÑ¡ÖÐÕâÒ»ÁкÍÄã±í¸ñÖÐµÄÆäËûÊý¾Ý£¬µãÊý¾Ý£­ÅÅÐò£­ÁÐA£¨´Ë´¦µÄÁÐAΪ¸Õ²åÈëµÄÄÇÁУ¬ÒòΪ²åÈëºóÔ­À´µÄÁÐA±äΪÁÐ BÁË£©½µÐò£­È·¶¨£¬È»ºóɾ³ý¸Õ²Å²åÈëµÄÁÐ
3Â¥2007-11-19 22:08:28
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

junzilx

Í­³æ (ÕýʽдÊÖ)

ÒýÓûØÌû:
Originally posted by liyxok at 2007-11-19 21:39:
¸÷λÀÏ´ó£¬Çë½ÌÒ»¸öÎÊÌâ¡£
ÔÚexcelµÄAÁÐÖÐÓÐ1000¶à¸öÊý¾Ý£¬ÏÖÔÚÏë°ÑÊý¾ÝµÄ´ÎÐòµßµ¹Ò»Ï£¬£¨²»ÊǶԴóС½øÐÐÅÅÁУ¬£©²»ÖªÔõô×ö£¿

²»¶Ô´óСÅÅÐò£¬ÄãÒª°´Ê²Ã´ÒªÇóÅÅ£¬×Ô¼º¿ÉÒÔÉèÖÃ
Éú»î¾ÍÊǵȴý£¬ÃÀÀöµÄµÈ´ý¡­¡­
4Â¥2007-11-19 22:21:38
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zzsskk

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

ħÊõÌùÕ³¿Û´ø

ºÃÎÊÌâ


[ Last edited by zzsskk on 2007-11-20 at 21:16 ]
Ìì¿Õ²»ÔøÁôÏÂÎҵĺۼ£©o¿ÉÎÒÒѾ­·É¹ý©uʱ¼äÓÌÈç¹ý϶µÄ°×¾Ô©oËùÒÔÎÒÃǸüÓ¦¸ÃÕäϧ©u
5Â¥2007-11-20 20:58:10
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

hobbyzhang

ÈÙÓþ°æÖ÷ (ÎÄ̳¾«Ó¢)

Сľ³æÊ×ϯ´ó·¨¹Ù

Excel ӦûÓÐÈκμòµ¥¹¦ÄÜ»òµ¥Ò»º¯Êý¹«Ê½È¥´¦ÀíÉÏÏ»ò×óÓÒµ÷µ½Ïà·´µÄλÖÃ
ÄǵoÓÐ×ÔÒÑÉè¼ÆÕë¶ÔÐԵĹ«Ê½ÁË, ·Ç³£¶à¹«Ê½(Ðè¶à¸öº¯Êý)¶¼¿ÉÒÔ×öµ½,ÒÔϵoÁгö²¿·Ö

1.) ¼ÙÉèB2:B9ÊÇÔ­À´Êý¾Ý, ¹«Ê½ÊÇ
=INDEX(B$2:B$9,ROWS(B$2:B$9)-ROW(A1)+1,1)
=OFFSET(B$2,ROWS(B$2:B$9)-ROW(A1),0)
=INDIRECT("B"&ROW(B$9)-ROW(A1)+1)
ÔÚC2ÊäÈëÒÔÉÏÈκÎÒ»Ìõ¹«Ê½, È»ºóÏòÏÂÍÏ

2.) ¼ÙÉèA2:H2ÊÇÔ­À´Êý¾Ý, ¹«Ê½ÊÇ
=INDEX($A2:$H2,1,COLUMNS($A2:$H2)-COLUMN(A1)+1)
=OFFSET($A2,0,COLUMNS($A2:$H2)-COLUMN(A1))
ÔÚA3ÊäÈëÒÔÉÏÈκÎÒ»Ìõ¹«Ê½, È»ºóÏòÓÒÍÏ


ÁíÍ⣺
Excel 2007 ºÃÏñ¿ÉÒԸ㶨
ÄãÏÂÔØ¸ö°æ±¾¿´¿´

http://publish.it168.com/2007/0817/20070817005701.shtml

[ Last edited by hobbyzhang on 2007-11-20 at 21:22 ]
Èç¹ûÎÒ¶ù×Ó³¤´óµ±¾üÈË£¬ÎÒ»á¸æËßËû£¬×öΪ¾üÈË£¬²»½öÒª·þ´ÓÃüÁ»¹Òª·þ´ÓÕæÀíºÍÕýÒ壬ÉúÄãµÄÊǸ¸Ä¸£¬ÑøÄãµÄÊǰÙÐÕ£¬ËùÒÔÄãËù×öµÄ£¬±ØÐë¶ÔÈËÃñÓÐÀû£¬ÓÀÔ¶¼Çס£¬.
6Â¥2007-11-20 21:19:14
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

yunshenglmm

Í­³æ (СÓÐÃûÆø)

abc_nm
Í­³æ
ÄÔ×ÓºÃʹ£¬ÎÊÌâÓ­Èжø½â
7Â¥2007-11-20 21:19:45
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zzsskk

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

ħÊõÌùÕ³¿Û´ø

hobbyzhang
ÊǸßÊÖ£¬Åå·þ
Ìì¿Õ²»ÔøÁôÏÂÎҵĺۼ£©o¿ÉÎÒÒѾ­·É¹ý©uʱ¼äÓÌÈç¹ý϶µÄ°×¾Ô©oËùÒÔÎÒÃǸüÓ¦¸ÃÕäϧ©u
8Â¥2007-11-20 21:43:47
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ÍÑçÖµÄÎÏÅ£

ľ³æ (СÓÐÃûÆø)

ѧϰÁË£¬Ð»Ð»
9Â¥2007-11-21 08:11:07
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

gbc001

Í­³æ (СÓÐÃûÆø)

ÎÒҲѧϰѧϰ
10Â¥2007-11-21 08:15:15
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ liyxok µÄÖ÷Ìâ¸üÐÂ
²»Ó¦Öú È·¶¨»ØÌûÓ¦Öú (×¢Ò⣺ӦÖú²Å¿ÉÄܱ»½±Àø£¬µ«²»ÔÊÐí¹àË®£¬±ØÐëÌîд15¸ö×Ö·ûÒÔÉÏ)
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Ò»Ö¾Ô¸ÖØÇì´óѧ085700×ÊÔ´Óë»·¾³£¬×Ü·Ö308Çóµ÷¼Á +3 īīĮ 2026-03-23 3/150 2026-03-23 11:14 by JourneyLucky
[¿¼ÑÐ] 291 Çóµ÷¼Á +4 »¯¹¤2026½ì±ÏÒµÉ 2026-03-21 4/200 2026-03-23 09:59 by bingchuan
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©»¯¹¤´óѧ 070300 ѧ˶ 336·Ö Çóµ÷¼Á +5 vvÃÔ 2026-03-22 5/250 2026-03-23 07:36 by Iveryant
[¿¼ÑÐ] Çóµ÷¼ÁÒ»Ö¾Ô¸º£´ó£¬0703»¯Ñ§Ñ§Ë¶304·Ö£¬Óдó´´ÏîÄ¿£¬Ëļ¶Òѹý +6 ÐÒÔËÁ¨Á¨ 2026-03-22 10/500 2026-03-22 20:10 by edmund7
[¿¼ÑÐ] Ò»Ö¾Ô¸ÉϺ£½»´óÉúÎïÓëҽҩר˶324·Ö£¬Çóµ÷¼Á +3 jiajunX 2026-03-22 3/150 2026-03-22 19:32 by brblmd
[¿¼ÑÐ] ÉúÎïѧ071000 329·ÖÇóµ÷¼Á +5 ÎÒ°®ÉúÎïÉúÎﰮΠ2026-03-17 5/250 2026-03-22 16:42 by tcx007
[¿¼ÑÐ] Ò»Ö¾Ô¸ Î÷±±´óѧ £¬070300»¯Ñ§Ñ§Ë¶£¬×Ü·Ö287£¬Ë«·ÇÒ»±¾£¬Çóµ÷¼Á¡£ +3 ³¿»èÏßÓëÐǺ£ 2026-03-20 3/150 2026-03-22 16:00 by ColorlessPI
[¿¼ÑÐ] 289Çóµ÷¼Á +7 »³èªÎÕè¤l 2026-03-20 7/350 2026-03-22 15:57 by ColorlessPI
[¿¼ÑÐ] Çóµ÷¼Á +3 13341 2026-03-20 3/150 2026-03-21 18:28 by ѧԱ8dgXkO
[¿¼ÑÐ] 297Çóµ÷¼Á +11 Ï·¾«µ¤µ¤µ¤ 2026-03-17 12/600 2026-03-21 17:47 by ColorlessPI
[¿¼ÑÐ] Ò»Ö¾Ô¸ÖйúʯÓÍ´óѧ£¨»ª¶«£© ±¾¿ÆÆë³¹¤Òµ´óѧ +3 ʯÄÜΰ 2026-03-17 3/150 2026-03-21 02:22 by JourneyLucky
[¿¼ÑÐ] Ò»Ö¾Ô¸»ªÄÏʦ´ó 070300£¨»¯Ñ§£©304·ÖÇóµ÷¼Á +3 0703ÎäÜ·»ÛÑ©304 2026-03-18 3/150 2026-03-21 00:48 by JourneyLucky
[¿¼ÑÐ] ÄϾ©´óѧ»¯Ñ§376Çóµ÷¼Á +3 hisfailed 2026-03-19 6/300 2026-03-20 23:43 by hisfailed
[¿¼ÑÐ] Çóµ÷¼Á£¬Ò»Ö¾Ô¸:ÄϾ©º½¿Õº½Ìì´óѧ´óѧ £¬080500²ÄÁÏ¿ÆÑ§Ó빤³Ìѧ˶£¬×Ü·Ö289·Ö +4 @taotao 2026-03-19 4/200 2026-03-20 22:14 by JourneyLucky
[¿¼ÑÐ] ÖÐÄÏ´óѧ»¯Ñ§Ñ§Ë¶337Çóµ÷¼Á +3 niko- 2026-03-19 6/300 2026-03-20 21:58 by luoyongfeng
[¿¼ÑÐ] 085410È˹¤ÖÇÄÜר˶317Çóµ÷¼Á£¨0854¶¼¿ÉÒÔ£© +4 xbxudjdn 2026-03-18 4/200 2026-03-20 09:07 by ²»168
[¿¼ÑÐ] 288Çóµ÷¼Á£¬Ò»Ö¾Ô¸»ªÄÏÀí¹¤´óѧ071005 +5 ioodiiij 2026-03-17 5/250 2026-03-19 18:22 by zcl123
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤Çóµ÷¼Á +6 Ð÷ÐÒÓë×Ó 2026-03-17 6/300 2026-03-19 13:27 by houyaoxu
[¿¼²©] 26²©Ê¿ÉêÇë +3 1042136743 2026-03-17 3/150 2026-03-17 23:30 by ÇáËɲ»ÉÙËæ
[¿¼ÑÐ] 275Çóµ÷¼Á +4 Ì«Ñô»¨ÌìÌ쿪ÐÄ 2026-03-16 4/200 2026-03-17 10:53 by ¹¦·ò·è¿ñ
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û