Excelを使ã£ãŸã˜ã‚ƒã‚“ã‘んゲームã®ä½œã‚Šæ–¹ã‚’æ•™ãˆã¦ãã ã•ã„。 - ã€ä½œã‚Šæ–¹ã€‘１）A5:C5ã«ã€ã€Œã‚°ãƒ¼ã€ã€Œãƒãƒ§ã‚ã€ã€Œãƒ‘ーã€ã¨å…¥åŠ›ã—ã¾ã™ï¼’... - Yahoo!知æµè¢‹https://detail.chiebukuro.yahoo.co.jp/qa/question_detail/q1281499077 ã€ä½œã‚Šæ–¹ã€‘ １）A5:C5ã«ã€ã€Œã‚°ãƒ¼ã€ã€Œãƒãƒ§ã‚ã€ã€Œãƒ‘ーã€ã¨å…¥åŠ›ã—ã¾ã™ ２）A7=RAND() ã¨å…¥åŠ›ã—ã¦ã€å³ã«ã‚³ãƒ”ー ３）C1=INDEX(A7:C7,MATCH(MAX(A9:C9),A9:C9,0)) ４）ã“ã‚Œã§ã€ã€ŒF9ã€ã‚’押ã™ã¨ã€ãƒ©ãƒ³ãƒ€ãƒ ã«ã€Œã‚°ãƒ¼ã€ã€Œãƒãƒ§ã‚ã€ã€Œãƒ‘ーã€ãŒC1ã«è¡¨ç¤ºã•ã‚Œã¾ã™ ５）A5:C6ã®ç¯„囲を指定ã—ã¦ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ãƒãƒ¼ã®ã€ŒæŒ¿å…¥ã€â†’「åå‰ã€â†’「作æˆã€ã‚’é¸æŠžã—ã¦ã€ ６）「上端行ã€ã«ãƒã‚§ãƒƒã‚¯ã—ã¦ã€ï¼¯ï¼« ７）セルC2をコピーã—ã¦ã€C2ã«å›³ã®ãƒªãƒ³ã‚¯è²¼ã‚Šä»˜ã‘ã‚’ã—ã¾ã™ ８）「数å¼ã€â†’「åå‰ã®å®šç¾©ã€ã‚’é¸æŠžã—ã¦ã€ã€Œåå‰ã€ã«ã€Œã˜ã‚ƒã‚“ã‘ん相手ã€ã¨å…¥åŠ›ã—ã¦ã€ã€Œå‚照範囲ã€ã«ã€=INDIRECT($C$1) ã¨å…¥åŠ›ã—ã¾ã™ ９）A2ã®å›³ã‚’指定ã—ã¦ã€æ•°å¼ãƒãƒ¼ã«ã€ã€Œ=ã˜
{{#tags}}- {{label}}
{{/tags}}