以ä¸ã®è¡¨ããã¨ã«ãã¹ãã³ãã¿ã³ã使ã£ã¦ï¼è¡ç®ã«ï¼è¡ãã¤æ½åºããæ¹æ³ã«ã¤ãã¦è§£èª¬ãã¦ããã¾ãã ã¾ãã¯ãã»ã«A3ã«çªå·ãå ¥åãããã®çªå·ã«å¯¾å¿ããè¡æ°ã®ãã¼ã¿ãæ½åºããä»çµã¿ãä½ã£ã¦ããã¾ãã ã»ã«A3ãï¼ã®æã¯ï¼è¡ç®ã®ãã¼ã¿ãæ½åºãï¼ã®æã¯ï¼è¡ç®ãï¼ã®æã¯ï¼è¡ç®ã¨ããæãã«ä½æãã¾ãã ãã®ãããªä»çµã¿ã¯OFFSETé¢æ°ã使ãã¨ç°¡åã«å®ç¾ã§ãã¾ãã =OFFSET(åç §, è¡æ°, åæ°, [é«ã], [å¹ ]) // [åç §]ã®ç¯å²ãåºæºã«è¡æ¹åã¸[è¡æ°]å移åããåæ¹åã¸[åæ°]å移åããã¨ããã®æå®ãã[é«ã]ã¨[å¹ ]ã®ãã¼ã¿ãæ½åºãã¾ãã ã¾ãã¯ãã»ã«B3ã«å ¥åããå¼ãä½æãã¾ãã =OFFSET(B6,$A$3,0) // æ°å¼ãã³ãã¼ãã¦æ¨ªã«åæ ããããã®ã§ãã»ã«A3ã«é¢ãã¦ã¯çµ¶å¯¾åç §ã«ãã¦ãã¾ãã // å¼æ°ã®[é«ã]ã¨[å¹ ]ã¯ä»åã¯çç¥ãã¦ãã¾ãã // ã»ã«B6ãåºæºã«ãæå®
![ãExcelãã¹ãã³ãã¿ã³ã§ãã¼ã¿æ½åº | ITäºå~ITã§å¹çåããäºåç¥è~](https://cdn-ak-scissors.b.st-hatena.com/image/square/a81706f01da633d49962fb3549657ea549044c7f/height=288;version=1;width=512/https%3A%2F%2Fit-yobi.com%2Fwp-content%2Fuploads%2F2023%2F06%2Fit-yobi.png)
{{#tags}}- {{label}}
{{/tags}}