|
本帖最后由 laoau138 于 2017-6-13 22:47 编辑
VBA比较A列唯一值 另一种方法还没有写完
Sub 比较A列唯一值()
Dim arr, i&, j&
arr = [a1].CurrentRegion
ReDim brr(1 To UBound(arr), 1 To 1)
For i = 1 To UBound(arr) - 1
For j = i + 1 To UBound(arr)
If arr(i, 1) = arr(j, 1) Then arr(j, 1) = "@"
Next
Next
'比较A列唯一值 D列保存答案 还没有写完
'假如arr 某一行不等于"@" 自动存入数组brr 请高手指导如何继续
End Sub
本帖最后由 chart888 于 2017-6-13 19:54 编辑
- Private Sub CommandButton1_Click()
- Dim i&, Myr&, Arr
- Dim d, k
- Set d = CreateObject("Scripting.Dictionary")
- Myr = [A65536].End(xlUp).Row
- Arr = Range("a1:a" & Myr)
- For i = 1 To UBound(Arr)
- d(Arr(i, 1)) = ""
- Next
- k = d.Keys
- [D1].Resize(d.Count, 1) = Application.Transpose(k)
- Set d = Nothing
- End Sub
复制代码
|
|