{"id":318,"date":"2014-02-09T15:04:21","date_gmt":"2014-02-09T06:04:21","guid":{"rendered":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/?p=318"},"modified":"2026-04-01T17:13:33","modified_gmt":"2026-04-01T08:13:33","slug":"address","status":"publish","type":"post","link":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/2014\/02\/address.html","title":{"rendered":"\uff08\uff12\uff16\uff12\uff09Excel\u3067\u5e38\u306b\u6700\u65b0\u306e\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u65b9\u6cd5\uff5eINDIRECT\u95a2\u6570\u3068COUNTA\u95a2\u6570\uff5e"},"content":{"rendered":"

\"newcom_cafecs4.jpg\"\u307f\u306a\u3055\u307e\u3001\u3053\u3093\u306b\u3061\u306f\uff01
\u30e2\u30ab\u3067\u3059\u3002
\u304a\u5143\u6c17\u3067\u3059\u304b\uff1f<\/p>\n

\u96ea\u304c\u305f\uff5e\u304f\u3055\u3093\u3001\u3075\u308a\u307e\u3057\u305f\u3041\uff01<\/p>\n

\"P1010980.jpg\"<\/a><\/span><\/p>\n

\u304b\u308f\u3044\u3044\u96ea\u3060\u308b\u307e\u304c\u3042\u3061\u3089\u3053\u3061\u3089\u306b\u266a<\/p>\n

\u306a\u3093\u3060\u304b\u697d\u3057\u3044\u6c17\u6301\u3061\u306b\u306a\u308a\u307e\u3059\u3002
\u96ea\u3063\u3066\u266a<\/p>\n

\u5b50\u4f9b\u306e\u3053\u308d\u306b\u904a\u3093\u3060\u8a18\u61b6\u304c\u8607\u308b\u304b\u3089\u304b\u306a\u30fb\u30fb\u30fb\uff3e\uff3e<\/p>\n

\u96fb\u8eca\u304c\u9045\u308c\u305f\u308a\u3057\u307e\u3057\u305f\u304c\u3001\u4f55\u3068\u304b\u52d5\u3044\u3066\u304f\u308c\u3066\u3066\u3001
\u9664\u96ea\u4f5c\u696d\u3057\u3066\u304f\u3060\u3055\u3063\u305f\u65b9\u306b\u611f\u8b1d\u3057\u307e\u3059\u266a<\/p>\n

\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605\u2606\u2605<\/p>\n

Excel\u3067<\/span>\u5e38\u306b<\/span>\u6700\u65b0\u306e\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u65b9\u6cd5<\/span><\/b>\uff5eINDIR<\/span>ECT\u95a2\u6570\u3068COUNTA\u95a2\u6570\uff5e<\/span><\/h2>\n

\u6bce\u65e5\u66f4\u65b0\u3055\u308c\u308b\u5728\u5eab\u6570\u3084\u58f2\u4e0a\u30c7\u30fc\u30bf\u3002
\u3059\u3050\u306b\u6700\u65b0\u306e\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3057\u305f\u3044\u3001\u3068\u3044\u3046\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3088\u306d\u3002<\/p>\n

\u95a2\u6570\u3092\u4f7f\u3063\u3066\u7c21\u5358\u306b\u628a\u63e1\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3088\u3002
\u3067\u306f\u3001\u3054\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\uff5e\u3059\uff01<\/p>\n

\uff11\uff0e\u58f2\u4e0a\u306e\u30c7\u30fc\u30bf\u304c\u6bce\u65e5\u5165\u529b\uff08\u66f4\u65b0\uff09\u3055\u308c\u3066\u3044\u304f\u8868\u304c\u3042\u308a\u307e\u3059\u3002
\u76f4\u8fd1\u306e\u30c7\u30fc\u30bf\u3092\u53f3\u4e0a\u306b\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n

\"saishin1.jpg\"<\/a><\/span><\/p>\n

\uff12\uff0e\u95a2\u6570\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002
=INDIRECT(“B”&COUNTA(B:B))<\/b><\/span>
\u203bCOUNTA\u95a2\u6570\u306fB\u5217\u306e\u30c7\u30fc\u30bf\u306e\u6570\u3092\u6c42\u3081\u3066\u3044\u307e\u3059\u3002
INDIRECT\u95a2\u6570\u306f\u300cB11\u300d\u306e\u30bb\u30eb\u306e\u5024\u3092\u6c42\u3081\u3066\u3044\u307e\u3059\u3002<\/p>\n

\"saishin2.jpg\"<\/a><\/span><\/p>\n

\uff13\uff0e\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\uff08\u8ffd\u52a0\u5165\u529b\uff09\u3057\u3066\u307f\u307e\u3059\u30022\/11\u306b\u300c123456\u300d\u3068\u5165\u529b\u3057\u3066Enter\u3092\u62bc\u3059\u3068\u30fb\u30fb\u30fb<\/p>\n

\"saishin3.jpg\"<\/a><\/span><\/p>\n

\u00a0<\/div>\n
\uff14\uff0e\u76f4\u8fd1\u306e\u30c7\u30fc\u30bf\u304c\u5909\u308f\u308a\u307e\u3057\u305f\u3002
\"saishin4.jpg\"<\/a><\/span>\n

\u4fbf\u5229\u3067\u3059\u3088\u306d\u3002<\/p>\n

\u3061\u306a\u307f\u306b\u3001\u4eca\u56de\u3054\u7d39\u4ecb\u3057\u305f\u300cINDIRECT\u95a2\u6570\u300d\u306f\u3001\u4ee5\u524d\u306b\u3082\u3054\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u3002
\uff08\uff11\uff10\uff15\uff09\u30ea\u30b9\u30c8\u306e\u5185\u5bb9\u3092\u5207\u308a\u66ff\u3048\u305f\u3044\u266a\u540d\u524d\u5b9a\u7fa9\u3068INDIRECT\u95a2\u6570\u266a<\/a>
\uff08\uff11\uff15\uff13\uff09\u90e8\u7f72\u540d\u3068\u9023\u52d5\u3057\u3066\u30e1\u30f3\u30d0\u30fc\u306e\u30ea\u30b9\u30c8\u3092\u8868\u793a\u3059\u308b\uff5e\u5165\u529b\u898f\u5247\u3068INDIRECT\u95a2\u6570\uff5e<\/a><\/p>\n

\u3068\u3063\u3066\u3082\u4fbf\u5229\u306a\u91cd\u5b9d\u3059\u308b\u95a2\u6570\u3067\u3059\u306e\u3067\u3001\u305c\u3072\u4f7f\u3063\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<\/div>\n

\u00a0<\/div>\n
\n
\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606\u30fb\u30fb\u30fb\u2606\u2606\u2606 \u524d\u306e\u8a18\u4e8b<\/a> \u2606\u2606<\/pre>\n<\/div>\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u307f\u306a\u3055\u307e\u3001\u3053\u3093\u306b\u3061\u306f\uff01\u30e2\u30ab\u3067\u3059\u3002\u304a\u5143\u6c17\u3067\u3059\u304b\uff1f \u96ea\u304c\u305f\uff5e\u304f\u3055\u3093\u3001\u3075\u308a\u307e\u3057\u305f\u3041\uff01 \u304b\u308f\u3044\u3044\u96ea\u3060\u308b\u307e\u304c\u3042\u3061\u3089\u3053\u3061\u3089\u306b\u266a \u306a\u3093\u3060\u304b\u697d\u3057\u3044\u6c17\u6301\u3061\u306b\u306a\u308a\u307e\u3059\u3002\u96ea\u3063\u3066\u266a \u5b50\u4f9b\u306e\u3053\u308d\u306b\u904a\u3093\u3060\u8a18\u61b6\u304c\u8607\u308b\u304b\u3089\u304b\u306a\u30fb\u30fb\u30fb\uff3e\uff3e \u96fb\u8eca\u304c\u9045\u308c\u305f\u308a […]<\/p>\n","protected":false},"author":2,"featured_media":2533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-318","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/comments?post=318"}],"version-history":[{"count":3,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/318\/revisions"}],"predecessor-version":[{"id":3555,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/318\/revisions\/3555"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media\/2533"}],"wp:attachment":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media?parent=318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/categories?post=318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/tags?post=318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}