luhpro

¦^´_ 1# Qektyyrwp

¤U¸ü (36.2 KB)

2016-4-16 04:52

1. Sub nn()
   
2. Dim lRow&
   
3. Dim vD, vTemp
   
4. 
   
5. Set vD = CreateObject("Scripting.Dictionary")
   
6. 
   
7. lRow = 2
   
8. While Cells(lRow, 1) <> ""
   
9.    If Left(Cells(lRow, 3), 4) <> "nona" Then ' ¥i¥Î¤~¥[¤J
   
10.      If vD.exists(CStr(Cells(lRow, 1))) Then
    
11.        If vD(CStr(Cells(lRow, 1))) = "" Then
    
12.          vD(CStr(Cells(lRow, 1))) = Cells(lRow, 2)
    
13.        Else
    
14.          vD(CStr(Cells(lRow, 1))) = vD(CStr(Cells(lRow, 1))) & "," & Cells(lRow, 2)
    
15.        End If
    
16.      Else
    
17.        vD(CStr(Cells(lRow, 1))) = Cells(lRow, 2)
    
18.      End If
    
19.    Else
    
20.      vD(CStr(Cells(lRow, 1))) = ""
    
21.    End If
    
22.    lRow = lRow + 1
    
23. Wend
    
24. 
    
25. [A16:B50].Clear
    
26. lRow = 16
    
27. For Each vTemp In vD
    
28.    Cells(lRow, 1) = vTemp
    
29.    If vD(vTemp) <> "" Then
    
30.      Cells(lRow, 2) = vD(vTemp)
    
31.    Else
    
32.      Cells(lRow, 2) = "µL"
    
33.    End If
    
34.    lRow = lRow + 1
    
35. Next
    
36. End Sub

½Æ»s¥N½X

¼gµ{¦¡±a¥X¥i¥Î¾÷¥x-a.zip (13.92 KB)

¤U¸ü¦¸¼Æ: 2

2016-4-16 04:53