这个问题需要使用VBA编程来完成。以下是代码:
Sub CompareAndMove()
Dim CompareRow As Integer
Dim CurrentRow As Integer
Dim DuplicateCount As Integer
Dim DuplicateString As String
For CompareRow = 4 To 21 Step 2
For CurrentRow = CompareRow + 1 To CompareRow + 2
DuplicateCount = 0
DuplicateString = ""
For i = 1 To 15
If Cells(CompareRow, i) = Cells(CurrentRow, i) Then
DuplicateCount = DuplicateCount + 1
DuplicateString = DuplicateString & Cells(CompareRow, i) & ", "
End If
Next i
If DuplicateCount > 0 Then
Range("Q" & CurrentRow - 3 & ":Z" & CurrentRow - 3).Value = DuplicateString
End If
Next CurrentRow
Next CompareRow
'Check for overall duplicates
For i = 4 To 21 Step 4
DuplicateCount = 0
DuplicateString = ""
For j = 1 To 15
If Cells(i, j) = Cells(i + 1, j) Or Cells(i, j) = Cells(i + 2, j) Or Cells(i, j) = Cells(i + 3, j) Then
DuplicateCount = DuplicateCount + 1
DuplicateString = DuplicateString & Cells(i, j) & ", "
End If
Next j
If DuplicateCount > 0 Then
Range("A22").Offset(0, i - 4).Value = DuplicateString
End If
Next i
End Sub
这个程序将在第21行中显示重复项。请注意,此程序假定输入始终是20行,其中每4行有一个重复项,并且数据是从A1开始的。如果将来的数据具有不同的格式,请相应地修改代码
追问运行不了