- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
¦^´_ 10# ã´£³¡ªL
¥Ø«e§ï¬°³o¼Ë¥i¹F¦¨®ÄªG,¤£ª¾¬O§_¦³¤£§´ªº¦a¤è
Sub ¼ÐÅÒ()
Dim xArea As Range, xR As Range, xU As Range, xD, T$, i&
For i = 1 To 28 Step 9
Set xD = CreateObject("Scripting.Dictionary")
Set xArea = Range(Cells(2, i), Cells(Rows.Count, i).End(xlUp)(1, 8))
For Each xR In xArea
T = xR(1, 5) & xR(1, 6): xD(T) = xD(T) + 1
Next
Set xU = Cells(xArea.Rows.Count + 2, 1)
For Each xR In xArea
T = xR(1, 5) & xR(1, 6)
If xD(T) >= 20 And xR(1, 8) = "." Then Set xU = Union(xU, xR.Resize(1, 9))
Next
If xU.Count > 1 Then xU.Delete Shift:=xlUp
Next i
End Sub |
|