µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ªñ¦üÈ,¨D¸Ñ
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
ªñ¦üÈ,¨D¸Ñ
ªü¦tô
µoµu®ø®§
¥[¬°¦n¤Í
ªü¦tô
·í«eÂ÷½u
UID
694
©«¤l
45
¥DÃD
21
ºëµØ
0
¿n¤À
129
ª÷¿ú
129
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
sp2
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
26 ¤p®É
µù¥U®É¶¡
2010-6-25
³Ì«áµn¿ý
2023-12-26
¤¤¾Ç¥Í
©«¤l
45
¥DÃD
21
ºëµØ
0
¿n¤À
129
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
sp2
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-6-25
³Ì«áµn¿ý
2023-12-26
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2023-7-18 10:03
|
¥u¬Ý¸Ó§@ªÌ
ªñ¦üÈ,¨D¸Ñ
°ÝÃD¦bªþ¥ó¤º,Àµ½Ð¤j¤j¨D¸Ñ
ªñ¦üÈ,¨D¸Ñ.zip
(258.29 KB)
¤U¸ü¦¸¼Æ: 7
2023-7-18 10:03
¼Ó¥D¼ö©«
½Ð°Ý¦³¼Æµ§¤£¦PȪº¦Ò¸Õ¤À¼Æ¡I¦p¦ó³]©w¨ç¼Æ
½Ð°Ý¦p¦ó§â¿z¿ï¥Xªº¸ê®Æ§ï¦¨¥§¡ªºÈ¡IÁÂÁÂ
½Ð°Ý¥i¥H§â¼Ï¯Ã¤ÀªRªº¥[Á`§ï¦¨¥§¡¶Ü¡I
³o¬O¦p¦ó°µ¨ìªº©O¡I
½Ð°Ý¡I³oÓÀx¦s®æ°ÝÃD¸Ó¦p¦ó¸Ñ¨M©O¡IÁÂÁ¡I
½Ð°Ý¦p¦ó¿ï¾Ü°¸¼ÆÈ¡A¶K¦b¥t¥~ªºÀx¦s®æ¤W©O
¿z¿ïªº°ÝÃD¡I
½Ð°Ý°ª¤â¤@Ó²³æªº±Æ§Ç°ÝÃD
Àx¦s®æ¿ï¾Ü°ÝÃD
®É¶¡Âà´«°ÝÃD¡I½Ð¦U¦ì¤j¤j³on«ç»ò¥Î¡I
¦¬ÂÃ
¤À¨É
hcm19522
µoµu®ø®§
¥[¬°¦n¤Í
hcm19522
·í«eÂ÷½u
UID
22069
©«¤l
1364
¥DÃD
4
ºëµØ
0
¿n¤À
1374
ª÷¿ú
1374
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
1705 ¤p®É
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-5-19
¤j¾Ç¥Í
©«¤l
1364
¥DÃD
4
ºëµØ
0
¿n¤À
1374
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-5-19
3
#
µoªí©ó 2023-7-18 16:22
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ hcm19522 ©ó 2023-7-18 16:26 ½s¿è
I2{=MAX((A1:E10<=G2)*A1:E10)
J2(=MIN(IF(A1:E10>=G2,A1:E10))
¤@¤½¦¡ I3:J3{=ABS(MAX(IF($A1:$E10*-1^(I1=$J1)<=$G2*-1^(I1=$J1),$A1:$E10*-1^(I1=$J1))))
¤U¸ü
(10.23 KB)
2023-7-18 16:23
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
TOP
Andy2483
µoµu®ø®§
¥[¬°¦n¤Í
Andy2483
(«pÁy¥Öªº¾Ç¥Í)
·í«eÂ÷½u
UID
36777
©«¤l
1429
¥DÃD
40
ºëµØ
0
¿n¤À
1453
ª÷¿ú
1453
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Excel 2010 & 2016
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
1427 ¤p®É
µù¥U®É¶¡
2020-7-15
³Ì«áµn¿ý
2024-5-18
¡@¼ÊºÙ:
«pÁy¥Öªº¾Ç¥Í
¤j¾Ç¥Í
©«¤l
1429
¥DÃD
40
ºëµØ
0
¿n¤À
1453
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Excel 2010 & 2016
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥xÆW
µù¥U®É¶¡
2020-7-15
³Ì«áµn¿ý
2024-5-18
2
#
µoªí©ó 2023-7-18 12:47
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
ªü¦tô
ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
«á¾ÇÂǦ¹©«½m²ßVBA,¾Ç²ß¤è®×¦p¤U,½Ð«e½ú°Ñ¦Ò
ªñ¦üÈ,¨D¸Ñ_20230718_3.zip
(260.76 KB)
¤U¸ü¦¸¼Æ: 5
2023-7-18 12:47
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
TOP
ÀR«ä¦Û¦b :
¤@Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥Lp¸û±o¤Ö¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
Excelµ{¦¡°Ï
Word
ºÞ²z¤½§i
ºô¶³]p¤£¤À°Ï
¤@¯ë¹q¸£³nÅé°Q½×
¶i¶¥À³¥Î±M°Ï
PHP+MySQL ¤Jªù¹ê§@
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·