¦p¦óºâ¥XÅã¥Ü²Ä´X¦W¨ÃÅã¥Ü²ÄX¦W
- ©«¤l
- 39
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2018-11-23
- ³Ì«áµn¿ý
- 2020-2-26
|
¦p¦óºâ¥XÅã¥Ü²Ä´X¦W¨ÃÅã¥Ü²ÄX¦W
|
¤pªZ
|
|
|
|
|
- ©«¤l
- 39
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2018-11-23
- ³Ì«áµn¿ý
- 2020-2-26
|
¦p¦óºâ¥XIÄæ¬O²Ä´X¦W, ¤ñ¦p²Ä¤@¦W·|Åã¥Ü ²Ä¤@¦W¦Ó¤£¬O1 |
|
¤pªZ
|
|
|
|
|
- ©«¤l
- 39
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2018-11-23
- ³Ì«áµn¿ý
- 2020-2-26
|
°£¤F³oÓ¤èªk¥i¥H¥Î¨ç¼Æ¥N¶Ü
|
|
¤pªZ
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¦^´_ 2# show5217
±Nªü©Ô§B¼Æ¦rÂà´«¦¨¡u¤@¡B¤G¡B¤T¡B¥|...¡v®æ¦¡
¨Ï¥Î
=TEXT(n³]©w®æ¦¡ªºÈ,"[DBNum1]0")
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|
- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
·QÅã¥Ü¬°:²Ä¤@¦W..²Ä¤G¦W.....
1) ¦Ûq®æ¦¡: ²Ä¤Q¦W¦Ü²Ä¤Q¤E¦W, ·|Åã¥Ü¬° ²Ä¤@¤Q¦W, ²Ä¤@¤Q¤@¦W...²Ä¤@¤Q¤E¦W
2) ¥Î¨ç¼ÆTEXTÂà´«®æ¦¡¬O¥i¥H¥[¤u³B²z, ¦ý¨äȬ°¤å¦r®æ¦¡, µLªk±Æ§Ç¤Î«áÄò¹Bºâ |
|
|
|
|
|
|
- ©«¤l
- 39
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2018-11-23
- ³Ì«áµn¿ý
- 2020-2-26
|
¦^´_ 5# ã´£³¡ªL
ÁÂÁ¤j¤j §Ú¬ã¨s¤F¤@¤U¥Î
Private Sub CommandButton1_Click()
Range("j2:j100").Clear
For I = 2 To 11
Cells(I, 10).Value = "=Rank(I" & I & " ,I$2:I$11" & "" & ")"
Next
End Sub
Private Sub CommandButton2_Click()
Dim Str As Variant
Dim X As Long, Y As Integer, Z As Integer
Dim NX As Long, NA As Integer
Str = "1=²Ä¤@¦W 2=²Ä¤G¦W 3=²Ä¤T¦W"
Str = Split(Str)
NA = UBound(Str)
For Y = 2 To 11
NX = Cells(65536, Y).End(xlUp).Row |
|
¤pªZ
|
|
|
|
|
- ©«¤l
- 39
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2018-11-23
- ³Ì«áµn¿ý
- 2020-2-26
|
¦^´_ 5# ã´£³¡ªL
§Ú°Ñ¦Ò¥ÎIF(COUNTIF(I$2:I$11,">"&I2)+1=1,"²Ä¤@¦W",IF(COUNTIF(I$2:I$11,">"&I2)+1=2,"²Ä¤G¦W",IF(COUNTIF(I$2:I$11,">"&I2)+1=3,"²Ä¤T¦W",COUNTIF(I$2:I$11,">"&I2)+1))) ÁÂÁ¤j¤j |
|
¤pªZ
|
|
|
|
|
- ©«¤l
- 39
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2018-11-23
- ³Ì«áµn¿ý
- 2020-2-26
|
¦^´_ 4# p212
¦h¾Ç¤@©Û ÁÂÁ |
|
¤pªZ
|
|
|
|
|