|
请各位大师帮下我, 问题是: 如果A列等于锌锭,且B列不等于空,则在F列中填充不B列中的不重复项
- Sub 锌锭填充()
- Set d = CreateObject("scripting.dictionary")
- Arr = [a1].CurrentRegion
- For i = 2 To UBound(Arr)
- x = Arr(i, 2)
- If Arr(i, 1) = "锌锭" And x <> "" Then d(x) = ""
- Next
- [f:f].ClearContents
- If d.Count > 1 Then [f2].Resize(d.Count, 1) = Application.Transpose(d.keys) '去重的B列
- End Sub
复制代码
|
|