¦³¦Ò¶Ôªí¶i¦æ¤ÀªR, ¦³¨ç¼ÆÀ³¥Î½Ð±Ð::Q
¦Ò¶Ô¤ÀªR201607.zip (14.23 KB)
°ÝÃD1) 7¤ë5¤é2¸¹û¤uªºALPM, ¤£¯à¥X²{¦b°²´Á¤ÀÃþ, ¨ç¼Æ¬OCOUNTIF($B12:$E12,"ALPM") (¨ä¥L¦p3¸¹û¤uNPL¤Î4¸¹û¤uªºHDXX³£¤£¯àCOUNT)
°ÝÃD2) ¦p¦óÀ³¥Î*©Î?¸U¥Î¦r¤¸, ¦]AI12ªºµ{¦¡¤£¯à¨Ï¥Î "SL*"¨Ó¨ú¸ê®Æ.
°ÝÃD3) ¥¼ª¾ÄæI"¥[¯Z¤ÀÄÁÁ`p"¤ÎJ"¿ð¨ì¤ÀÄÁÁ`p"¬°¦ó¥X²{#VALUE? |