ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

EXCEL ªí®æ¤ñ¹ï¯Ê³f¤é´Á

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¤ë¥÷Á`¦@ÁÙ¦³72500pcs­n¥X¡A©Ò¥H¦b6¤ë¥÷ªºDeltaÄæ¦ì¸Ì­±¥X²{­t­È¡C
¦]¦¹¡A·Q­n½Ð±Ð¤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!!


Short Date Mapping.rar (10.27 KB)

¥»©«³Ì«á¥Ñ 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),),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 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

¦^´_ 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ªí ¤W¤@¥DÃD