{"id":364,"date":"2019-08-06T00:22:08","date_gmt":"2019-08-05T15:22:08","guid":{"rendered":"https:\/\/elelog.net\/?p=364"},"modified":"2020-06-14T14:45:19","modified_gmt":"2020-06-14T05:45:19","slug":"%e3%80%90excel%e3%80%91%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e9%96%93%e5%bc%95%e3%81%8f%e6%96%b9%e6%b3%95%e3%83%bb%e3%81%9f%e3%81%8f%e3%81%95%e3%82%93%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%81%8b","status":"publish","type":"post","link":"https:\/\/elelog.net\/?p=364","title":{"rendered":"\u3010Excel\u3011\u30c7\u30fc\u30bf\u3092\u9593\u5f15\u304f\u65b9\u6cd5\u30fb\u305f\u304f\u3055\u3093\u306e\u30c7\u30fc\u30bf\u304b\u3089\u7b49\u9593\u9694\u3067\u62bd\u51fa\u3059\u308b\u65b9\u6cd5\u30fcINDIRECT\u95a2\u6570"},"content":{"rendered":"

\u5f97\u3089\u308c\u308b\u60c5\u5831<\/h2>\n

INDIRECT\u95a2\u6570\u3092\u7528\u3044\u3066\u305f\u304f\u3055\u3093\u306e\u30c7\u30fc\u30bf\u304b\u3089\u9593\u5f15\u3044\u305f\u5024\u3092\u62bd\u51fa\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n

\u307e\u3068\u3081<\/h2>\n\"\"\n

\u7d50\u8ad6\u304b\u3089\u8ff0\u3079\u308b\u3068\u3001\u753b\u50cf\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3059\u308c\u3070\u9593\u5f15\u3044\u305f\u5024\u3092\u4e26\u3079\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002\u753b\u50cf\u306b\u304a\u3044\u3066\u8272\u3068\u6587\u7ae0\u304c\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u30b3\u30d4\u30da\u7528<\/p>\n

=INDIRECT(\"V\"&ROW(A1)*3)<\/p><\/blockquote>\n

\u4ed5\u7d44\u307f<\/h2>\n

\u753b\u50cf\u306b\u632f\u3089\u308c\u3066\u3044\u308b\u2460\u301c\u2464\u306e\u756a\u53f7\u306b\u5bfe\u5fdc\u3055\u305b\u3066\u4ed5\u7d44\u307f\u3092\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n

    \n
  1. INDIRECT\u95a2\u6570(\u4ed6\u306e\u30bb\u30eb\u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092\u305d\u306e\u307e\u307e\u5f15\u3063\u5f35\u3063\u3066\u304f\u308b\u95a2\u6570)\u3092\u7528\u3044\u3066\u30c7\u30fc\u30bf\u3092\u53c2\u7167\u3057\u307e\u3059\u3002<\/li>\n
  2. \"\u00a0 \"\u3067\u9593\u5f15\u304d\u305f\u3044\u30c7\u30fc\u30bf\u306e\u3042\u308b\u5217\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n
  3. \uff06\u3000\u3067\u5de6\u53f3\u306e\u6587\u5b57\u5217\u3092\u7d50\u5408\u3055\u305b\u3001\uff11\u3064\u306e\u6587\u5b57\u5217\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/li>\n
  4. ROW\u95a2\u6570(()\u5185\u306b\u3042\u308b\u30bb\u30eb\u304c\u4f55\u884c\u76ee\u304b\u3092\u77e5\u3089\u305b\u308b\u95a2\u6570)\u3092\u7528\u3044\u3066\u4f55\u884c\u76ee\u304b\u3068\u3044\u3046\u884c\u6570\u306e\u307f\u306e\u5024\u3092\u53d6\u308a\u51fa\u3057\u307e\u3059\u3002<\/li>\n
  5. \u884c\u6570\u306e\u60c5\u5831\u3092N\u500d\u3057\u307e\u3059\u3002\u753b\u50cf\u3067\u306f3\u500d\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/li>\n<\/ol>\n

    \u3064\u307e\u308a\u3001ROW\u95a2\u6570\u3067\u4f55\u884c\u76ee\u304b\u3068\u3044\u3046\u884c\u6570\u3060\u3051\u306e\u6570\u5024\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3057\u3001\u305d\u308c\u3092\u9593\u5f15\u304d\u305f\u3044\u500d\u6570\u306bN\u500d\u3057\u307e\u3059\u3002\u305d\u306e\u884c\u30c7\u30fc\u30bf\u3068\u3001\u672c\u6765\u9593\u5f15\u304d\u305f\u3044\u30c7\u30fc\u30bf\u306e\u3042\u308b\u5217\u306e\u6587\u5b57\u3092\u7d50\u5408\u3055\u305b\u308b\u3053\u3068\u30671\u3064\u306e\u30bb\u30eb\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u3066\u3044\u307e\u3059\u3002<\/p>\n

    \n
    \n
    <\/a><\/div>\n
    \n
    Excel \u6700\u5f37\u306e\u6559\u79d1\u66f8\uff3b\u5b8c\u5168\u7248\uff3d\u2015\u2015\u3059\u3050\u306b\u4f7f\u3048\u3066\u3001\u4e00\u751f\u5f79\u7acb\u3064\u300c\u6210\u679c\u3092\u751f\u307f\u51fa\u3059\u300d\u8d85\u30a8\u30af\u30bb\u30eb\u4ed5\u4e8b\u8853<\/a><\/div>\n
    Excel\u3068\u4e0a\u624b\u306b\u4ed8\u304d\u5408\u3044\u305f\u3044\u3042\u306a\u305f\u306b\u306f\u3053\u306e\u4e00\u518a\u3002<\/div>\n
    Amazon<\/a><\/div>
    Kindle<\/a><\/div>
    \u697d\u5929<\/a><\/div>
    \u697d\u5929Kobo<\/a><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

    \u5f97\u3089\u308c\u308b\u60c5\u5831 INDIRECT\u95a2\u6570\u3092\u7528\u3044\u3066\u305f\u304f\u3055\u3093\u306e\u30c7\u30fc\u30bf\u304b\u3089\u9593\u5f15\u3044\u305f\u5024\u3092\u62bd\u51fa\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u307e\u3068\u3081 \u7d50\u8ad6\u304b\u3089\u8ff0\u3079\u308b\u3068\u3001\u753b\u50cf\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3059\u308c\u3070\u9593\u5f15\u3044\u305f\u5024\u3092\u4e26\u3079\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002\u753b\u50cf\u306b\u304a\u3044\u3066\u8272\u3068\u6587\u7ae0\u304c\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059…<\/p>\n","protected":false},"author":1,"featured_media":372,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[42,41],"class_list":{"0":"post-364","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-office365","8":"tag-excel","9":"tag-office-365","10":"article cf"},"_links":{"self":[{"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/posts\/364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=364"}],"version-history":[{"count":6,"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions"}],"predecessor-version":[{"id":463,"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions\/463"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/media\/372"}],"wp:attachment":[{"href":"https:\/\/elelog.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}