- ©«¤l
- 132
- ¥DÃD
- 35
- ºëµØ
- 0
- ¿n¤À
- 179
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2014-12-24
- ³Ì«áµn¿ý
- 2025-1-17
|
pºâ»ô®Æ¤é°ÝÃD
¦U¦ìExcel°ª¤â¤j®a¦n
¤p§Ì²Ä¤@¦¸µo°Ý°ÝÃD
Y¦³¤£¨¬ªº¦a¤è
ÁٽЦh¦h«ü±Ð!!
°ÝÃD¦p¤U
¦b¯Ê®Æ©ú²Óªí¤À¶¤¤·Q¨D±o¹wp¶i³f®É¶¡ÂI
·|¨Ì®w¦s¹wpª¬ªpªí¤À¶¤¤ªº°Ñ¦Ò³æ¸¹¤Î§PÂ_®w¦s¼Æ
±a¦^¶i³f¤é´Á¨ì
¯Ê®Æ©ú²Óªí¤À¶¨D±oµª®×
§Ú¦b¯Ê®Æ©ú²Óªí¤À¶ªºLÄæ¦³·Qnªºµª®×
§Ú¥Î¤U¦C¤½¦¡±a¤£¥Xµª®×
{=INDEX(®w¦s¹wpª¬ªpªí!$C$2:$C$21,MATCH("¶i³f"&D2,®w¦s¹wpª¬ªpªí!$D$2:$D$21&®w¦s¹wpª¬ªpªí!$A$2:$A$21,1),1)}
¬G½Ð°Ý¦³¦ó¤½¦¡¥i°µ§PÂ_?
¸É¥R»¡©ú
±ø¥ó¤£¤@©wn·Ó¤p§Ì©Ò»¡ªº¥h¨D¸Ñ
¥un¯à¨D±oµª®×§Y¥i
¤p§Ìè¥ÎSUMPRODUCT¥h¨D§ì¤é´Á
·|«ÂÐ=.=||
ÁÂÁÂ!!
Book1.rar (16.94 KB)
|
|