µù¥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©«
[µo°Ý]
¤ñ¹ï¸ê®Æ°ÝÃD
mycmyc
µoµu®ø®§
¥[¬°¦n¤Í
mycmyc
·í«eÂ÷½u
UID
1953
©«¤l
173
¥DÃD
42
ºëµØ
0
¿n¤À
220
ª÷¿ú
220
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 365
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
72 ¤p®É
µù¥U®É¶¡
2010-10-13
³Ì«áµn¿ý
2023-10-11
¤¤¾Ç¥Í
©«¤l
173
¥DÃD
42
ºëµØ
0
¿n¤À
220
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 365
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-10-13
³Ì«áµn¿ý
2023-10-11
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2011-2-25 00:01
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
¤ñ¹ï¸ê®Æ°ÝÃD
½Ð°Ý
a1=1 a2=2 a3=3
b1=4 b2=5 b3=6
·Q¦b c1 ¤ñ¹ï¤WzÀxÂî椤¦³ 3©Î5 ¦bc1Åã¥Ü ¬O ©Î §_
À³¸Ó¥Î¬Æ»ò¤èªk©O
¼Ó¥D¼ö©«
¨Ï¥Î TODAY() ¨ú±o¨t²Î¤é´Á µM«á©T©w¤£ÅÜ
¤f®Ö¨ú¤è¶ô 13 ¤f¥i¥H½Õ¾ã¤j¤p ¥[²ÊÃä®Ø½u
¦p¦óÅý¤u§@ªí ¤£Åã¥Ü¦C¦L½d³òªºµê½u
½Ð°Ý ·j´M ³¡¤À¦r¦ê ¬Û¦P µM«á²Ö¥[ °ÝÃD
½Ð°Ý¤@¤U ¦p¦óÅý¤µ¤é¤§«e Àx¦s®æ ¤£¯àקï
·j´M ¨Ãp¼Æ °ÝÃD
±±¨î ¥²¶ñÀxÂÃ®æ ¨S¶ñ¥X²{ĵ§i ¶ñ§¹¾ã«á A
½Ð±Ð·j´M¦WºÙ¡@§ä¥X¤é´Á¡@ÁÂÁÂ
³Æ¥÷¤å¥ó¥¨¶°°ÝÃD
½Ð°Ý ¦h«§PÂ_ ¦A§@pºâ À³¸Ó¦p¦ó³B²z¤ñ¸û
¦¬ÂÃ
¤À¨É
HI
fr447446
µoµu®ø®§
¥[¬°¦n¤Í
fr447446
·í«eÂ÷½u
UID
1857
©«¤l
61
¥DÃD
3
ºëµØ
0
¿n¤À
116
ª÷¿ú
116
ÂI¦W
0
§@·~¨t²Î
WINDOSXP
³nÅ骩¥»
OFFICE2003
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
94 ¤p®É
µù¥U®É¶¡
2010-10-6
³Ì«áµn¿ý
2014-3-5
¤¤¾Ç¥Í
©«¤l
61
¥DÃD
3
ºëµØ
0
¿n¤À
116
ÂI¦W
0
§@·~¨t²Î
WINDOSXP
³nÅ骩¥»
OFFICE2003
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-10-6
³Ì«áµn¿ý
2014-3-5
2
#
µoªí©ó 2011-2-25 08:40
|
¥u¬Ý¸Ó§@ªÌ
=IF(SUM(COUNTIF(A1:B3,3),COUNTIF(A1:B3,5))>0,"¬O","§_")
¨S¨Æ´N¨Ó³}³}
TOP
ANGELA
µoµu®ø®§
¥[¬°¦n¤Í
ANGELA
·í«eÂ÷½u
UID
196
©«¤l
812
¥DÃD
7
ºëµØ
0
¿n¤À
862
ª÷¿ú
862
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
2007
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¥x¤¤
¦b½u®É¶¡
1196 ¤p®É
µù¥U®É¶¡
2010-5-13
³Ì«áµn¿ý
2019-10-10
ª©¥D
©«¤l
812
¥DÃD
7
ºëµØ
0
¿n¤À
862
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
2007
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¥x¤¤
µù¥U®É¶¡
2010-5-13
³Ì«áµn¿ý
2019-10-10
3
#
µoªí©ó 2011-2-25 09:27
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-2-25 10:35 ½s¿è
=IF(SUMPRODUCT((A1:B3={3,5})*1),"¬O","§_")
¥H¤W¬O¿ùªº
=IF(SUMPRODUCT((A1:B3=5)*1)+SUMPRODUCT((A1:B3=3)*1) ,"¬O","§_")
OR
=IF(COUNTIF(A1:B3,3)+COUNTIF(A1:B3,5),"¬O","§_")
TOP
mycmyc
µoµu®ø®§
¥[¬°¦n¤Í
mycmyc
·í«eÂ÷½u
UID
1953
©«¤l
173
¥DÃD
42
ºëµØ
0
¿n¤À
220
ª÷¿ú
220
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 365
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
72 ¤p®É
µù¥U®É¶¡
2010-10-13
³Ì«áµn¿ý
2023-10-11
¤¤¾Ç¥Í
©«¤l
173
¥DÃD
42
ºëµØ
0
¿n¤À
220
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 365
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-10-13
³Ì«áµn¿ý
2023-10-11
4
#
µoªí©ó 2011-3-9 21:37
|
¥u¬Ý¸Ó§@ªÌ
·PÁ ANGELA fr447446 ¨â¦ì¤j¤j
§A̪º«ü¥O¦h¥i¥H¥Î ÁÂÁÂ
HI
TOP
ÀR«ä¦Û¦b :
¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ùȤ]¨S¦³¡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¯»µ·