- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2024-10-30
|
¦^´_ 1# peter95
Sub test()
Dim Arr, i&, T$, T1$, T2$, k%, Brr(1 To 10000, 1 To 10)
Arr = Range([sheet1!L2], [sheet1!C65536].End(xlUp))
For i = 2 To UBound(Arr)
T = Arr(i, 5): T1 = Arr(i, 6): T2 = Arr(i, 7)
If Arr(i, 5) = "" Then GoTo 100
If T > T1 And T1 > T2 Then
k = k + 1
Brr(k, 1) = Arr(i, 1): Brr(k, 2) = Arr(i, 2)
Brr(k, 3) = Arr(i, 3): Brr(k, 4) = Arr(i, 4)
Brr(k, 5) = Arr(i, 5): Brr(k, 6) = Arr(i, 6)
Brr(k, 7) = Arr(i, 7): Brr(k, 8) = Arr(i, 8)
Brr(k, 9) = Arr(i, 9): Brr(k, 10) = Arr(i, 10)
End If
100: Next
[¤u§@ªí1!A1:J1] = Array("½s¸¹", "²£«~", "Ãþ§O", "D", "1", "2", "3", "4", "5", "6")
[¤u§@ªí1!A2].Resize(k, 10) = Brr
End Sub |
|