|
本帖最后由 albertbake654 于 2019-12-9 14:37 编辑
准备自己想出来,但是想了一天也没搞好。求助大家!谢谢!我想统计A列数据的重合情况,当B2大于等于4的时候,A2向下比对三行(A3,A4,A5)如果A2与A3数字相同,则C3单元格写入”重合“,如果A2与A4数字相同,则C4单元格写入”重合“,如果A2与A5数字相同,则C5单元格写入“”重合“”;当B2等于3的时候,A2向下比对两行(A3,A4),如果A2与A3数字相同,则C3单元格写入”重合“,如果A2与A4数字相同,则C4单元格写入”重合“;当B2等于2时,A2向下比较一行(A3)相同的话则在C3写入“”重合‘’,当B2等于1时C2是什么就是什么。依次向下统计A列数据的重合情况。但是还有一个问题,假设C3是’”重合",则统计A3的时候直接跳过,统计A4与A列后面数据的重合情况。想不出来!求解答!谢谢!
Sub 统计重合()
Dim i%, t%
i = 2
Do While Cells(i, "B") <> ""
Select Case Cells(i, "B")
Case Is >= 4
For t = 1 To 3
If Cells(i, "A") = Cells(i + t, "A") Then
Cells(i + t, "C").Value = "重合"
Else
Cells(i + t, "C").Value = ""
End If
Next
Case Is = 3
For t = 1 To 2
If Cells(i, "A") = Cells(i + t, "A") Then
Cells(i + t, "C").Value = "重合"
Else
Cells(i + t, "C").Value = ""
End If
Next
Case Is = 2
If Cells(i, "A") = Cells(i + 1, "A") Then
Cells(i + 1, "C").Value = "重合"
Else
Cells(i + 1, "C").Value = ""
End If
Case Is = 1
Cells(i, "C").Value = Cells(i, "C")
End Select
i = i + 1
Loop
End Sub
|
|