|
Dim xx As Integer
For xx = 2 To 1365
If Cells(xx - 1, "a") = Cells(xx, "a") And Cells(xx, "a") <> Cells(xx + 1, "a") Then
Cells(xx - 1, "i") = 1
Else: End If
If Cells(xx - 1, "a") <> Cells(xx, "a") And Cells(xx, "a") = Cells(xx + 1, "a") And Cells(xx, "a") = Cells(xx + 2, "a") Then
Cells(xx, "i") = 1
Else: End If
Next xx
End Sub
附件中,我想取同一卡号的最小值,我已经按附件按卡号和金额按升序排序,这样,我只要找到第一个卡号并做标记就可以了。卡号都为重复,我想取第一个卡号的剩余金额。例如卡号1,有两个,我只想取第一个卡号1的剩余金额,我就在I2标注1,以此类推,我想取卡号为2的第一个卡号的剩余金额,我就在在I4标注1,这样用筛选的功能就可以把所有第一个卡号的剩余金额筛选出来了。但是我用vba做标注的时候,就出现了I5也标注1的问题。
|
|