数字比较多的话
Sub ss()
Set r = Range("A1:B10") '输入具体范围
Dim j As Integer
j = 1
For n = 1 To r.Rows.Count
If r.Cells(n, 1) = r.Cells(n, 2) Then
Range(r.Cells(n, 1), r.Cells(n, 2)).Copy Range(Cells(j, 3), Cells(j, 4)) '这一行表示把相同数字的A和B列考到C和D列中
j = j + 1
End If
Next n
For n = 1 To r.Rows.Count
If Not r.Cells(n, 1) = r.Cells(n, 2) Then
Range(r.Cells(n, 1), r.Cells(n, 2)).Copy Range(Cells(j, 3), Cells(j, 4))
j = j + 1
End If
Next n
End Sub