µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ¨ú±o¤£¦Psheet¶¦¸¼ÆÈ
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
¨ú±o¤£¦Psheet¶¦¸¼ÆÈ
chi830
µoµu®ø®§
¥[¬°¦n¤Í
chi830
·í«eÂ÷½u
UID
5396
©«¤l
105
¥DÃD
27
ºëµØ
0
¿n¤À
168
ª÷¿ú
168
ÂI¦W
207
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
454 ¤p®É
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-11-8
¤¤¾Ç¥Í
©«¤l
105
¥DÃD
27
ºëµØ
0
¿n¤À
168
ÂI¦W
207
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-11-8
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2013-9-11 16:08
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
¨ú±o¤£¦Psheet¶¦¸¼ÆÈ
¦^¶Ç¤£¦Psheet¶¼ÆÈ.rar
(9.02 KB)
¤U¸ü¦¸¼Æ: 4
2013-9-11 16:07
½Ð±Ð¥ý¶i~
¦pªþ¥ó©Ò¥Ü¡A§Ú·Q¹F¦¨¨ú±o¤£¦Psheet©Òpºâ«áªºÈ¡A¦³¤°»ò¤èªk©O?
ÁÂÁ¤j®a~~
¼Ó¥D¼ö©«
¦p¦ópºâÀx¦s®æÃC¦â¬Û¦Pªº¼Æ¶q?
ÀÉ®×Y¶W¹L4G¡A«oµLªkCopy¦ÜÀH¨(µw)ºÐ¸Ì
¥i§_³]©wÄæ¦ìªº®æ¦¡¡A¥Ht¼Æ«¬ºA§e²{?
¦Û°Ê¶ñ¤J¥¼°µ¦C¦L¼Ð°Oªº§Ç¸¹
§Ö³t¤Á´«¨ì¬YSheet¶±
explorer.exe À³¥Îµ{¦¡¿ù»~
¦p¦ó¦X¨Ö¦hÓcsvÀɮשó¦P¤@¥÷
§ä¦P¤@¦C¤¤¤£¬°0ªº³Ì¤pÈ
¨C±øªø±ø¹Ïªº³»ÂI¡A¦p¦ó±N¥¦¦ê³sµe¤@±ø½u¥X
¤£¦PÀɦW¶¡Sheetªº½Æ»s¡A¥B¸ê®Æ¯à¦Û°Ê§ó·s
¦¬ÂÃ
¤À¨É
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
2
#
µoªí©ó 2013-9-12 13:12
|
¥u¬Ý¸Ó§@ªÌ
=INDIRECT("Sheet2!R"&IFERROR(MATCH(Sheet1!A2+1,Sheet2!$A$2:$A$8,),COUNTA(Sheet2!D:D))&"C4",)
TOP
chi830
µoµu®ø®§
¥[¬°¦n¤Í
chi830
·í«eÂ÷½u
UID
5396
©«¤l
105
¥DÃD
27
ºëµØ
0
¿n¤À
168
ª÷¿ú
168
ÂI¦W
207
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
454 ¤p®É
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-11-8
¤¤¾Ç¥Í
©«¤l
105
¥DÃD
27
ºëµØ
0
¿n¤À
168
ÂI¦W
207
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-11-8
3
#
µoªí©ó 2013-9-12 14:00
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
ANGELA
¦^¶Ç¤£¦Psheet¶¼ÆÈ.rar
(9.37 KB)
¤U¸ü¦¸¼Æ: 4
2013-9-12 13:56
ÁÂÁÂANGELA¤j¤j¦^ÂÐ~
¨Ì±zªº¤è¦¡¥i¨D±oSHEET2 ¨Ì¤é´Á©Ò²ÖpªºÈ
¥i¬O§Ú§Æ±æ¯à¹F¦¨ SHEET1¡A·í§Ú¿é¤J¤é´Á®É¡A¦Û°Ê±a¤JSHEET2¸Ó¤é´ÁªºÁ`¦X¡A§Ú¦³×¥¿EXCEL»¡©ú¡A·Ð½Ð±z¦A«ü¾É¤@¤U
·P¿E¤£ºÉ~~^^
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
4
#
µoªí©ó 2013-9-12 23:28
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
chi830
¨Ï¥Î¤£³W½dªº¸ê®Æ®w·|¼W¥[¤½¦¡ªºt担
¤é´Á¤£¬Ù²¤¥Îsumproduct()²³æ¦h¤F
=SUMPRODUCT((A2>=Sheet2!$A$2:$A$12)*(Sheet2!$B$2:$B$12))-SUMPRODUCT((A2>=Sheet2!$A$2:$A$12)*(Sheet2!$C$2:$C$12))
¦pªG¤@©wnªÅ¥Õ¥i°Ñ¦Ò
http://forum.twbts.com/viewthrea ... hlight=%C1%F4%C2%C3
TOP
chi830
µoµu®ø®§
¥[¬°¦n¤Í
chi830
·í«eÂ÷½u
UID
5396
©«¤l
105
¥DÃD
27
ºëµØ
0
¿n¤À
168
ª÷¿ú
168
ÂI¦W
207
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
454 ¤p®É
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-11-8
¤¤¾Ç¥Í
©«¤l
105
¥DÃD
27
ºëµØ
0
¿n¤À
168
ÂI¦W
207
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-11-8
5
#
µoªí©ó 2013-9-16 16:28
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-9-19 23:23 ½s¿è
·PÁÂ ANGELA¤j¤j~
¦p±z©Ò»¡¡A¤é´Á¤£¬Ù²¤¡A´N§Y¬°©Ò¨D¤F¡AÁÂÁ±z³á
¥i½Ð±Ð¤@¤Usumproductªº¥Îªk¡A¬°¤°»òn(Sheet2!$A$2:$A$12)*(Sheet2!$B$2:$B$12)
¨ºÓ* ¬Oªí¥Ün²Ö¿n©Mªº·N«ä¶Ü?
TOP
ÀR«ä¦Û¦b :
¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡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¯»µ·