µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» EXCEL ªí®æ¤ñ¹ï¯Ê³f¤é´Á
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
EXCEL ªí®æ¤ñ¹ï¯Ê³f¤é´Á
blcy1219
µoµu®ø®§
¥[¬°¦n¤Í
blcy1219
·í«eÂ÷½u
UID
21047
©«¤l
2
¥DÃD
1
ºëµØ
0
¿n¤À
3
ª÷¿ú
3
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
EXCEL 2010
¾\ŪÅv
10
¦b½u®É¶¡
2 ¤p®É
µù¥U®É¶¡
2015-5-28
³Ì«áµn¿ý
2019-3-4
¤p¾Ç¥Í
©«¤l
2
¥DÃD
1
ºëµØ
0
¿n¤À
3
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
EXCEL 2010
¾\ŪÅv
10
µù¥U®É¶¡
2015-5-28
³Ì«áµn¿ý
2019-3-4
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2015-5-28 17:29
|
¥u¬Ý¸Ó§@ªÌ
EXCEL ªí®æ¤ñ¹ï¯Ê³f¤é´Á
¤p§Ì·Q½Ð±Ð¤@¤U¤j®a
¦bªþÀɪºSheet "Original Database" ¸Ì±¥]§t¨âÓªí®æ¡G
A) ²£«~¦WºÙ¤Î®w¦s¡B«Ý¥X³f¼Æ¶q¡B¯Ê³f¼Æ¶q (¨Ì¤ë¥÷)
B) ²£«~¦WºÙ¤Î«Ý¥X³f¼Æ¶q¡BÁ`¯Ê³f¼Æ¶q¡B¯Ê³f¤é´Á (Á`ªí)¡A¨Ã¥B¤w¸g¨Ì·Ó²£«~¦WºÙ¤Î¥X³f¤é´Á°µ±Æ§Ç
¥H²£«~"F2839"Á|¨Ò¡A¥Ø«e¤â¤W®w¦s¦³2500pcs¡A5¤ë¥÷Á`¦@n¥X2500pcs¡A¬G¨S¦³¯Ê³f¼Æ¶q¡C
¦ý6¤ë¥÷Á`¦@ÁÙ¦³72500pcsn¥X¡A©Ò¥H¦b6¤ë¥÷ªºDeltaÄæ¦ì¸Ì±¥X²{tÈ¡C
¦]¦¹¡A·Qn½Ð±Ð¤j®aªº°ÝÃD¬O¡G
n¦p¦ó¦b¸Ó²£«~ªº¯Ê®Æ¤ë¥÷Àx¦s®æ¤¤¡A§Q¥Î¤½¦¡ªº¤èªk¡A¥h¦ê¥X"¸Ó¤ë¥÷ªº²Ä¤@ӯʳf¤é´Á"©O?
Ex. F2839 ©ó6¤ë¥÷ (H4 Àx¦s®æ)¡A¨ä¯Ê³f¤é´ÁÀ³¬° 6/5/2015 (Ref to P7 Àx¦s®æ)
Ex. F2839 ©ó7¤ë¥÷ (K4 Àx¦s®æ)¡A¨ä¯Ê³f¤é´ÁÀ³¬° 7/7/2015 (Ref to P8 Àx¦s®æ)
Ex. O9223 ©ó7¤ë¥÷ (K6 Àx¦s®æ)¡A¨ä¯Ê³f¤é´ÁÀ³¬° 7/27/2015 (Ref to P15 Àx¦s®æ)
Ex. P1309 ©ó6¤ë¥÷ (H7 Àx¦s®æ)¡A¨ä¯Ê³f¤é´ÁÀ³¬° 6/15/2015 (Ref to P17 Àx¦s®æ)
ÁÂÁ¤j®a!!
¤U¸ü
(111.2 KB)
2015-5-28 17:26
Short Date Mapping.rar
(10.27 KB)
¤U¸ü¦¸¼Æ: 7
2015-5-28 17:28
¦¬ÂÃ
¤À¨É
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«eÂ÷½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
238
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4097 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-3
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
238
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-3
2
#
µoªí©ó 2015-5-31 16:43
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ Hsieh ©ó 2015-5-31 16:44 ½s¿è
¦^´_
1#
blcy1219
H3°}¦C¤½¦¡
=IFERROR(INDEX($P$2:$P$17,MATCH(1,1/((TEXT($P$2:$P$17,"yyyymm")=TEXT(F$1,"yyyymm"))*($M$2:$M$17=$A3)*($O$2:$O$17<0)),0),),"")
¤U¸ü
(28.06 KB)
2015-5-31 16:44
¾Ç®üµL²P_¤£®¢¤U°Ý
TOP
blcy1219
µoµu®ø®§
¥[¬°¦n¤Í
blcy1219
·í«eÂ÷½u
UID
21047
©«¤l
2
¥DÃD
1
ºëµØ
0
¿n¤À
3
ª÷¿ú
3
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
EXCEL 2010
¾\ŪÅv
10
¦b½u®É¶¡
2 ¤p®É
µù¥U®É¶¡
2015-5-28
³Ì«áµn¿ý
2019-3-4
¤p¾Ç¥Í
©«¤l
2
¥DÃD
1
ºëµØ
0
¿n¤À
3
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
EXCEL 2010
¾\ŪÅv
10
µù¥U®É¶¡
2015-5-28
³Ì«áµn¿ý
2019-3-4
3
#
µoªí©ó 2015-6-1 17:43
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
Hsieh
Hello Hsieh,
¯uªº«D±`ÁÂÁ§AªºÀ°¦£¡A´£¨Ñ³o¤@Ó«D±`¹ê¥Îªº°}¦C¸Ñªk
¸g¹L¹ê»Ú©µ¦ù¨ì¸û¤j¶qªº¸ê®Æ¤º®e«á¡AÃÒ¹ê¤]ªº½T¥i¦æ¡AÅý§Ú³oÃä¤j´TÁYµu¤F¤H¤u§@·~®É¶¡!
«D±`ÁÂÁÂ!!! :)
TOP
JBY
µoµu®ø®§
¥[¬°¦n¤Í
JBY
·í«eÂ÷½u
UID
10955
©«¤l
161
¥DÃD
0
ºëµØ
0
¿n¤À
168
ª÷¿ú
168
ÂI¦W
0
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
222 ¤p®É
µù¥U®É¶¡
2012-9-16
³Ì«áµn¿ý
2017-2-19
¤¤¾Ç¥Í
©«¤l
161
¥DÃD
0
ºëµØ
0
¿n¤À
168
ÂI¦W
0
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2012-9-16
³Ì«áµn¿ý
2017-2-19
4
#
µoªí©ó 2015-6-3 23:34
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
blcy1219
H3 ´¶³q¤½¦¡ («D°}¦C¤½¦¡) :
=IFERROR(INDEX($P$2:$P$17,MATCH(1,INDEX((TEXT(F$1,"yyymm")=TEXT($P$2:$P$17,"yyymm"))*($M$2:$M$17=$A3)*($O$2:$O$17<0),0),0)),"")
TOP
ÀR«ä¦Û¦b :
¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡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¯»µ·