|
Sub pl()
arr = ThisWorkbook.Sheets("Sheet1").Range("C2:H2")
arr2 = sz(arr)
For p = 2 To ThisWorkbook.Sheets("Sheet1").Cells(1, 11).End(xlDown).Row
brr = ThisWorkbook.Sheets("Sheet1").Range("K" & p & ":P" & p)
brr2 = sz(brr)
For i = 1 To 90
For j = 1 To 90
If arr2(i, 1) = brr2(j, 1) And arr2(i, 2) = brr2(j, 2) Then
ThisWorkbook.Sheets("Sheet1").Range("K" & p & ":P" & p).Interior.Color = RGB(255, 0, 0)
ThisWorkbook.Sheets("Sheet1").Range("Q" & p) = arr2(i, 3)
ThisWorkbook.Sheets("Sheet1").Range("R" & p) = brr2(j, 3)
Exit For
End If
Next
Next
Next
MsgBox "判断完毕!"
End Sub
Function sz(arr) As Variant
Dim qzrr(1 To 90, 1 To 3)
n = 1
'6选2,剩余4中再选2
For i = 1 To 5
For j = i + 1 To 6
ss = arr(1, i) & "|" & arr(1, j)
qz1 = arr(1, i) + arr(1, j)
'取剩余4个
For k = 1 To 6
If k <> i And k <> j Then
pp = pp & "|" & arr(1, k)
End If
Next
brr = Split(pp, "|")
'剩余4个里面选2个
For p1 = 1 To 3
For p2 = p1 + 1 To 4
ppp = brr(p1) & "|" & brr(p2)
qz2 = CInt(brr(p1)) + CInt(brr(p2))
qzrr(n, 1) = qz1
qzrr(n, 2) = qz2
qzrr(n, 3) = ss & "|" & ppp
n = n + 1
pp = ""
ppp = ""
Next
Next
Next
Next
sz = qzrr
End Function |
评分
-
1
查看全部评分
-
|