{"id":10563,"date":"2017-05-17T01:16:39","date_gmt":"2017-05-16T16:16:39","guid":{"rendered":"http:\/\/www.e-nekorakuen.net\/?p=10563"},"modified":"2020-08-28T02:05:56","modified_gmt":"2020-08-27T17:05:56","slug":"excel20132016%e5%8f%82%e7%85%a7%e5%85%88%e3%82%b7%e3%83%bc%e3%83%88%e4%b8%8a%e3%81%ae%e8%a1%a8%e3%81%ae%e8%a1%8c%e5%88%97%e8%bf%bd%e5%8a%a0%e3%83%bb%e5%89%8a%e9%99%a4%e3%81%ab%e8%bf%bd","status":"publish","type":"post","link":"https:\/\/www.e-nekorakuen.net\/?p=10563","title":{"rendered":"Excel2013,2016\u2026\u53c2\u7167\u5148\u30b7\u30fc\u30c8\u4e0a\u306e\u8868\u306e\u884c\u5217\u8ffd\u52a0\u30fb\u524a\u9664\u306b\u8ffd\u5f93\u3059\u308b\u30ea\u30f3\u30af\u8cbc\u308a\u4ed8\u3051"},"content":{"rendered":"<p>\u30d6\u30c3\u30af1\u306e\u30b7\u30fc\u30c8\u4e0a\u306e\u8868\u3092\u30d6\u30c3\u30af2\u306e\u30b7\u30fc\u30c8\u306b\u30ea\u30f3\u30af\u8cbc\u308a\u4ed8\u3051\u3059\u308b\u3068\u3001\u30d6\u30c3\u30af1\u306e\u30b7\u30fc\u30c8\u4e0a\u306e\u8868\u306e\u5024\u306e\u5909\u66f4\u304c\u5373\u5ea7\u306b\u30d6\u30c3\u30af2\u306e\u8868\u306b\u53cd\u6620\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u3053\u308c\u3067\u4fbf\u5229\u306a\u306e\u3067\u3059\u304c\u3001\u30d6\u30c3\u30af1\u306e\u8868\u306e\u884c\u5217\u3092\u8ffd\u52a0\u30fb\u524a\u9664\u3057\u305f\u5834\u5408\u306f\u30d6\u30c3\u30af2\u306e\u8868\u306b\u53cd\u6620\u3057\u306a\u3044\u305f\u3081\u3001\u30ea\u30f3\u30af\u3092\u518d\u8a2d\u5b9a\u3057\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002OFFSET\u8cbc\u308a\u4ed8\u3051\u3092\u7528\u3044\u308b\u3053\u3068\u3067\u3001\u884c\u5217\u306e\u8ffd\u52a0\u30fb\u524a\u9664\u306b\u8ffd\u5f93\u3059\u308b\u30ea\u30f3\u30af\u8cbc\u308a\u4ed8\u3051\u304c\u53ef\u80fd\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li>\u30d6\u30c3\u30af1\u306e\u30b7\u30fc\u30c81<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10568\" src=\"http:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2017\/05\/link1-1.jpg\" alt=\"\" width=\"271\" height=\"151\" \/><div class=\"su-spacer\" style=\"height:10px\"><\/div>\n\u30d6\u30c3\u30af2\u306e\u30b7\u30fc\u30c81\u2026\u5de6\u5074\u304c\u30ea\u30f3\u30af\u8cbc\u308a\u4ed8\u3051\u3001\u53f3\u5074\u304cOFFSET\u8cbc\u308a\u4ed8\u3051<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10570\" src=\"http:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2017\/05\/offset1-1-300x93.jpg\" alt=\"\" width=\"355\" height=\"110\" srcset=\"https:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2017\/05\/offset1-1-300x93.jpg 300w, https:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2017\/05\/offset1-1.jpg 649w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/li>\n<li>\u30d6\u30c3\u30af1\u306e\u30b7\u30fc\u30c81\u306b\u884c\u3092\u633f\u5165\u3057\u307e\u3059\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10569\" src=\"http:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2017\/05\/link2-1.jpg\" alt=\"\" width=\"271\" height=\"176\" \/><div class=\"su-spacer\" style=\"height:10px\"><\/div>\n\u30d6\u30c3\u30af2\u306e\u30b7\u30fc\u30c81\u2026\u5de6\u5074\u304c\u30ea\u30f3\u30af\u8cbc\u308a\u4ed8\u3051\u3001\u53f3\u5074\u304cOFFSET\u8cbc\u308a\u4ed8\u3051<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10571\" src=\"http:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2017\/05\/offset2-300x93.jpg\" alt=\"\" width=\"355\" height=\"110\" srcset=\"https:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2017\/05\/offset2-300x93.jpg 300w, https:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2017\/05\/offset2.jpg 649w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/li>\n<\/ul>\n<p>\u30ea\u30f3\u30af\u8cbc\u308a\u4ed8\u3051\u306e\u65b9\u306f\u3001\u884c\u306e\u633f\u5165\u304c\u53cd\u6620\u3057\u307e\u305b\u3093\u304c\u3001OFFSET\u8cbc\u308a\u4ed8\u3051\u306e\u65b9\u306f\u884c\u306e\u633f\u5165\u304c\u53cd\u6620\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\nOFFSET\u53c2\u7167\u306e\u4ed5\u65b9\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n<p><span style=\"font-size: 10pt;\">F2=IF(OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(F2)-2,0)=&#8221;&#8221;,&#8221;&#8221;,OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(F2)-2,0))<\/span><br \/>\n<span style=\"font-size: 10pt;\"> G2=IF(OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(G2)-2,1)=&#8221;&#8221;,&#8221;&#8221;,OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(G2)-2,1))<\/span><br \/>\n<span style=\"font-size: 10pt;\"> H2=IF(OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(H2)-2,2)=&#8221;&#8221;,&#8221;&#8221;,OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(H2)-2,2))<\/span><br \/>\n<span style=\"font-size: 10pt;\"> I3=IF(OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(I2)-2,3)=&#8221;&#8221;,&#8221;&#8221;,OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(I2)-2,3))<\/span><br \/>\n<span style=\"font-size: 10pt;\"> F3=IF(OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(F3)-2,0)=&#8221;&#8221;,&#8221;&#8221;,OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(F3)-2,0))<\/span><br \/>\n<span style=\"font-size: 10pt;\"> G3=IF(OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(G3)-2,1)=&#8221;&#8221;,&#8221;&#8221;,OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(G3)-2,1))<\/span><br \/>\n<span style=\"font-size: 10pt;\"> H3=IF(OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(H3)-2,2)=&#8221;&#8221;,&#8221;&#8221;,OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(H3)-2,2))<\/span><br \/>\n<span style=\"font-size: 10pt;\"> I3=IF(OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(I3)-2,3)=&#8221;&#8221;,&#8221;&#8221;,OFFSET([Book1.xlsx]Sheet1!$A$1,ROW(I3)-2,3))<\/span><br \/>\n<span style=\"font-size: 10pt;\"> \uff08\u4ee5\u4e0b\u7d9a\u304f\uff09<\/span><\/p>\n<p>\u203b\u30ea\u30f3\u30af\u5148\u306e\u30bb\u30eb\u304c\u7a7a\u767d\u3067\u7121\u3044\u5834\u5408\u306b\u3001SA$1\u3092\u8d77\u70b9\u3068\u3057\u3066OFFSET\u95a2\u6570\u3067\u30bb\u30eb\u306e\u5024\u3092\u6301\u3063\u3066\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30d6\u30c3\u30af1\u306e\u30b7\u30fc\u30c8\u4e0a\u306e\u8868\u3092\u30d6\u30c3\u30af2\u306e\u30b7\u30fc\u30c8\u306b\u30ea\u30f3\u30af\u8cbc\u308a\u4ed8\u3051\u3059\u308b\u3068\u3001\u30d6\u30c3&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":10568,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","_veu_custom_css":"","veu_display_promotion_alert":"","footnotes":""},"categories":[25,23,68],"tags":[],"class_list":["post-10563","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-office","category-pc","category-68"],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/posts\/10563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10563"}],"version-history":[{"count":0,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/posts\/10563\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/media\/10568"}],"wp:attachment":[{"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}