ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¤j¶q¸ê®Æ­pºâ

¤j¶q¸ê®Æ­pºâ

¥»©«³Ì«á¥Ñ oak0723-1 ©ó 2021-10-5 18:41 ½s¿è

¤j¶q¼Æ¤Q¸U¦C¸ê®Æ­pºâ
Àɮ׶}ÃöºC¥Î¨ç¼Æ³B²z¤S©ö·í¾÷
³Â·Ð¥ý¶i¯à¨ó§U
¥t¥~½Ð°Ý¦³¸û²Ê²Lªºvba°}¦C¬ÛÃö¤å³¹¥i¥H¾Ç²ß¶Ü
ÁÙ¦³
§Ú³o­Óªþ¥ó¬°¦ó·|¨º»ò¤j?¦p¦óÁY¤p
Image 1.jpg

1101005-¤ñ¹ï&¦X­p.part001.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part002.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part003.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part004.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part005.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part006.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part007.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part008.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part009.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part010.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part011.rar (1 MB)

1101005-¤ñ¹ï&¦X­p.part012.rar (443.31 KB)

¦^´_ 16# oak0723-1


  ¥Ø«e´ú¸Õ°õ¦æµo¥Í"°}¦C¯Á¤Þ¶W¥X½d³ò"ªº°ÝÃD
>> ¦]¬°¸ê®Æ®w»P¤ñ¹ïªºÄæ¦ì¤£¤@­P¾É­P°ÝÃD¡A¤w§ó·s·s¼W1¦C¦p¤U¬õ¦r¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

...
...
With Sheets("¤ñ¹ï")
    .[b6].Resize(UBound(Arr)) = Arr
    ReDim Brr(1 To UBound(Arr), 1 To UBound(Drr, 2))
    ReDim Crr(1 To UBound(Arr), 1 To 1)
    C1 = .Cells(3, Columns.Count).End(1).Column
    If C1 > C Then C = C Else C = C1
    Arr = .Range(.[i3], .Cells(4, C))
    For i = 1 To UBound(Drr)
...
...

TOP

¦^´_ 15# samwang


    §A¦n
·PÁ§AÄ@¼ö¤ßÀ°¦£
¥Ø«e´ú¸Õ°õ¦æµo¥Í"°}¦C¯Á¤Þ¶W¥X½d³ò"ªº°ÝÃD
Image 6.jpg

1101005-¤ñ¹ï&¦X­p02-1-1.rar (147.84 KB)

TOP

¦^´_ 14# oak0723-1

