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

­pºâ»ô®Æ¤é°ÝÃD

­pºâ»ô®Æ¤é°ÝÃD

¦U¦ìExcel°ª¤â¤j®a¦n
¤p§Ì²Ä¤@¦¸µo°Ý°ÝÃD
­Y¦³¤£¨¬ªº¦a¤è
ÁٽЦh¦h«ü±Ð!!


°ÝÃD¦p¤U
¦b¯Ê®Æ©ú²Óªí¤À­¶¤¤·Q¨D±o¹w­p¶i³f®É¶¡ÂI
·|¨Ì®w¦s¹w­pª¬ªpªí¤À­¶¤¤ªº°Ñ¦Ò³æ¸¹¤Î§PÂ_®w¦s¼Æ
±a¦^¶i³f¤é´Á¨ì
¯Ê®Æ©ú²Óªí¤À­¶¨D±oµª®×
§Ú¦b¯Ê®Æ©ú²Óªí¤À­¶ªºLÄ榳·Q­nªºµª®×

§Ú¥Î¤U¦C¤½¦¡±a¤£¥Xµª®×
{=INDEX(®w¦s¹w­pª¬ªpªí!$C$2:$C$21,MATCH("¶i³f"&D2,®w¦s¹w­pª¬ªpªí!$D$2:$D$21&®w¦s¹w­pª¬ªpªí!$A$2:$A$21,1),1)}

¬G½Ð°Ý¦³¦ó¤½¦¡¥i°µ§PÂ_?
¸É¥R»¡©ú
±ø¥ó¤£¤@©w­n·Ó¤p§Ì©Ò»¡ªº¥h¨D¸Ñ
¥u­n¯à¨D±oµª®×§Y¥i
¤p§Ì­è¥ÎSUMPRODUCT¥h¨D§ì¤é´Á
·|­«ÂÐ=.=||
ÁÂÁÂ!!


Book1.rar (16.94 KB)

¦^´_ 4# samwang

·PÁÂsamwang À°¦£
¤½¦¡ªº³¡¥÷§Ú¤j¬ù¯àÁA¸Ñ¥Î·N
¯uªº«ÜÁÂÁ§AªºÀ°¦£!!
­ì¨Ó­n¥Î¨ì°}¦C
Ãø©Ç¸Ñ¤£¥X
°}¦C¥Îªkªº¾A·í®É¾÷§Ú¤£¬O«ÜÀ´..
³oÃ䦳±o°Ñ¦Ò¶Ü?

TOP

¦^´_ 3# fantersy

¯Ê®Æ©ú²Ó L2=INDEX(®w¦s¹w­pª¬ªpªí!$C$2:$C$21,MATCH(A2,IF(®w¦s¹w­pª¬ªpªí!$D$2:$D$21="¶i³f",®w¦s¹w­pª¬ªpªí!$C$2:$C$21),1))
°}¦C¤½¦¡¡A¤U©Ô

®w¦s¹w­pª¬ªpªí C2ªº­È®æ¦¡¦³»~¡A½Ð§ï¬°2015/02/09

TOP

¦^´_ 1# fantersy

¦pªþ¥ó

Book1.zip (13.94 KB)

book.1

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD