- Sub qc2()
- Dim i As Long, j As Long, a, e, t, k As Long, arr
- Columns("k:l").ClearContents
- arr = Range("a1:a" & Range("a" & Rows.Count).End(3).Row)
- ReDim arr1(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- If InStr(arr(i, 1), ".edf") > 0 Then
- a = Split(arr(i, 1), Chr(34))
- j = j + 1
- For Each e In a
- If InStr(e, ".edf") > 0 Then
- arr1(j, 2) = e
- End If
- Next
- arr1(j, 1) = arr(i, 1)
- End If
- Next
- Range("k1").Resize(UBound(arr1), 2) = arr1
- Columns("l:l").Select
- Range("K:L").RemoveDuplicates Columns:=2, Header:=xlNo
- End Sub
复制代码
k m列数据 自己调整位置。 |