- ©«¤l
- 12
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 15
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Excel2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-12-8
- ³Ì«áµn¿ý
- 2017-8-21
|
[µo°Ý] Ãö©ó½Æ»s¸ê®Æ, "²¤¹LªÅ®æ"
¤£¦n·N«ä, ·Q«Ü¤[, ¤@ª½§ä¤£¨ì¾A¦Xªº§@ªk
ªí®æ A ¤w³z¹L³]©w¨ç¼Æ·j´M§ä¨ì¹ïÀ³ªº¼ÆÈ,
¤½¦¡ " =IFERROR(LOOKUP(,0/(($C3=$C$12:$C$18)*(D$2=$D$12:$D$18)),$E$12:$E$18),"")"
ªí®æB¬O¤w¸g¦s¦bªº¸ê®Æ;
²{¦b·Qn§âªí®æA ªº¸ê®Æcopy¨ìªí®æ B¤¤, ²£¥Íªí®æC
ªí®æA¤¤ªÅ¥Õ³¡¤À,¤£·|¥hÂл\ªí®æB¤¤ªº¸ê®Æ, ½Ð°Ý¸Ó¦p¦ó°µ©O?
¸ÕµÛ¥Î"²¤¹LªÅ®æ", ¤£¹L¦ü¥G¤£¦æ,
ÁöµM¬OªÅ¥ÕÀx¦s®æ, ¤£¹L¸Ì±ÁÙ¬O¦³¸ê®Æ
½Ð°ÝÁÙ¦³¤°»ò¤èªk?? ¸ê®Æµ§¼Æ¦³´X¤dµ§, ©Ò¥H¨S¿ìªk¤@µ§µ§¤â°Ê½Æ»s
ÁÂÁÂ~
|
-
-
Book-3.rar
(34.95 KB)
|