§Ú¼W¥[¸ê®Æ¦C¼Æ©MÄæ¼Æ
µo²{¤£¯àÀH¼W´î¸ê®Æ¼ÆÅܰʤñ¹ïµ²ªG
>> ¤w§ó·s¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
   
Sub test()
Dim Arr, Drr, Brr(), Crr(), T, XMax, XMin, R%, C%
Tm = Timer
With Sheets("¸ê®Æ®w")
    R = .[b6].End(4).Row
    C = .Cells(5, Columns.Count).End(1).Column
    Arr = .Range(.[b6], .Cells(R, 2))
    Drr = .Range(.[i6], .Cells(R, C))
End With

With Sheets("¤ñ¹ï")
    .[b6].Resize(UBound(Arr)) = Arr
    ReDim Brr(1 To UBound(Arr), 1 To UBound(Drr, 2))
    ReDim Crr(1 To UBound(Arr), 1 To 1)
    C = .Cells(3, Columns.Count).End(1).Column
    Arr = .Range(.[i3], .Cells(4, C))

    For i = 1 To UBound(Drr)
        Crr(i, 1) = 0
        For j = 1 To UBound(Arr, 2)
            T = Drr(i, j): XMin = Arr(1, j): XMax = Arr(2, j)
            If XMin = "" Or T = "" Then Brr(i, j) = "": GoTo 99
            If T < XMin Or T > XMax Then
                Brr(i, j) = 0
            Else
                 Brr(i, j) = 1: Crr(i, 1) = Crr(i, 1) + 1
            End If
99:     Next j
    Next i
    .Range("h6").Resize(UBound(Crr)) = Crr
    .Range("i6").Resize(UBound(Brr), UBound(Brr, 2)) = Brr
End With
MsgBox Timer - Tm
End Sub

TOP

¦^´_ 13# samwang
§A¦n
´ú¸Õ¤@¤Uµo²{¦³¨Ç°ÝÃD
§Ú¼W¥[¸ê®Æ¦C¼Æ©MÄæ¼Æ
µo²{¤£¯àÀH¼W´î¸ê®Æ¼ÆÅܰʤñ¹ïµ²ªG
¦pªþ¥ó»¡©ú
Image 143-1.jpg

1101005-¤ñ¹ï&¦X­p02-1.rar (119.05 KB)

TOP

¦^´_ 10# oak0723-1

¼Æ­È­Y¦b©ó¤W¤U­­¬É¤º«h¬°1,­Y§C©ó¤U­­©Î°ª©ó¤W­­«hÅã¥Ü 0
¦p¤U¡A½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

Sub test()
Dim Arr, Drr, Brr(), Crr(), T, XMax, XMin
Tm = Timer
Arr = Range([¸ê®Æ®w!b6], [¸ê®Æ®w!b65536].End(3))
'Drr = Sheets("¸ê®Æ®w").Range("i6:ama" & UBound(Arr) + 5)
Drr = Sheets("¸ê®Æ®w").Range("i6:p" & UBound(Arr) + 5)
[¤ñ¹ï!b6].Resize(UBound(Arr)) = Arr
ReDim Brr(1 To UBound(Arr), 1 To 8) '1 to 1000
ReDim Crr(1 To UBound(Arr), 1 To 1)
With Sheets("¤ñ¹ï")
    Arr = .Range("i3:p4")
    For i = 1 To UBound(Drr)
        Crr(i, 1) = 0
        For j = 1 To UBound(Arr, 2)
            T = Drr(i, j): XMin = Arr(1, j): XMax = Arr(2, j)
            If XMin = "" Or T = "" Then Brr(i, j) = "": GoTo 99
            If T < XMin Or T > XMax Then

                Brr(i, j) = 0
            Else
                 Brr(i, j) = 1: Crr(i, 1) = Crr(i, 1) + 1
            End If
99:     Next j
    Next i
    .Range("h6").Resize(UBound(Crr)) = Crr
    .Range("i6").Resize(UBound(Brr), UBound(Brr, 2)) = Brr
End With
MsgBox Timer - Tm
End Sub

TOP

¦^´_ 10# oak0723-1

±zªº¤½¦¡ªº±ø¥ó»P´y­z±ø¥ó¤£¤@¼Ë¦p·Ó¤ù¡A½Ð°Ý­þ­Ó¬O¥¿½T?
¥t¥~½Ð°Ý¤W¤U­­ªº©w¸q¬O¹ïªº¶Ü? Á|¨Ò¤W­­1001¡A¤U­­1006¡A¼Æ¦r­n¹ï½Õ§a? ¥¿½T¤W­­1006¡B¤U­­1001
11.PNG

TOP

¦^´_ 10# oak0723-1


    ¦]°ÝÃDÃþ¦ü
©Ò¥H´N¦b³o¨à¤@¨Ö¨D¸Ñ

TOP

¦^´_ 9# samwang
¥Ø«e¤w§¹¥þ²Å¦X§Úªº»Ý¨D
¦P¼Ë³W«h¥i§_¤ñ¹ï¦³¤W­­¤U­­¤G²Õ¼Æ¾Ú,¦pªþ¥ó
·P®¦
Image 28-02.jpg

1101005-¤ñ¹ï&¦X­p02.rar (115.5 KB)

TOP

¦^´_ 6# oak0723-1

±zªº#1¡B#7³W«h±ø¥ó¤£¤@¼Ë¦p¹Ï¤ù¡A#1±ø¥ó¤w¦^ÂÐ#5¡A#7±ø¥ó¤w¦^ÂÐ#8¡A½Ð¦A½T»{¡AÁÂÁÂ
1.PNG

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD