{"id":4393,"date":"2015-07-11T15:28:16","date_gmt":"2015-07-11T06:28:16","guid":{"rendered":"http:\/\/blog.gotousubaru.jp\/honsha\/?p=4393"},"modified":"2015-07-11T15:31:47","modified_gmt":"2015-07-11T06:31:47","slug":"%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%e3%81%ae%e5%8b%89%e5%bc%b7%ef%bc%92%ef%bc%93%e5%9b%9e%e7%9b%ae","status":"publish","type":"post","link":"https:\/\/blog.gotousubaru.jp\/honsha\/2015\/07\/11\/4393","title":{"rendered":"\u30a8\u30af\u30bb\u30eb\u306e\u52c9\u5f37\uff12\uff13\u56de\u76ee"},"content":{"rendered":"

 <\/p>\n

\u4eca\u56de\u306f\u3001\u4eca\u307e\u3067\u5b66\u7fd2\u3057\u305f\u5185\u5bb9\u3092\u542b\u3081\u3001\u8272\u3005\u306a\u300c\u95a2\u6570\uff06\u6570\u5f0f\u300d\u3092\u8907\u6570\u306e\u7d44\u5408\u305b\u7b49\u3092\u3057\u3066\u3054\u62ab\u9732\u3057\u307e\u3059\u3002<\/span>
\n\u306a\u304a\u3001\u300c\u95a2\u6570\uff06\u6570\u5f0f\u300d\u306b\u95a2\u3059\u308b\u4e8b\u306f\u3053\u306e\u56de\u3067\u6700\u7d42\u3068\u3057\u3001\u6b21\u56de\u304b\u3089\uff12\u56de\u3067\u6271\u3044\u65b9\u6cd5\u3092\u52c9\u5f37\u3057\u3066\u3053\u306e\u30b7\u30ea\u30fc\u30ba\u306f\u7d42\u4e86\u3068\u3057\u307e\u3059\u3002<\/span><\/p>\n

<\/p>\n

\u3053\u308c\u304b\u3089\u306e\u30ea\u30b9\u30c8\u306f\u3001\u5168\u3066\u7b54\u3048\u3092\u8868\u793a\u3057\u3066\u3042\u308a\u307e\u3059\u3002<\/span><\/p>\n

\uff11\uff1b\u4e0b\u306e\u30ea\u30b9\u30c8\u3067\u4ee5\u4e0b\u306e\u3069\u3061\u3089\u304b\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u8005\u3092\u5224\u5b9a\u3067\u5408\u683c\u3068\u305b\u3088\u3002
\n\u6761\u4ef6\u306f\u3001\u82f1\u8a9e\uff17\uff10\u70b9\u4ee5\u4e0a\u3001\u6570\u5b66\uff17\uff10\u70b9\u4ee5\u4e0a\u3000\u3068\u3059\u308b\u3002<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n
\u540d\u524d<\/span><\/td>\n\u82f1\u8a9e<\/span><\/td>\n\u6570\u5b66<\/span><\/td>\n\u5224\u5b9a<\/span><\/td>\n<\/tr>\n
\u5c71\u7530<\/span><\/td>\n76<\/span><\/td>\n75<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u7530\u4e2d<\/span><\/td>\n66<\/span><\/td>\n68<\/span><\/td>\n\u4e0d\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u9234\u6728<\/span><\/td>\n82<\/span><\/td>\n66<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u5cf6\u7530<\/span><\/td>\n55<\/span><\/td>\n75<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u4f0a\u85e4<\/span><\/td>\n71<\/span><\/td>\n83<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u4f50\u91ce<\/span><\/td>\n66<\/span><\/td>\n78<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u4e95\u4e0a<\/span><\/td>\n45<\/span><\/td>\n90<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u5e73\u7530<\/span><\/td>\n69<\/span><\/td>\n80<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u9ad8\u6a4b<\/span><\/td>\n70<\/span><\/td>\n70<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5224\u5b9a\u5217\u306e\u95a2\u6570\u306f\u3001IF(OR(C58>=70,D58>=70),”\u5408\u683c”,”\u4e0d\u5408\u683c”)\u3067\u3059\u3002
\n\u8981\u70b9\u3001IF+OR\uff08\u8ad6\u7406\u95a2\u6570\uff09\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002<\/p>\n

\uff12\uff1b\u9806\u4f4d\u30bb\u30eb\u3092\u4f5c\u6210\u305b\u305a\u3001\u300c\uff15\u4f4d\u300d\u4ee5\u5185\u306e\u9806\u4f4d\u3092\u8a2d\u5b9a\u3057\u3001\uff15\u4f4d\u4ee5\u5185\u306b\u3067\u9806\u4f4d\u3092\u8a2d\u5b9a\u3057\u307e\u3057\u3087\u3046\u3002\u305f\u3060\u3057\u3001\uff15\u4f4d\u4ee5\u4e0b\u306f\u8a08\u7b97\u5f0f\u3067\u300c\u975e\u8868\u793a\u300d\u306b\u3057\u307e\u3057\u3087\u3046\uff01<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u652f\u793e\u540d<\/span><\/td>\n\u58f2\u4e0a\u9ad8<\/span><\/td>\n\u9806\u4f4d<\/span><\/td>\n<\/tr>\n
\uff21\u652f\u793e<\/span><\/td>\n2,820<\/span><\/td>\n5<\/span><\/td>\n<\/tr>\n
\uff22\u652f\u793e<\/span><\/td>\n2,780<\/span><\/td>\n\u3000<\/span><\/td>\n<\/tr>\n
\uff23\u652f\u793e<\/span><\/td>\n2,850<\/span><\/td>\n2<\/span><\/td>\n<\/tr>\n
\uff24\u652f\u793e<\/span><\/td>\n2,830<\/span><\/td>\n4<\/span><\/td>\n<\/tr>\n
\uff25\u652f\u793e<\/span><\/td>\n2,780<\/span><\/td>\n\u3000<\/span><\/td>\n<\/tr>\n
\uff26\u652f\u793e<\/span><\/td>\n2,790<\/span><\/td>\n\u3000<\/span><\/td>\n<\/tr>\n
\uff21\u652f\u793e<\/span><\/td>\n2,860<\/span><\/td>\n1<\/span><\/td>\n<\/tr>\n
\uff27\u652f\u793e<\/span><\/td>\n2,810<\/span><\/td>\n\u3000<\/span><\/td>\n<\/tr>\n
\uff28\u652f\u793e<\/span><\/td>\n2,730<\/span><\/td>\n\u3000<\/span><\/td>\n<\/tr>\n
\uff29\u652f\u793e<\/span><\/td>\n2,840<\/span><\/td>\n3<\/span><\/td>\n<\/tr>\n
\uff2a\u652f\u793e<\/span><\/td>\n2,720<\/span><\/td>\n\u3000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u9806\u4f4d\u5217\u306e\u95a2\u6570\u306f\u3001IF(RANK(C74,C$74:C$84)<=5,RANK(C74,C$74:C$84),””)\u3067\u3059\u3002
\n\u8981\u70b9\u3001IF+RANK+\u201d\u201d\uff08\u975e\u8868\u793a\uff09\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002<\/p>\n

\uff13\uff1b\u4ee5\u4e0b\u306b\u30ea\u30b9\u30c8\u3067\u30c6\u30b9\u30c8\u7d50\u679c\u306e\u300c\uff21\u30fb\uff22\u30fb\uff23\u300d\uff13\u6bb5\u968e\u8a55\u4fa1\u306b\u95a2\u6570\u3092\u8a2d\u5b9a\u3057\u3066\u5b8c\u6210\u3057\u307e\u3057\u3087\u3046\u3002
\n\u6761\u4ef6\u306f\u3001\u8a55\u4fa1\uff1a\u5408\u8a08\u70b9\u304c\u3001\uff12\uff13\uff10\u70b9\u4ee5\u4e0a\uff1d\uff21\u3000\uff12\uff10\uff10\u70b9\u4ee5\u4e0a\uff1d\uff22\u3000\u4ee5\u4e0b\uff1d\uff23\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n
\u540d\u524d<\/span><\/td>\n\u5316\u5b66<\/span><\/td>\n\u6570\u5b66<\/span><\/td>\n\u4f53\u80b2<\/span><\/td>\n\u5408\u8a08<\/span><\/td>\n\u8a55\u4fa1<\/span><\/td>\n<\/tr>\n
\u5c71\u7530<\/span><\/td>\n88<\/span><\/td>\n76<\/span><\/td>\n61<\/span><\/td>\n225<\/span><\/td>\nB<\/span><\/strong><\/td>\n<\/tr>\n
\u5c71\u672c<\/span><\/td>\n67<\/span><\/td>\n70<\/span><\/td>\n71<\/span><\/td>\n208<\/span><\/td>\nB<\/span><\/strong><\/td>\n<\/tr>\n
\u5e73\u5ddd<\/span><\/td>\n78<\/span><\/td>\n61<\/span><\/td>\n58<\/span><\/td>\n197<\/span><\/td>\nC<\/span><\/strong><\/td>\n<\/tr>\n
\u67cf\u6728<\/span><\/td>\n77<\/span><\/td>\n60<\/span><\/td>\n91<\/span><\/td>\n228<\/span><\/td>\nB<\/span><\/strong><\/td>\n<\/tr>\n
\u9234\u6728<\/span><\/td>\n53<\/span><\/td>\n71<\/span><\/td>\n64<\/span><\/td>\n188<\/span><\/td>\nC<\/span><\/strong><\/td>\n<\/tr>\n
\u5c71\u4e0b<\/span><\/td>\n69<\/span><\/td>\n67<\/span><\/td>\n55<\/span><\/td>\n191<\/span><\/td>\nC<\/span><\/strong><\/td>\n<\/tr>\n
\u5409\u5ca1<\/span><\/td>\n81<\/span><\/td>\n71<\/span><\/td>\n69<\/span><\/td>\n221<\/span><\/td>\nB<\/span><\/strong><\/td>\n<\/tr>\n
\u7530\u4e2d<\/span><\/td>\n92<\/span><\/td>\n81<\/span><\/td>\n71<\/span><\/td>\n244<\/span><\/td>\nA<\/span><\/strong><\/td>\n<\/tr>\n
\u6c60\u7530<\/span><\/td>\n48<\/span><\/td>\n68<\/span><\/td>\n87<\/span><\/td>\n203<\/span><\/td>\nB<\/span><\/strong><\/td>\n<\/tr>\n
\u897f\u6751<\/span><\/td>\n68<\/span><\/td>\n57<\/span><\/td>\n92<\/span><\/td>\n217<\/span><\/td>\nB<\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u8a55\u4fa1\u5217\u306e\u95a2\u6570\u306f\u3001IF(F91>=230,”A”,IF(F91<200,”C”,”B”))\u3067\u3059\u3002
\n\u8981\u70b9\u3001IF+IF\u3068\uff12\u3064\u306eIF\u3092\u4f7f\u3063\u3066\u307e\u3059\u3002<\/p>\n

\uff14\uff1b\u4ee5\u4e0b\u306e\u30ea\u30b9\u30c8\u306b\u300c\u5408\u683c\u30fb\u4e0d\u5408\u683c\u30fb\u843d\u7b2c\u300d\u306e\u8a55\u4fa1\u3092\u4ed8\u3051\u3001\u767d\u7d19\u90e8\u5206\u306f\u6b20\u5e2d\u3068\u3057\u3066\uff13\u56de\u4ee5\u4e0a\u306e\u6b20\u5e2d\u306f\u300c\u5931\u683c\u300d\u3068\u3057\u307e\u3057\u3087\u3046\uff01
\n\u6761\u4ef6\u306f\u3001\u300c83\u4ee5\u4e0a\u300d\u3092\u300c\u5408\u683c\u300d\u300c80\u4ee5\u4e0a\u300d\u3092\u300c\u88dc\u6b20\u300d\u300c80\u4ee5\u4e0b\u300d\u3092\u300c\u843d\u7b2c\u300d\u3068\u3059\u308b\u3002<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n
\u6c0f\u540d<\/span><\/td>\n\u7b2c\uff11\u56de<\/span><\/td>\n\u7b2c\uff12\u56de<\/span><\/td>\n\u7b2c\uff13\u56de<\/span><\/td>\n\u7b2c\uff14\u56de<\/span><\/td>\n\u7b2c\uff15\u56de<\/span><\/td>\n\u7b2c\uff16\u56de<\/span><\/td>\n\u7b2c\uff17\u56de<\/span><\/td>\n\u5e73\u5747\u70b9<\/span><\/td>\n\u843d\u7b2c\u5224\u5b9a<\/span><\/td>\n\u5408\u683c\u5224\u5b9a<\/span><\/td>\n<\/tr>\n
\u677e\u672c<\/span><\/td>\n87<\/span><\/td>\n82<\/span><\/td>\n\u3000<\/span><\/td>\n68<\/span><\/td>\n95<\/span><\/td>\n83<\/span><\/td>\n77<\/span><\/td>\n82.00<\/span><\/td>\n\u3000<\/span><\/td>\n\u88dc\u6b20<\/span><\/td>\n<\/tr>\n
\u68ee\u6751<\/span><\/td>\n78<\/span><\/td>\n73<\/span><\/td>\n65<\/span><\/td>\n92<\/span><\/td>\n80<\/span><\/td>\n74<\/span><\/td>\n91<\/span><\/td>\n79.00<\/span><\/td>\n\u3000<\/span><\/td>\n\u843d\u7b2c<\/span><\/td>\n<\/tr>\n
\u5150\u7389<\/span><\/td>\n\u3000<\/span><\/td>\n62<\/span><\/td>\n89<\/span><\/td>\n77<\/span><\/td>\n\u3000<\/span><\/td>\n88<\/span><\/td>\n\u3000<\/span><\/td>\n79.00<\/span><\/td>\n\u5931\u683c<\/span><\/td>\n\u843d\u7b2c<\/span><\/td>\n<\/tr>\n
\u590f\u6a39<\/span><\/td>\n91<\/span><\/td>\n86<\/span><\/td>\n74<\/span><\/td>\n68<\/span><\/td>\n85<\/span><\/td>\n98<\/span><\/td>\n99<\/span><\/td>\n85.86<\/span><\/td>\n\u3000<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u4eac\u6975<\/span><\/td>\n76<\/span><\/td>\n71<\/span><\/td>\n\u3000<\/span><\/td>\n82<\/span><\/td>\n95<\/span><\/td>\n96<\/span><\/td>\n83<\/span><\/td>\n83.83<\/span><\/td>\n\u3000<\/span><\/td>\n\u5408\u683c<\/span><\/td>\n<\/tr>\n
\u5317\u6751<\/span><\/td>\n67<\/span><\/td>\n\u3000<\/span><\/td>\n79<\/span><\/td>\n92<\/span><\/td>\n\u3000<\/span><\/td>\n\u3000<\/span><\/td>\n84<\/span><\/td>\n80.50<\/span><\/td>\n\u5931\u683c<\/span><\/td>\n\u88dc\u6b20<\/span><\/td>\n<\/tr>\n
\u7530\u8fba<\/span><\/td>\n81<\/span><\/td>\n76<\/span><\/td>\n89<\/span><\/td>\n\u3000<\/span><\/td>\n77<\/span><\/td>\n81<\/span><\/td>\n91<\/span><\/td>\n82.50<\/span><\/td>\n\u3000<\/span><\/td>\n\u88dc\u6b20<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u6570\u5f0f\uff06\u95a2\u6570\u306f\u3001\u5e73\u5747\u70b9\uff1dAVERAGE(C10:I10)\u3067\u843d\u7b2c\u5224\u5b9a\u306f\u3001=IF(COUNT(C10:I10)<=5,”\u5931\u683c”,””)\u3067\u5408\u683c\u5224\u5b9a\u306f=IF(J10>=83,”\u5408\u683c”,IF(J10>=80,”\u88dc\u6b20”,IF(J10<=80,”\u843d\u7b2c”)))\u3067\u3059\u3002
\n\u8981\u70b9\u3001AVERAGE+IF+COUNT+””\u3068\u8907\u6570\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002<\/p>\n

\uff15\uff1b\u6307\u5b9a\u3057\u305f\u5217\u7bc4\u56f2\u5185\u3067\u6700\u5c0f\u5024\u306e\u5e73\u5747\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002
\n\u4ee5\u4e0b\u306e\u30ea\u30b9\u30c8\u304b\u3089\u3010\uff11\u5217\u3011\u3010\uff12\u5217\u3011\u3010\uff13\u5217\u3011\u306e\u6700\u5c0f\u6570\u5024\u306e\u5e73\u5747\u306f\uff1f<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n
\u3000<\/span><\/td>\n\uff11\u5217<\/span><\/td>\n\uff12\u5217<\/span><\/td>\n\uff13\u5217<\/span><\/td>\n<\/tr>\n
A-001<\/span><\/td>\n23<\/span><\/td>\n34<\/span><\/td>\n76<\/span><\/td>\n<\/tr>\n
A-002<\/span><\/td>\n34<\/span><\/td>\n46<\/span><\/td>\n31<\/span><\/td>\n<\/tr>\n
A-003<\/span><\/td>\n65<\/span><\/td>\n76<\/span><\/td>\n54<\/span><\/td>\n<\/tr>\n
A-004<\/span><\/td>\n32<\/span><\/td>\n32<\/span><\/td>\n34<\/span><\/td>\n<\/tr>\n
A-005<\/span><\/td>\n54<\/span><\/td>\n76<\/span><\/td>\n76<\/span><\/td>\n<\/tr>\n
A-006<\/span><\/td>\n56<\/span><\/td>\n67<\/span><\/td>\n56<\/span><\/td>\n<\/tr>\n
A-007<\/span><\/td>\n34<\/span><\/td>\n87<\/span><\/td>\n75<\/span><\/td>\n<\/tr>\n
A-008<\/span><\/td>\n68<\/span><\/td>\n56<\/span><\/td>\n29<\/span><\/td>\n<\/tr>\n
A-009<\/span><\/td>\n65<\/span><\/td>\n56<\/span><\/td>\n56<\/span><\/td>\n<\/tr>\n
A-010<\/span><\/td>\n87<\/span><\/td>\n28<\/span><\/td>\n87<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u7b54\u3048\u306f\u3001<\/p>\n\n\n<\/colgroup>\n\n\n
26.7<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u3067\u3059\u3002\u305d\u306e\u95a2\u6570\u306f\u3001\uff1dAVERAGE(MIN(C37:C46),MIN(D37:D46),MIN(E37:E46))\u3067\u3059\u3002<\/p>\n

\u7406\u89e3\u3067\u304d\u307e\u3057\u305f\u304b\uff1f<\/p>\n

 <\/p>\n

\u305d\u308c\u3067\u306f\u3001\u307e\u305f\u3041\uff5e\uff5e\uff5e<\/p>\n

 <\/p>\n

\u76ee\u6b21\u3078\u623b\u308a\u305f\u3044\u3002<\/a>\"1\"<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

  \u4eca\u56de\u306f\u3001\u4eca\u307e\u3067\u5b66\u7fd2\u3057\u305f\u5185\u5bb9\u3092\u542b\u3081\u3001\u8272\u3005\u306a\u300c\u95a2\u6570\uff06\u6570\u5f0f\u300d\u3092\u8907\u6570\u306e\u7d44\u5408\u305b\u7b49\u3092\u3057\u3066\u3054\u62ab\u9732\u3057\u307e\u3059\u3002 \u306a\u304a\u3001\u300c\u95a2\u6570\uff06\u6570\u5f0f\u300d\u306b\u95a2\u3059\u308b\u4e8b\u306f\u3053\u306e\u56de\u3067\u6700\u7d42\u3068\u3057\u3001\u6b21\u56de\u304b\u3089\uff12\u56de\u3067\u6271\u3044\u65b9\u6cd5\u3092\u52c9\u5f37\u3057\u3066\u3053\u306e\u30b7\u30ea\u30fc\u30ba\u306f\u7d42\u4e86\u3068\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":22,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4393","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t