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

[µo°Ý] ➽¿z¿ïGÄæ>HÄæ>IÄæ

[µo°Ý] ➽¿z¿ïGÄæ>HÄæ>IÄæ

¨C¦¸³£»Ý¿z¿ï400µ§¸ê®Æ
±ø¥ó¦p¤U:

¿z¿ïGÄæ>HÄæ>IÄæ               
¿z¿ï§¹«á,±N¸ê®ÆÀx¦s¦b-¤u§@ªí1

«D±`·PÁ¤j®aÀ°¦£,ÁÂÁÂ

ªþ¤W»¡©ú¹Ï¤ù
Q1.jpg
2020-11-15 00:38


Àɮ׸ê®Æ
QQ.rar (80.7 KB)
¾Ç²ß ¾Ç²ß ¤@ª½¾Ç²ß

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2024-1-25 10:32 ½s¿è

(¿é¤J½s¸¹12335) googleºô§}:https://draft.blogger.com/blog/posts/9094075214774179359
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 1# peter95
Sub test()
Dim Arr, i&, T$, T1$, T2$, k%, Brr(1 To 10000, 1 To 10)
Arr = Range([sheet1!L2], [sheet1!C65536].End(xlUp))
    For i = 2 To UBound(Arr)
        T = Arr(i, 5): T1 = Arr(i, 6): T2 = Arr(i, 7)
        If Arr(i, 5) = "" Then GoTo 100
        If T > T1 And T1 > T2 Then
            k = k + 1
            Brr(k, 1) = Arr(i, 1): Brr(k, 2) = Arr(i, 2)
            Brr(k, 3) = Arr(i, 3): Brr(k, 4) = Arr(i, 4)
            Brr(k, 5) = Arr(i, 5): Brr(k, 6) = Arr(i, 6)
            Brr(k, 7) = Arr(i, 7): Brr(k, 8) = Arr(i, 8)
            Brr(k, 9) = Arr(i, 9): Brr(k, 10) = Arr(i, 10)
        End If
100: Next
[¤u§@ªí1!A1:J1] = Array("½s¸¹", "²£«~", "Ãþ§O", "D", "1", "2", "3", "4", "5", "6")
[¤u§@ªí1!A2].Resize(k, 10) = Brr
End Sub

TOP

¦^´_ 1# peter95

Sub ex()
Dim arr, c, x%
With Sheets("Sheet1")
Set c = .Range(.[c2], .[l2])
Set arr = .[c2].CurrentRegion
For x = 2 To arr.Rows.Count
   If arr(x, 7) > arr(x, 8) And arr(x, 8) > arr(x, 9) Then Set c = Union(c, arr(x, 3).Resize(, 10))
Next
End With
c.Copy Sheets("¤u§@ªí1").[a1]
End Sub

TOP

¦^´_ 3# samwang

GHIÄ欰¼Æ­È®æ¦¡
T$ ¬O¤å¦r®æ¦¡(String), ¥Î¨Ó¤ñ¹ï¤j¤p·|¦³°ÝÃD, ¨Ò¦p:"10.3" ·|³Q§P¤ñ "9.5"¤p
ª½±µ DIM T, T1, T2 §Y¥i

TOP

¦^´_ 5# ­ã´£³¡ªL

·PÁ­ã¤j«ü¾É¡AÁÂÁ¡C

TOP

·PÁ ³Â»¶®a±Ú°Q½×  ²³¦h¯«¤H
ªº¼ö±¡À°¦£
ÁÂÁ¤j®a
¦³§A­Ì¯u¦n
¾Ç²ß ¾Ç²ß ¤@ª½¾Ç²ß

TOP

¦^´_ 4# jcchiang
·PÁ¤j¤jÀ°¦£ ¸g´ú¸Õ ¥i¥H¨Ï¥Î

­Y¤p§Ì·QÅܬ° ¿z¿ïGÄæ>HÄæ>IÄæ>JÄæ               
¿z¿ï§¹«á,±N¸ê®ÆÀx¦s¦b-¤u§@ªí1

½Ð°Ý§Ú¸Ó¦p¦ó§ó§ï »yªk
ÁÂÁ¤j¤jÀ°¦£
¾Ç²ß ¾Ç²ß ¤@ª½¾Ç²ß

TOP

¦^´_ 8# peter95


    If arr(x, 7) > arr(x, 8) And arr(x, 8) > arr(x, 9) And arr(x, 9) > arr(x, 10) Then Set c = Union(c, arr(x, 3).Resize(, 10))

TOP

¦^´_ 9# jcchiang

·PÁ¤j¤jÀ°¦£ ¸g´ú¸Õ ¥i¥H¨Ï¥Î

­Y¤p§Ì·QÅܬ° ¿z¿ïGÄæ<HÄæ<IÄæ<JÄæ               
¿z¿ï§¹«á,±N¸ê®ÆÀx¦s¦b-¤u§@ªí1

½Ð°Ý§Ú¸Ó¦p¦ó§ó§ï »yªk
ÁÂÁ¤j¤jÀ°¦£
¾Ç²ß ¾Ç²ß ¤@ª½¾Ç²ß

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD