- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2024-10-30
|
¦^´_ 32# BV7BW
½Ð¦b¸Õ¬Ý¬Ý¡AÁÂÁ¡C
Sub ´_¾ã2()
Dim Arr
With Sheets("¤u§@ªí3")
With .Range(.[k1], .[a65536].End(3))
Arr = .Value '¸ê®Æ¸Ë¤JArr
For i = 2 To UBound(Arr)
If Arr(i, 2) = "" Then GoTo 99 'ªÅ¥Õ´N´«¤U¤@Ó
If InStr(Arr(i, 2), "S") Then '½s¸¹¦³ S
Arr(i, 11) = Int(Mid(Arr(i, 2), 4, 3)) & "s" '½s¸¹S¡A¨ú-¥H«á3½X¾ã¼Æ+S¡A¼ÆȸˤJArr(i,11)
Else
Arr(i, 11) = Int(Right(Arr(i, 2), 3)) '°£¤F½s¸¹S¥H¥~¡A¨ú³Ì«á3½Xªº¾ã¼Æ¡A¼ÆȸˤJArr(i,11)
End If
99: Next
.Value = Arr 'ArrȶK¦^excel
.Sort Key1:=.Item(6), Order1:=1, _
Key2:=.Item(11), Order1:=1, Header:=1 '¥HF¡BKÄæ±Æ§Ç
End With
.Range("k1:k" & UBound(Arr)) = "" '²M°£KÄæ¼ÆÈ
End With
End Sub |
|