µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ¦a§}·j´M«á¶ë¨ì¯S©wÄæ¦ì
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
¦a§}·j´M«á¶ë¨ì¯S©wÄæ¦ì
tsally22
µoµu®ø®§
¥[¬°¦n¤Í
tsally22
·í«eÂ÷½u
UID
5775
©«¤l
5
¥DÃD
3
ºëµØ
0
¿n¤À
14
ª÷¿ú
14
ÂI¦W
0
§@·~¨t²Î
VISTA
³nÅ骩¥»
OFFICE 2007
¾\ŪÅv
10
¦b½u®É¶¡
2 ¤p®É
µù¥U®É¶¡
2011-7-28
³Ì«áµn¿ý
2015-4-30
¤p¾Ç¥Í
©«¤l
5
¥DÃD
3
ºëµØ
0
¿n¤À
14
ÂI¦W
0
§@·~¨t²Î
VISTA
³nÅ骩¥»
OFFICE 2007
¾\ŪÅv
10
µù¥U®É¶¡
2011-7-28
³Ì«áµn¿ý
2015-4-30
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2012-4-2 17:44
|
¥u¬Ý¸Ó§@ªÌ
¦a§}·j´M«á¶ë¨ì¯S©wÄæ¦ì
±z¦n:
¦³¤j¶q¦a§}¸ê®Æ·Qn¨Ì·Ó©Ò·j´M¨ìªº¸ê®Æ,¦b¶ë¨ì¬Y¯S©wÄæ¦ì(¦p¤U¹Ï)
¤U¸ü
(22.44 KB)
2012-4-2 17:37
¦³¹Á¸Õ¹L¦b¬qÄæ¦ì¿é¤J"=LEFT($A$3,FIND($C2,$A3))" ·|¶]¥XXXXX´X¬qªº¸ê®Æ¡A¦ý«á¤è¸ê®Æ¨Ï¥Î¡¨=MID($A$3,FIND($C$2,$A$3)+1,FIND(E$2,$A$3)-FIND($C$2,$A$3))¡¨«o·|¦]¬°¦a§}ªø«×¤£¦P·|¥h¼vÅT¨ì+1,
¤£¾å±o¦³¤°»ò¨ç¼Æ¥i¥Hª½±µ±a¥Xªº¡H
Book3.rar
(3.89 KB)
¤U¸ü¦¸¼Æ: 10
2012-4-2 17:44
¼Ó¥D¼ö©«
°_°Ý·sªº¤é´Á«h²£¥Í·sªº¬y¤ô¸¹
¦a§} ¥u¨ú¤å¦r¤£¨ú¼Æ¦r
¦¬ÂÃ
¤À¨É
register313
µoµu®ø®§
¥[¬°¦n¤Í
register313
·í«eÂ÷½u
³Â»¶ ¸ô¤H¥Ò
UID
2468
©«¤l
967
¥DÃD
0
ºëµØ
0
¿n¤À
1001
ª÷¿ú
1001
ÂI¦W
0
§@·~¨t²Î
WIN XP
³nÅ骩¥»
OFFICE 2003
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
739 ¤p®É
µù¥U®É¶¡
2010-11-29
³Ì«áµn¿ý
2022-5-17
¡@ÀY»Î:
³Â»¶ ¸ô¤H¥Ò
¤j¾Ç¥Í
©«¤l
967
¥DÃD
0
ºëµØ
0
¿n¤À
1001
ÂI¦W
0
§@·~¨t²Î
WIN XP
³nÅ骩¥»
OFFICE 2003
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-11-29
³Ì«áµn¿ý
2022-5-17
2
#
µoªí©ó 2012-4-2 18:35
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
tsally22
¨ú¯S©wÃöÁä¦r«eªº¼Æ¦r ¦p xx¸¹
E3=IF(ISNUMBER(--RIGHT(LEFT($A3,FIND(E$2,$A3)-1))),-LOOKUP(1,-RIGHT(LEFT($A3,FIND(E$2,$A3)-1),ROW($1:$5))),"")
¨ú¯S©wÃöÁä¦r«áªº¼Æ¦r ¦p ¤§xx
M3=IF(ISNUMBER(--RIGHT($A3,LEN($A3)-FIND(M$2,$A3))),--RIGHT($A3,LEN($A3)-FIND(M$2,$A3)),"")
¤U¸ü
(125.8 KB)
2012-4-2 18:35
TOP
tsally22
µoµu®ø®§
¥[¬°¦n¤Í
tsally22
·í«eÂ÷½u
UID
5775
©«¤l
5
¥DÃD
3
ºëµØ
0
¿n¤À
14
ª÷¿ú
14
ÂI¦W
0
§@·~¨t²Î
VISTA
³nÅ骩¥»
OFFICE 2007
¾\ŪÅv
10
¦b½u®É¶¡
2 ¤p®É
µù¥U®É¶¡
2011-7-28
³Ì«áµn¿ý
2015-4-30
¤p¾Ç¥Í
©«¤l
5
¥DÃD
3
ºëµØ
0
¿n¤À
14
ÂI¦W
0
§@·~¨t²Î
VISTA
³nÅ骩¥»
OFFICE 2007
¾\ŪÅv
10
µù¥U®É¶¡
2011-7-28
³Ì«áµn¿ý
2015-4-30
3
#
µoªí©ó 2012-4-5 17:39
|
¥u¬Ý¸Ó§@ªÌ
¤£¦n·N«ä~¦A½Ð°Ý¤@¤U
=IF(ISNUMBER(--RIGHT(LEFT($A3,FIND(E$2,$A3)-1))),-LOOKUP(1,-RIGHT(LEFT($A3,FIND(E$2,$A3)-1),ROW($1
5))),"")
¦n¹³¥u¦³¹ï©ó¼Æ¦r¦³¥Î¡A¨º¦pªG¬O°ê¦r©Î^¤å¦r¸Ó¦p¦óקï
EX: ¤T«¸ô19¤§6¸¹C´É10¼Ó
TOP
register313
µoµu®ø®§
¥[¬°¦n¤Í
register313
·í«eÂ÷½u
³Â»¶ ¸ô¤H¥Ò
UID
2468
©«¤l
967
¥DÃD
0
ºëµØ
0
¿n¤À
1001
ª÷¿ú
1001
ÂI¦W
0
§@·~¨t²Î
WIN XP
³nÅ骩¥»
OFFICE 2003
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
739 ¤p®É
µù¥U®É¶¡
2010-11-29
³Ì«áµn¿ý
2022-5-17
¡@ÀY»Î:
³Â»¶ ¸ô¤H¥Ò
¤j¾Ç¥Í
©«¤l
967
¥DÃD
0
ºëµØ
0
¿n¤À
1001
ÂI¦W
0
§@·~¨t²Î
WIN XP
³nÅ骩¥»
OFFICE 2003
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-11-29
³Ì«áµn¿ý
2022-5-17
4
#
µoªí©ó 2012-4-6 14:22
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ register313 ©ó 2012-4-6 23:38 ½s¿è
¦^´_
3#
tsally22
°Ñ¦Ò¥Î
¤U¸ü
(80.74 KB)
2012-4-6 14:22
VBA
Sub xx()
[B2:M65536] = ""
For Each R In Range([A2], [A2].End(xlDown))
T = 0
For RN = 1 To Len(R)
For Each C In Range([B1], [L1])
If Mid(R, RN, 1) = "¤§" Then
If IsNumeric(Split(R, "¤§")(1)) Then Range("M" & R.Row) = Split(R, "¤§")(1)
End If
If Mid(R, RN, 1) = C Then
X = Mid(R, T + 1, RN - T - 1)
C.Offset(R.Row - 1) = X
T = RN
End If
X = Split(R, [M1])
Next
Next RN
Next
End Sub
½Æ»s¥N½X
TOP
ÀR«ä¦Û¦b :
¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·