Sub QL()
With ActiveSheet
W = .Range("B65536").End(3).Row '尾行
C = (.Range("BY2").End(2).Column - 76) / 12 '组数
For I = W - 1 To W
For j = C To 1 Step -1 '组
n = 0
For K = 1 To 12 '列
For M = 2 To 7 '对比列
If .Cells(I, M) = .Cells(I, j * 12 + K + 64) Then n = n + 1
Next: Next
If n > 1 Then .Cells(I, j * 12 + 65).Resize(1, 12).EntireColumn.Delete '删除列
Next: Next
End With
End Sub