|
b28-chuanqi3
Sub 一()
Dim arr, i As Integer, s
arr = Range("a1:a" & Cells(Rows.Count, 1).End(3).Row)
ReDim brr(1 To UBound(arr), 1 To 3)
For i = 1 To UBound(arr)
s = Split(arr(i, 1), "*")
brr(i, 1) = "'" & s(0)
brr(i, 2) = "'" & s(1)
brr(i, 3) = "'" & s(2)
Next
Range("b1").Resize(UBound(brr), 3) = brr
End Sub
Sub 二()
Dim arr, i As Integer, j As Integer, m As Integer, n As Integer
arr = Range("b2:f12")
For m = 1 To 10
For i = 1 To UBound(arr)
For j = 1 To UBound(arr, 2)
If arr(i, j) / 100 < m And arr(i, j) / 100 >= m - 1 Then
n = n + 1
End If
Next
Next
If m > 5 Then
Cells(m - 2, 11) = n
Else
Cells(m + 3, 9) = n
End If
n = 0
Next
End Sub
Sub 三()
Dim arr, i%, s, j%, k%, n%, v%, mysum!, myave!
arr = Range("b3:f13")
ReDim brr(1 To UBound(arr), 1 To 4)
For i = 1 To UBound(arr)
For j = 1 To UBound(arr, 2)
For k = 1 To UBound(arr, 2)
If arr(i, j) > arr(i, k) Then
s = arr(i, j)
arr(i, j) = arr(i, k)
arr(i, k) = s
End If
Next
Next
brr(i, 1) = arr(i, 1)
brr(i, 2) = arr(i, 5)
Next
For n = 1 To UBound(arr)
For v = 1 To UBound(arr, 2)
mysum = mysum + arr(n, v)
Next
myave = mysum / 5
brr(n, 4) = mysum
brr(n, 3) = myave
mysum = 0
Next
Range("j3").Resize(UBound(brr), 4) = brr
End Sub
|
评分
-
查看全部评分
|