Private Sub CommandButton1_Click()
Dim a1(2 To 10000)
Dim a2(2 To 10000)
Dim a3(2 To 10000)
arr = Sheets("Sheet1").Range("A1:c" & Sheets("Sheet1").Range("A65536").End(3).Row)
不同 = 0
同 = 0
For i = 2 To UBound(arr)
a1(i) = arr(i, 1)
a2(i) = arr(i, 2)
a3(i) = arr(i, 3)
If a1(i) <> a2(i) And a1(i) <> a3(i) And a2(i) <> a3(i) Then
不同 = 不同 + 1
Else
同 = 同 + 1
End If
Next
Sheets("Sheet1").Range("h13") = 不同
Sheets("Sheet1").Range("h16") = 同
End Sub