[µo°Ý]±N¨â°}¦C¨Ì¶¶§Ç¦X¨Ö°ÝÃD
- ©«¤l
- 135
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 165
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-12-9
- ³Ì«áµn¿ý
- 2012-8-27
|
¦^´_ 1# asus103 - Sub merge_rank()
- Dim myobject As Object
- Dim myrange As Range
- Dim i As Integer
- Set myobject = CreateObject("scripting.dictionary")
- For i = 1 To 2
- With Worksheets("sheet" & i)
- For Each myrange In .Range(.[a1], .[a1].End(xlToRight))
- myobject(myrange.Value) = myrange.Offset(1).Value
- Next
- End With
- Next
- With Sheet3
- For i = 1 To myobject.Count
- .Cells(1, i).Value = Application.Small(myobject.keys, i)
- .Cells(2, i).Value = myobject.Item(Application.Small(myobject.keys, i))
- Next
- End With
- Set myobject = Nothing
- End Sub
½Æ»s¥N½X |
|
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 135
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 165
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-12-9
- ³Ì«áµn¿ý
- 2012-8-27
|
|
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 135
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 165
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-12-9
- ³Ì«áµn¿ý
- 2012-8-27
|
¦^´_ 14# Hsieh - Sub merge_rank()
- Dim myobject As Object, myobject2 As Object
- Dim myrange As Range
- Dim i As Integer, j As Integer
- Set myobject = CreateObject("scripting.dictionary")
- Set myobject2 = CreateObject("scripting.dictionary")
- With Sheet4
- For Each myrange In .Range(.[a1], .[a1].End(xlToRight))
- myobject(myrange.Value) = myobject(myrange.Value) + 1 'myrange.value¬°²Ä1 row¬Y¼Æ¦r,myobject§@¬°p¼Æ¾¹
- myobject2(myrange.Value & "," & myobject(myrange.Value)) = myrange.Offset(1).Value myobject2¿é¤J²Ä2 rowªº¼Æ¦r(index¬°myrange.Value & "," & myobject(myrange.Value,§Y¼Æ¦r¤Î¨ä¥X²{¦¸¼Æ)
- Next
- End With
- With Sheet5
- .Activate
- .Range("a1").Activate
- For i = 1 To myobject.Count '¥ý¼Æ¦³¦h¤Öµ§¤£¦Pªº¸ê®Æ
- For j = 1 To myobject(Application.Small(myobject.keys, i)) '¥ý±Æ¦C,¦A§ä¥X¨ä¥X²{¦¸¼Æ
- ActiveCell.Value = Application.Small(myobject.keys, i)
- ActiveCell.Offset(1, 0).Value = myobject2(Application.Small(myobject.keys, i) & "," & j)
- ActiveCell.Offset(0, 1).Select
- Next
- Next
- End With
- Set myobject = Nothing
- Set myobject2 = Nothing
- End Sub
½Æ»s¥N½X |
|
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 135
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 165
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-12-9
- ³Ì«áµn¿ý
- 2012-8-27
|
¥»©«³Ì«á¥Ñ FAlonso ©ó 2011-1-15 14:13 ½s¿è
¬Ý²Ä20¶,¨ºÓ¬O³Ì²×µ{¦¡ |
|
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 135
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 165
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-12-9
- ³Ì«áµn¿ý
- 2012-8-27
|
- Sub merge_rank2()
- Dim myobject As Object, myobject2 As Object
- Dim myrange As Range
- Dim i As Integer, j As Integer, k As Integer, myrow As Integer
- Dim mykey
- Set myobject = CreateObject("scripting.dictionary")
- Set myobject2 = CreateObject("scripting.dictionary")
- myrow = Sheet4.Range("A65536").End(xlUp).Row
- With Sheet4
- For Each myrange In .Range(.[a1], .[a1].End(xlToRight))
- myobject(myrange.Value) = myobject(myrange.Value) + 1
- For j = 2 To myrow
- myobject2(myrange.Value & "," & myobject(myrange.Value) & "," & j) = myrange.Offset(j - 1).Value
- Next
- Next
- End With
- With Sheet5
- .Activate
- .Range("a1").Activate
- For i = 1 To myobject.Count
- For j = 1 To myobject(Application.Small(myobject.keys, i))
- ActiveCell.Value = Application.Small(myobject.keys, i)
- For k = 2 To myrow
- ActiveCell.Offset(k - 1, 0).Value = myobject2(Application.Small(myobject.keys, i) & "," & j & "," & k)
- Next
- ActiveCell.Offset(0, 1).Select
- Next
- Next
- End With
- Set myobject = Nothing
- Set myobject2 = Nothing
- End Sub
½Æ»s¥N½X ³oÓ¬OÀu¤Æµ{¦¡,²Ä¤@¦æ«ÂФ]¥i¨Ï¥Î
§Ú¨ì¦¹¬°¤î¤F..... |
|
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|