§Ö³t¤ñ¹ï¯x°}¤ºªº¸ê®Æ¤j¤p!!
- ©«¤l
- 41
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 79
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-4-1
- ³Ì«áµn¿ý
- 2016-2-17
|
¦^´_ 1# yenwang
¦pªG¥un§ä¨ä¤¤¤@ӳ̤jÈ¡A¤@Ó°j°é¥[¤ñ¤j¤p´N¥i¥H¤F
°Ñ¦Ò¬Ý¬Ý!- Sub °}¦C§ì³Ì¤jÈ()
- Dim Arr, ViewMax
- Arr = Range("a1:b7") '¤Þ¤J§Aªº°}¦C
- With CreateObject("Scripting.Dictionary")
- For i = 1 To UBound(Arr)
- If .Exists(Arr(i, 1)) Then
- If .Item(Arr(i, 1)) < Arr(i, 2) Then .Item(Arr(i, 1)) = Arr(i, 2)
- Else
- .Add Arr(i, 1), Arr(i, 2)
- End If
- Next i
- For Each ViewMax In .Keys
- Debug.Print ViewMax, .Item(ViewMax)
- Next
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|