{"id":698,"date":"2015-01-25T15:15:33","date_gmt":"2015-01-25T06:15:33","guid":{"rendered":"http:\/\/frsw.net\/blog\/?p=698"},"modified":"2015-01-25T15:17:44","modified_gmt":"2015-01-25T06:17:44","slug":"advancedfilter%e3%82%92%e4%bd%bf%e3%81%84%e3%81%93%e3%81%aa%e3%81%99%e6%8a%bd%e5%87%ba%e6%9d%a1%e4%bb%b6%e7%b7%a8","status":"publish","type":"post","link":"http:\/\/frsw.net\/blog\/advancedfilter%e3%82%92%e4%bd%bf%e3%81%84%e3%81%93%e3%81%aa%e3%81%99%e6%8a%bd%e5%87%ba%e6%9d%a1%e4%bb%b6%e7%b7%a8\/","title":{"rendered":"AdvancedFilter(\u62bd\u51fa\u6761\u4ef6\u7de8)"},"content":{"rendered":"<p>Excel\u306eVBA\uff08\u30a8\u30af\u30bb\u30eb\u3000\u30de\u30af\u30ed\uff09\u3067AdvancedFilter\u3092\u7528\u3044\u308b\u969b\u3001\u3046\u307e\u3044\u5177\u5408\u306b\u8907\u6570\u306e\u6761\u4ef6\u3092\u7528\u3044\u3066\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n<p><!--more--><\/p>\n<p>AdvancedFilter\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<p><code>Range(\"A7:E17\").CurrentRegion.AdvancedFilter _<\/code><br \/>\n<code> Action:=xlFilterInPlace, _<\/code><br \/>\n<code> CriteriaRange:=Range(\"B1:E3\"), _<\/code><br \/>\n<code> Unique:=False<\/code><\/p>\n<p>\u3053\u306e\u6642\u826f\u304f\u308f\u304b\u3089\u306a\u3044\u306e\u304c\u3001CriteriaRange\u3067\u6307\u5b9a\u3059\u308b\u300cAND\u6761\u4ef6\u300d\u3068\u300cOR\u6761\u4ef6\u300d\u306e\u8a18\u8ff0\u306e\u4ed5\u65b9\u3067\u3059\u3002<br \/>\n(\u81ea\u5206\u306f\u5206\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002)<\/p>\n<p>\u7d50\u8ad6\u304b\u3089\u8a00\u3046\u3068\u3001<br \/>\nAND\u6761\u4ef6\u306f\u6a2a\u306b\u4e00\u884c\u306b\u307e\u3068\u3081\u3066\u66f8\u304f<br \/>\nOR\u6761\u4ef6\u306f\u7e26\u306b\u4e26\u3079\u3066\u66f8\u304f<br \/>\n\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u793e\u54e1\u306e\u8868\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b\u3053\u3068\u3092\u8003\u3048\u307e\u3059\u3002<\/p>\n<p><a href=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/sampledata.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-693\" src=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/sampledata.png\" alt=\"sampledata\" width=\"397\" height=\"377\" srcset=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/sampledata.png 397w, http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/sampledata-300x285.png 300w\" sizes=\"(max-width: 397px) 100vw, 397px\" \/><\/a><\/p>\n<p>\u3053\u3053\u3067\u3001<br \/>\n(\u5e74\u53ce\u304c1000\u4e07\u5186\u3000AND\u3000\u5e74\u53ce\u304c800\u4e07\u5186) OR (\u4f4f\u6240\u304c\u9752\u5c71\u3000AND\u3000\u6027\u5225\u304c\u7537)<br \/>\n\u3068\u3044\u3046\u6761\u4ef6\u3067\u62bd\u51fa\u3057\u305f\u3044\u5834\u5408\u3001\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u306e\u3088\u3046\u306bCriteriaRange\u3067&#8221;B1:E3&#8243;\u3092\u6307\u5b9a\u3057\u3066\u3084\u308b\u3068\u3001<br \/>\n\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u76ee\u7684\u306e\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/fil.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-694\" src=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/fil.png\" alt=\"fil\" width=\"406\" height=\"259\" srcset=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/fil.png 406w, http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/fil-300x191.png 300w\" sizes=\"(max-width: 406px) 100vw, 406px\" \/><\/a><\/p>\n<p>\u3053\u3053\u3067\u3001\u62bd\u51fa\u6761\u4ef6\u306b\u3057\u3066\u3044\u3057\u305f\u300c&#8221;B1:E3&#8243;\u300d\u3092\u7d30\u304b\u304f\u898b\u3066\u307f\u307e\u3059\u3002<br \/>\n\u9805\u76ee\u306f\u30d8\u30c3\u30c0\u3067\u4e00\u62ec\u3067\u7ba1\u7406\u3057\u3066\u3001\u7e26\u65b9\u5411\u306b\u6761\u4ef6\u5f0f\uff08\u56f2\u308f\u308c\u305f\u90e8\u5206\uff09\u304cOR\u3067\u3064\u306a\u304c\u3063\u3066\u3044\u304f\u3068\u3044\u3046\u611f\u3058\u3067\u3059\u3002<\/p>\n<p><a href=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/setumei.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-695\" src=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/setumei.jpg\" alt=\"setumei\" width=\"960\" height=\"720\" srcset=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/setumei.jpg 960w, http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/setumei-300x225.jpg 300w, http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/setumei-788x591.jpg 788w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/a><\/p>\n<p>OR\u6761\u4ef6\u306f\u7e26\u306b\u5897\u3084\u3057\u3066\u3044\u304d\u3001AND\u6761\u4ef6\u306f\u6a2a\u5897\u3084\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br \/>\n\u4ee5\u4e0b\u306b\u6761\u4ef6\u4f8b\u3092\u3044\u304f\u3064\u304b\u3042\u3052\u307e\u3059\u3002<\/p>\n<ul>\n<li>\uff08\u5e74\u53ce\u304c\u300c1000\u300d\u3000AND\u3000\u6027\u5225\u304c\u300c\u7537\u300d\uff09\u3000OR\u3000\uff08\u5e74\u53ce\u304c\u300c1000\u300d\u3000AND\u3000\u6027\u5225\u304c\u300c\u5973\u300d\uff09<br \/>\n\u21d2CriteriaRange:=Range(&#8220;B1:E3&#8221;)\u3068\u3057\u3066<br \/>\n<a href=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/ex1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696\" src=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/ex1.png\" alt=\"ex1\" width=\"415\" height=\"124\" srcset=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/ex1.png 415w, http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/ex1-300x90.png 300w\" sizes=\"(max-width: 415px) 100vw, 415px\" \/><\/a><\/li>\n<li>\uff08\u5e74\u53ce\u304c\u300c1000\u300d\u3000AND\u3000\u6027\u5225\u304c\u300c\u7537\u300d\uff09\u3000OR\u3000\uff08\u5e74\u53ce\u304c\u300c1000\u300d\u3000AND\u3000\u6027\u5225\u304c\u300c\u5973\u300d\uff09<br \/>\nOR\u3000\uff08\u5e74\u53ce\u304c\u300c500\u300d\u3000AND\u3000\u4f4f\u6240\u304c\u300c\u79cb\u8449\u539f\u300d\uff09<br \/>\n\u21d2CriteriaRange:=Range(&#8220;B1:E4&#8221;)\u3068\u3057\u3066<br \/>\n<a href=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/ex2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-697\" src=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/ex2.png\" alt=\"ex2\" width=\"400\" height=\"145\" srcset=\"http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/ex2.png 400w, http:\/\/frsw.net\/blog\/wp-content\/uploads\/2015\/01\/ex2-300x109.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/a><\/li>\n<\/ul>\n<p>\u4e00\u822c\u5316\u3059\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u5f62\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td>\u9805\u76eex<\/td>\n<td>\u9805\u76eey<\/td>\n<td>\u9805\u76eez<\/td>\n<td>\u2026<\/td>\n<\/tr>\n<tr>\n<td>\u6761\u4ef6\u5f0f1<\/td>\n<td>x1<\/td>\n<td>y1<\/td>\n<td>z1<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>\u6761\u4ef6\u5f0f2<\/td>\n<td>x2<\/td>\n<td>y2<\/td>\n<td>z2<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>\u2026<\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u3068\u3044\u3063\u305f\u8868\u3092\u6307\u5b9a\u3059\u308b\u3068\u3001<br \/>\n\u6761\u4ef6\u5f0f1(x1 AND y1 AND z1 AND \u2026)<br \/>\nOR\u3000\u6761\u4ef6\u5f0f2(x2 AND y2 AND z2 AND\u2026)<br \/>\nOR\u3000\u2026<\/p>\n<p>\u3068\u3044\u3046\u611f\u3058\u3067\u3059\u3002<\/p>\n<p>\u3061\u3087\u3063\u3068\u96e3\u3057\u3044\u3067\u3059\u3088\u306d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u306eVBA\uff08\u30a8\u30af\u30bb\u30eb\u3000\u30de\u30af\u30ed\uff09\u3067AdvancedFilter\u3092\u7528\u3044\u308b\u969b\u3001\u3046\u307e\u3044\u5177\u5408\u306b\u8907\u6570\u306e\u6761\u4ef6\u3092\u7528\u3044\u3066\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,4],"tags":[28],"_links":{"self":[{"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/posts\/698"}],"collection":[{"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/comments?post=698"}],"version-history":[{"count":3,"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/posts\/698\/revisions"}],"predecessor-version":[{"id":701,"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/posts\/698\/revisions\/701"}],"wp:attachment":[{"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/media?parent=698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/categories?post=698"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/frsw.net\/blog\/wp-json\/wp\/v2\/tags?post=698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}