[µo°Ý] ²³æ²Õ¦X°ÝÃD¡C

stephenlee

ªþ¥óªí,¦p¦ó¥Î FÄæ"Line"¤ÎQÄæ"CTN" ¨Ó¦Û°Ê¤ÀÃþ¥X¬O¥Ñ¨º­ÓLine ²Õ¦X¦¨, XÄæ "line group" ¬O±o¥XXÄ檺µ²ªG,
¦p¦ó°µ¹³XÄ樺¼Ëªºµ²ªG, X Äæ¬O§Ú­n¨D±o¥Xªºµ²ªG,FÄæ Line ¸ê®Æ¦³¦h¦³¤Ö, ­n®Ú¾ÚQÄæ¨Ó¤ÀLine ¬O¥Ñ¦h¤Ö²Õ¦¨¡C
ÁÂÁÂ

²Õ¦X.zip (7.33 KB)

¤U¸ü¦¸¼Æ: 10

2021-6-2 11:42

stephenlee

¦^´_  stephenlee

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test()
Dim Arr, a, a1
Arr = Range("A2:A" & [A65536] ...
samwang µoªí©ó 2021-6-5 12:25

  ³o­Ó¤]¬O§¹¥þ²Å¦X­n¨D,§¹¬ü¸Ñ¨M¤F§Ú©Ò»Ýªº°ÝÃD¡C «D±`·P¿E¤j¤j¤@ª½À°¦£,À°§Ú¸`¬Ù¤F³B²z¸ê®Æªº®É¶¡,¤Q¤À·PÁ¡C

ÃD¥~¸Ü:  ¤j¤j¯uªº«Ü±j¡C

samwang

¦^´_ 10# stephenlee

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test()
Dim Arr, a, a1
Arr = Range("A2:A" & [A65536].End(3).Row)
For i = 1 To UBound(Arr)
    a = Split(Arr(i, 1), "-")(0)
    a1 = Split(Arr(i, 1), "-")(1)
    If a = a1 Then Arr(i, 1) = a
Next
Range("B2").Resize(UBound(Arr)).NumberFormatLocal = "@"
Range("B2").Resize(UBound(Arr)) = Arr
End Sub

stephenlee

¦^´_  stephenlee

