|
数据的查错与替换
- Sub ek_sky()
- Dim arr, arb, i&, d As Object
- Set d = CreateObject("scripting.dictionary")
- arr = Range("A2:B" & Cells(Rows.Count, 1).End(xlUp).Row).Value
- ReDim arb(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = d(arr(i, 1)) + 1
- Next i
- For i = 1 To UBound(arr)
- arb(i, 1) = arr(i, 1)
- arb(i, 2) = WorksheetFunction.Text(d(arr(i, 1)), "[>2][dbnum1]0\通;")
- Next i
- Range("C2:C60000").ClearContents
- Range("C2").Resize(UBound(arr), 2) = arb
- For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
- If Cells(i, 2) <> Cells(i, 4) Then
- Range("B" & i).Interior.ColorIndex = 6
- Range("C" & i).Resize(1, 2).Font.ColorIndex = 5
- Else
- Range("B" & i).Interior.ColorIndex = xlNone
- Range("C" & i).Resize(1, 2).Font.ColorIndex = 0
- End If
- Next i
- End Sub
复制代码
数据的查错与替换.zip
(17.68 KB, 下载次数: 11)
|
|