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

[µo°Ý] ¦p¦ó¨Ì·Ó¨â­Ó¬Û¦P±ø¥ó¡A±N¸ê®Æ¶×¤J«ü©w¦ì¸m

[µo°Ý] ¦p¦ó¨Ì·Ó¨â­Ó¬Û¦P±ø¥ó¡A±N¸ê®Æ¶×¤J«ü©w¦ì¸m

¥»©«³Ì«á¥Ñ pupai ©ó 2014-6-10 09:43 ½s¿è

°ÝÃD½Ð±Ð
¨Ì·Ó¨â­Ó±ø¥ó(ID¤Î¤é´Á)¡A·Q±N¤À­¶(¤u§@ªí2)ªº¡¨¬ì¥Ø¡¨¸ê®Æ¡A¶×¤J¤À­¶(¤u§@ªí1)«ü©w¦ì¸m¤¤
½Ð°Ý¤À­¶(¤u§@ªí1)§ÚC2ªº®æ¦¡¤¤¡A­n¶ñ¤J¦óºØ¨ç¼Æ¤½¦¡¡A¤~¥i¥H±o¨ì§Ú·Q­nªº­È
·P®¦  ÁÂÁÂ!!

¬¡­¶Ã¯2.rar (7.01 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-10 12:27 ½s¿è

¦^´_ 1# pupai
¿ï¨ú¤u§@ªí2¤§A1:C16¡ACtrl+Shift+F3¡A¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¡C
½Ð°Ñ¦Òªþ¥ó¡I

¬¡­¶Ã¯2_°Ñ¦Ò.zip (8.24 KB)

TOP

¦^´_  pupai
¿ï¨ú¤u§@ªí2¤§A1:C16¡ACtrl+Shift+F3¡A¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¡C
½Ð°Ñ¦Òªþ¥ó¡I
p212 µoªí©ó 2014-6-10 12:26



­ì¥»·Q»¡¨Ï¥Î VLOOKUP ¨ç¼Æ¨Ó¸Ñ¨M§Úªº°ÝÃD
¦ý¬O¨Ï¥Î VLOOKUP ¨ç¼Æ¡A¨C¦¸³£¥u¬O¦C¥X¬Û¦P¤º®eªº²Ä¤@µ§¡A¤£²Å¦X§Úªº»Ý¨D
ÁÂÁÂ坂¤j~~¦h¾Ç¨ì¤°»ò¬O"³»ºÝ¦C"
¥t¥~½Ð°Ý坂¤j
IF(SUMPRODUCT((Id=$A2)*(¤é´Á=$B2)*(¬ì¥Ø=C$1)*1),"*","")¤¤ªº"*1"¬O¤°»ò·N«ä
ÁÂÁÂ!!

TOP

¦^´_ 3# pupai
=IF(SUMPRODUCT((Id=$A2)*(¤é´Á=$B2)*(¬ì¥Ø=C$1)*1),"*","")¤¤没¦³¡u*1¡v¥ç¥i (Sorry¡I¤¤¤È»°¶}·|¼g¤Ó§Ö¦Ó¥¼ª`·N¡A­ì¥»¡uTrue/False¡vªºµ²ªG§Y·|µø¬°¡u1/0¡v©Ò¥H¤£¥Î¡u*1¡v¡C)
½Ð°Ñ¦Ò¡I

TOP

¦^´_  pupai
=IF(SUMPRODUCT((Id=$A2)*(¤é´Á=$B2)*(¬ì¥Ø=C$1)*1),"*","")¤¤没¦³¡u*1¡v¥ç¥i (Sorry¡I ...
p212 µoªí©ó 2014-6-10 14:05



    ¤F¸Ñ  ·P®¦

TOP

¦^´_ 4# p212


    ½Ð°Ý¦pªG­n¾É¤J­È­n¦p¦ó­×§ï
ÁÂÁÂ!!

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-26 11:45 ½s¿è

¦^´_ 6# pupai
½Ð°Ý´N2#Àɮפ¤ªº¸ê®Æ±z­n¾É¤J¤°»ò­È¡H(¤u§@ªí2¨ÃµLÃB¥~ªº¸ê®Æ)
ÁÂÁ¡I

TOP

¦^´_ 7# p212

ªO¤j¦n
¬Q¤é¨S¦³¤W¶ÇÀɮסA©êºp
§Úªº·N«ä¬O·Q§â¤À¼Æªº"­È"¶×¤J«ü©wÄæ¦ì
¦pªþÀÉ©Ò¦C
½Ð«ü¾É ÁÂÁÂ!!

¤À¼Æ.rar (7.78 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-27 12:19 ½s¿è

¦^´_ 8# pupai
¿ï¨ú¤u§@ªí2¤§A1:D16¡ACtrl+Shift+F3¡A¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¡C
¤u§@ªí1¤§Àx¦s®æC2¿é¤J
=SUMPRODUCT((Id=$A2)*(¤é´Á=$B2)*(¬ì¥Ø=C$1)*¤À¼Æ)
¦V¥k¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

¤À¼Æ_2.zip (8.54 KB)

TOP

¦^´_ 9# p212

P¤j¦n
¤§«e§Ú¤@ª½¼Ò¥é¥Î¿ùªº¤è¦¡±a¤J   
­ì¨Ó¼Æ¦rªº±a¤J»P¤å¦rªº±a¤J¤£¤@¼Ë
¨ü±Ð ·P®¦!!

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