| ²é¿´: 984 | »Ø¸´: 1 | ||||
lascqyÒø³æ (СÓÐÃûÆø)
|
[½»Á÷]
ÔÚHSEÄÜ´øÊý¾Ý´¦ÀíÖеÄÎÊÌâ¼°½â¾ö ÒÑÓÐ1È˲ÎÓë
|
|
ÔÚWDD880227Ìáµ½µÄÖØÐÂÅÅÐò¹ý³ÌÖУ¨http://muchong.com/bbs/viewthread.php?tid=4241731&fpage=1£©£¬ÓÐÒ»¸öºÜÍ·ÌÛµÄÎÊÌ⣬ÒòΪÁÐÓëÁÐÖ®¼äÊÇÏà¹ØµÄ£¬ËùÒÔÖ»ÄÜÒ»ÁÐÒ»ÁеĽøÐÐÅÅÐò²Ù×÷¡£µ±ÄÜ´øÊý±È½Ï¶àµÄʱºò£¬¹¤×÷Á¿¾Í±È½Ï¿Ö²ÀÁË¡£¡£ ÓÚÊÇÎÒÃÇÏ£ÍûÄܶԶÔËùÓÐÁнøÐÐÏà¶Ô¶ÀÁ¢µÄÅÅÐò ÔÚOriginÖÐ×öÁ˺ܶೢÊÔ£¬ÄÜÁ¦ÓÐÏÞ£¬Ã»ÄÜʵÏÖoriginµÄºê²Ù×÷ Ï£ÍûÓиßÊÖÖ§³Ö¡£¡£ ÔÚexcelÖÐÒ²ÊÇͬÑùµÄÇé¿ö£¬µ«ÊÇÈ´Óз¨¿É½â¡£ ¶þÖÖ°ì·¨£¬ Ò»ÖÖÊÇÀûÓù«Ê½ ÀýÈç =SMALL($A$2:$A$12,ROW()-15) ÆäÖÐ15ÊÇÒ»¸ö²ÎÊý£¬´ú±í´ÓµÚ¼¸ÐÐÆðÊä³öÊý¾Ý£¬small±íʾ·µ»ØÊý¾Ý×éÖеÚK¸ö×îСֵ£¬Ç°±ßµÄA2£¬A12Ò²Êǿɱä²ÎÊý£¬¶ÔÓÚÔõôӦÓõ½ÆäËûÁС£¡£ÏàÐÅÓùýExeclµÄÈ˶¼Ã÷°×°É¡£¡£¡£ ÁíÒ»¸ö²Î¿¼¾ÍÊÇ ÔÚsheet2ÖпÉÒÔÕâÑù×ö =IF(ROW()>COUNTA(Sheet1!A$1:A$1000),"",SMALL(Sheet1!A$1:A$1000,ROW(1:1))) Õâ¸ö¹«Ê½°üº¬Ò»¸öÂß¼Åжϡ£¡£Èç¹ûÐкŴóÓÚÁÐÖУ¨COUNTA£©·ÇÁãµÄµ¥Ôª¸ñ£¬Ôò·µ»Ø¿Õ£¨¡°¡±£©Èç¹û²»´óÓÚ£¬Ôò·µ»ØSMALLµÄÖµ£¬ROWºó±ßÖ¸µÄÊǵ¥Ôª¸ñλÖÃ*:* ͬÑùÒ²ÊÇÖ®ºóÓ¦Óõ½ËùÓе¥Ôª¸ñ¡£¡£ µÚ¶þÖÖ·½·¨¡£¡£×ÔÈ»¾ÍÊǺêÁË ÀûÓÃVBA´úÂë sub colsort() Set ss = Selection For i = 1 To ss.Columns.Count ss.Columns(i).Sort Key1:=ss.Columns(i), Order1:=xlAscending, Header:=xlNo, _ Orientation:=xlTopToBottom Next End Sub È»ºóÖ´Ðкê¾Í¿ÉÒÔÁË [ Last edited by lascqy on 2012-3-14 at 16:19 ] |
» ÊÕ¼±¾ÌûµÄÌÔÌûר¼ÍƼö
¿ÆÑа¡¿ÆÑÐ |
» ²ÂÄãϲ»¶
²ÄÁÏÓ뻯¹¤304ÇóBÇøµ÷¼Á
ÒѾÓÐ7È˻ظ´
0703»¯Ñ§336·ÖÇóµ÷¼Á
ÒѾÓÐ4È˻ظ´
[¸´ÊÔµ÷¼Á]Î÷ÄϿƼ¼´óѧ¹ú·À/²ÄÁϵ¼Ê¦ÍƼö
ÒѾÓÐ6È˻ظ´
»¯Ñ§¹¤³Ì321·ÖÇóµ÷¼Á
ÒѾÓÐ12È˻ظ´
211±¾£¬11408Ò»Ö¾Ô¸ÖпÆÔº277·Ö£¬ÔøÔÚÖпÆÔº×Ô¶¯»¯Ëùʵϰ
ÒѾÓÐ4È˻ظ´
²ÄÁÏר˶326Çóµ÷¼Á
ÒѾÓÐ5È˻ظ´
¶«ÄÏ´óѧ364Çóµ÷¼Á
ÒѾÓÐ5È˻ظ´
¹ú×Ô¿ÆÃæÉÏ»ù½ð×ÖÌå
ÒѾÓÐ7È˻ظ´
ҩѧ383 Çóµ÷¼Á
ÒѾÓÐ4È˻ظ´
286Çóµ÷¼Á
ÒѾÓÐ5È˻ظ´
» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:
¼ÆËãʯīϩÄÜ´øºÍ̬ÃܶÈÓÐÎÊÌâ
ÒѾÓÐ17È˻ظ´
°ëµ¼ÌåÖеÄÄÜ´øÎÊÌâ
ÒѾÓÐ4È˻ظ´
¹ØÓÚHSE06¾²Ì¬¼ÆËãºÍHSE06ÄÜ´ø¼ÆËãµÄ¼¸¸öÌÖÂÛ
ÒѾÓÐ24È˻ظ´
´óÉñ¿´ÕâÀVASPÄÜ´øÖзÑÃ×Äܼ¶ÎÊÌâ
ÒѾÓÐ4È˻ظ´
ÄÜ´ø¼ÆËãµÄÎÊÌâ
ÒѾÓÐ5È˻ظ´
NBANDS µÄÉèÖÃÎÊÌâ
ÒѾÓÐ6È˻ظ´
HSEÄÜ´ø¼ÆËã³ö´í
ÒѾÓÐ6È˻ظ´
ÊÖ²áÖмÆËãÄÜ´øÊ±kµãÉèÖõÄÎÊÌâ
ÒѾÓÐ12È˻ظ´
ÇóÖú£º´øµçȱÏÝHSE06×ÜÄܼÆËã½á¹û·ËÒÄËù˼£¬Çë´Í½Ì£¡
ÒѾÓÐ11È˻ظ´
vasp»ÄÜ´øÍ¼µÄÒÉÎÊ
ÒѾÓÐ12È˻ظ´
HSEÄÜ´øÊý¾ÝÔÚoriginÖд¦ÀíµÄ¾ßÌå²½Öè
ÒѾÓÐ14È˻ظ´
HSEÄÜ´ø¼ÆËãÖÐISYM²ÎÊýµÄÎÊÌâ
ÒѾÓÐ7È˻ظ´
¹ØÓÚʹÓÃMSÖеÄCASTEPÈçºÎ¼ÆËãÄÜ´øµÄÎÊÌâ
ÒѾÓÐ9È˻ظ´
¡¾ÇóÖú¡¿¹ØÓÚMSÈí¼þÖÐÄÜ´øºÍ̬ÃܶȵļÆËãÎÊÌâ
ÒѾÓÐ8È˻ظ´
¡¾ÇóÖú¡¿Hse06¼ÆËãʱKPOINTS³ö´í
ÒѾÓÐ30È˻ظ´
¡¾ÇóÖú¡¿PBE0 ¼ÆËãSi¡¢GeÄÜ´ø½á¹¹
ÒѾÓÐ9È˻ظ´
WDD880227
ľ³æ (ÕýʽдÊÖ)
- 1STÇ¿Ìû: 1
- Ó¦Öú: 25 (СѧÉú)
- ¹ó±ö: 0.098
- ½ð±Ò: 1348.5
- É¢½ð: 194
- ºì»¨: 16
- Ìû×Ó: 761
- ÔÚÏß: 371.6Сʱ
- ³æºÅ: 1129580
- ×¢²á: 2010-10-22
- ÐÔ±ð: MM
- רҵ: Äý¾Û̬ÎïÐÔ II £ºµç×ӽṹ

2Â¥2012-03-14 16:18:59













»Ø¸´´ËÂ¥