µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ·~ÁZ¹ô§O¬d§ä
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
·~ÁZ¹ô§O¬d§ä
mikan
µoµu®ø®§
¥[¬°¦n¤Í
mikan
·í«e¦b½u
UID
839
©«¤l
39
¥DÃD
16
ºëµØ
0
¿n¤À
118
ª÷¿ú
118
ÂI¦W
242
§@·~¨t²Î
windows 2000
³nÅ骩¥»
office 2003
¾\ŪÅv
20
¦b½u®É¶¡
1010 ¤p®É
µù¥U®É¶¡
2010-7-7
³Ì«áµn¿ý
2024-12-23
¤¤¾Ç¥Í
©«¤l
39
¥DÃD
16
ºëµØ
0
¿n¤À
118
ÂI¦W
242
§@·~¨t²Î
windows 2000
³nÅ骩¥»
office 2003
¾\ŪÅv
20
µù¥U®É¶¡
2010-7-7
³Ì«áµn¿ý
2024-12-23
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2021-1-28 22:05
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
·~ÁZ¹ô§O¬d§ä
¤½¥qªº·~ÁZ²Îpªí«È¤á±Æ¦C¦³©T©wªº¶¶§Ç¡A©Ò¥H¤£¤è«K¥Î¼Ï¯Ã¡]ÁÙ¬O¥i¥H¡H¡^
©Ò¥H¥[¤F»²§UÄæ¥hpºâ¦U«È¤á¨C¤ëªº·~ÁZ¡C
¤U¸ü
(144.97 KB)
2021-1-28 21:59
¦p¤W¹Ï¡A¢Ð°Ï¬°¨C¤Ñªº¾P³fª÷ÃB¡A¢Ñ¬°¨C¤ëªºª÷ÃB¡]¶·´«ºâ¦¨¥x¹ô¡^
¦b´«ºâ¦¨¥x¹ô¤è±¡A·Q¤£¥Xn«ç»ò±a¶i¤½¦¡¤º¡A¦p¤U¹Ï¡A
½Ð°Ý¤½¦¡«á±¦p¦ó¥[¤W±a¤J¥x¹ôªº¤½¦¡¡H
¤U¸ü
(60.77 KB)
2021-1-28 21:59
ÁÂÁ¡C
·~ÁZ.zip
(8.17 KB)
¤U¸ü¦¸¼Æ: 7
2021-1-28 21:58
¼Ó¥D¼ö©«
Àx¦s®æªº¤º®e¬O§_¥i¤@¦¸¦b¸ê¦C½s¿è¦C¤¤¬Ý¨ì
outlook mail¦p¦ó´¡¤Jª«¥ó
excel¦p¦ó«Ø¥ß§Ö³t³sµ²¤ÎקïÅã¥Ü¤å¦r
¼Ï¯Ã¤ÀªRÄæ¦C±Æ§Ç°ÝÃD
spellnumber¤½¦¡±a¥X¨ÓªºªÅ®æ
¤£¦P«È¤á¤U³æ¼t§O²Îp
Â_¦æ½Æ»s¨ì°O¨Æ¥»¤WµLÂ_¦æ
¦hÓÄæ¦ì¬d§ä¡H
§å¸¹ºI¨ú
¦p¦ó±a¥X²Ä¤GÓ(¥H¤W)Ápµ¸¤H¸ê®Æ
¦¬ÂÃ
¤À¨É
mikan
µoµu®ø®§
¥[¬°¦n¤Í
mikan
·í«e¦b½u
UID
839
©«¤l
39
¥DÃD
16
ºëµØ
0
¿n¤À
118
ª÷¿ú
118
ÂI¦W
242
§@·~¨t²Î
windows 2000
³nÅ骩¥»
office 2003
¾\ŪÅv
20
¦b½u®É¶¡
1010 ¤p®É
µù¥U®É¶¡
2010-7-7
³Ì«áµn¿ý
2024-12-23
¤¤¾Ç¥Í
©«¤l
39
¥DÃD
16
ºëµØ
0
¿n¤À
118
ÂI¦W
242
§@·~¨t²Î
windows 2000
³nÅ骩¥»
office 2003
¾\ŪÅv
20
µù¥U®É¶¡
2010-7-7
³Ì«áµn¿ý
2024-12-23
4
#
µoªí©ó 2021-1-29 22:00
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
hcm19522
¦^´_
3#
ã´£³¡ªL
ÁÂÁ¨â¦ì
TOP
ã´£³¡ªL
µoµu®ø®§
¥[¬°¦n¤Í
ã´£³¡ªL
·í«eÂ÷½u
UID
13768
©«¤l
2839
¥DÃD
10
ºëµØ
0
¿n¤À
2895
ª÷¿ú
2895
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
¦b½u®É¶¡
2113 ¤p®É
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-12-22
ª©¥D
©«¤l
2839
¥DÃD
10
ºëµØ
0
¿n¤À
2895
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-12-22
3
#
µoªí©ó 2021-1-29 10:50
|
¥u¬Ý¸Ó§@ªÌ
=SUMPRODUCT(($H$3:$H$21=$N3)*($F$3:$F$21=O$2)*SUMIF($B$3:$D$3,$I$3:$I$21,INDEX($B:$D,O$2+3,)),$J$3:$J$21)
¦P¤@«È¤á¦P®É¨Ï¥Î¤£¦P¹ô§O¤]¥i¥H~~
TOP
hcm19522
µoµu®ø®§
¥[¬°¦n¤Í
hcm19522
·í«eÂ÷½u
UID
22069
©«¤l
1391
¥DÃD
4
ºëµØ
0
¿n¤À
1401
ª÷¿ú
1401
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
1755 ¤p®É
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-12-16
¤j¾Ç¥Í
©«¤l
1391
¥DÃD
4
ºëµØ
0
¿n¤À
1401
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-12-16
2
#
µoªí©ó 2021-1-29 10:18
|
¥u¬Ý¸Ó§@ªÌ
https://blog.xuite.net/hcm19522/twblog/589587257
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
TOP
ÀR«ä¦Û¦b :
¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
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¯»µ·