½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test3()
Dim Arr, xD, i%, i2&, N%
Arr = Range([F1] ...
samwang µoªí©ó 2021-6-4 18:04

    ¥H¤W«ü¥O§¹¥þ²Å¦X­n¨D,¤Ó·PÁ¤j¤jÀ°¤F§Ú³o»ò¦h¦£,¤£¦n·N«ä­n§Aªá®É¶¡À°§Ú¬ã¨s¡C«D±`·PÁ¡C  ¦b¦¹ÁÂÁ¤F¡C

¤£ª¾¹D¯à¤£¯àÀ°§Ú³Ì«á¤@­Ó°ÝÃD,³o­Ó²³æ¤@ÂI¡C

Àɮפº A Äæ¬O¸ê®Æ, BÄæ¬O ¹Bºâµ²ªG¡C

­n¨D¬O ·í AÄæÀx¦s®æ ¦b -  «e©M«á¬O¤@¼Ëªº¸Ü, ¥u«O¯d ²Ä¤@­Ó - «eªº¼Æ¦r

¦pªG¤£¤@¼Ë,¨º´N¤£¥ÎÅÜ¡C AÄ檺¸ê®Æ¦³¦h¦³¤Ö¡C

AÄ欰 ¸ê®Æ,B Ä欰­n¨D¿é¥X«áªºµ²ªG,¸÷Á¤F¡C

©â¼Æ¦r.zip (6.79 KB)

¤U¸ü¦¸¼Æ: 2

2021-6-5 11:49

samwang

¦^´_ 8# stephenlee

½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test3()
Dim Arr, xD, i%, i2&, N%
Arr = Range([F1], [Q65536].End(3))
Set xD = CreateObject("Scripting.Dictionary")
For i = 2 To UBound(Arr)
    If Not xD.Exists(Arr(i, 12) & "") Then
        xD(Arr(i, 12) & "") = i
        For i2 = i To UBound(Arr)
           If Not xD.Exists(Arr(i2, 12) & "") Then Exit For
        Next
        Cells(i, 24) = Arr(i, 1) & "~" & Arr(i2 - 1, 1)
    End If
Next
End Sub

stephenlee

¦^´_  stephenlee

¤£¦n·N«ä¨Sª`·N¨ì¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test2()
Dim Arr, xD, i%, i2&, N% ...
samwang µoªí©ó 2021-6-3 15:56

    ³Â·Ð§A¤~¹ï,¥Î³Ì·s«ü¥Ü,µoı 1/8 ·|¥X²{µ²ªG,¦ý 2/8 ´N¨S¦³¥ô¦ó¸ê®Æ,  ·|¹j¤@­Ó¤~¥X²{µ²ªG,­n¦A³Â·Ð§A¬Ý¬Ý¡CÁÂÁÂ

samwang

¦^´_ 6# stephenlee

¤£¦n·N«ä¨Sª`·N¨ì¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test2()
Dim Arr, xD, i%, i2&, N%
Arr = Range([F1], [Q65536].End(3))
Set xD = CreateObject("Scripting.Dictionary")
For i = 2 To UBound(Arr)
    If Not xD.Exists(Arr(i, 12) & "") Then
        xD(Arr(i, 12) & "") = i
        For i2 = i To UBound(Arr)
            N = xD(Arr(i2, 12) & ""): If N = 0 Then Exit For
        Next
        Cells(i, 24) = Arr(i, 1) & "~" & Arr(i2 - 1, 1)
    End If
Next
End Sub

stephenlee

¦^´_  stephenlee

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test()
Dim Arr, xD, i%, i2&, N%
Arr = Range([F1], [ ...
samwang µoªí©ó 2021-6-2 16:08

«D±`·PÁ¤j¤j,¤S¬O»Õ¤U¦A¦¸À°¦£¡C
¤£¹L¦³¤@­Ó³¡¥÷ÁÙ®t¤@ÂI,±æ»Õ¤U¬Ý¬O§_¯àÀ°¦£¸Ñ¨M¡C
·PÁ§Aªá¤F¤Ó¦h®É¶¡À°§Ú¬ã¨s³o­Ó¡C

¨Ï¥Î¤FVBA «ü¥Ü«á,¨Ò¦p CTN  5/8  ¥¿½Tªº²Õ¦XÀ³¸Ó¬O 5-15, ¦ýÅã¥Ü¤F 5-11 ¡C²Ä 8/8 ¤]¬O ¥¿½TÀ³¸Ó¬O5-15 ¡C ¦ý¤]Åã¥Ü 5-11

¯à¤£¯à°µ¨ì®Ú¾ÚFÄæ©MQÄæ ªº¸ê®Æ¦h¤Ö¨Ó°µ¥X²Õ¦X±Æ¦C, ´N¬OFÄæ©MQÄæ³£¬O¦³¾÷·|¦h©M¤Ö,­n®Ú¾Ú±¡ªp±Æ¦C,°µªk¬O¤@¼Ëªº,ÁÂÁ¤F¡C

samwang

¦^´_ 3# stephenlee

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test()
Dim Arr, xD, i%, i2&, N%
Arr = Range([F1], [Q65536].End(3))
Set xD = CreateObject("Scripting.Dictionary")
For i = 2 To UBound(Arr)
    If Not xD.Exists(Arr(i, 12) & "") Then
        xD(Arr(i, 12) & "") = ""
        For i2 = i To UBound(Arr)
            If xD.Exists(Arr(i2, 12) & "") Then N = N + 1
        Next
        Cells(i, 24) = Arr(i, 1) & "~" & N: N = 0
    End If
Next
End Sub

hcm19522

https://blog.xuite.net/hcm19522/twblog/589806162