code:Public Sub 开奖后统计跟随_杨()
last = Sheet16.Range("A" & Rows.Count).End(xlUp).Row
Dim ar(1089, 33) As Integer
Erase ar
For i = 5 To last - 612
For i1 = 0 To 5: j1 = Sheet16.Cells(i - 2, 10 + i1)
For i2 = 0 To 0: j2 = Sheet16.Cells(i - 1, 10 + i1)
For i3 = 0 To 5: j3 = Sheet16.Cells(i - 0, 10 + i3)
xx = j1 * 33 + j2 - 34
Yy = j3 - 1
ar(xx, Yy) = ar(xx, Yy) + 1
Next: Next: Next
Next
For i = 0 To 1088
For j = 0 To 32
Sheet16.Cells(3 + i, 31 + j) = ar(1088 - i, 32 - j)
Next
Next
End Sub