{"id":1091,"date":"2023-06-21T06:06:59","date_gmt":"2023-06-20T21:06:59","guid":{"rendered":"https:\/\/beiyan-tool.info\/?p=1091"},"modified":"2023-06-21T06:06:59","modified_gmt":"2023-06-20T21:06:59","slug":"excel%e3%80%80filter%e9%96%a2%e6%95%b0%e3%81%a7%e6%a4%9c%e7%b4%a2%e5%af%be%e8%b1%a1%e3%81%ae%e5%80%a4%e3%81%8c%e5%ad%98%e5%9c%a8%e3%81%99%e3%82%8b%e3%81%ae%e3%81%ab%e3%80%8cn-a%e3%80%8d%e3%81%a8","status":"publish","type":"post","link":"https:\/\/beiyan-tool.info\/?p=1091","title":{"rendered":"Excel\u3000FILTER\u95a2\u6570\u3067\u691c\u7d22\u5bfe\u8c61\u306e\u5024\u304c\u5b58\u5728\u3059\u308b\u306e\u306b\u300c#N\/A\u300d\u3068\u306a\u3063\u3066\u3057\u307e\u3046\u539f\u56e0\u3068\u5bfe\u51e6\u6cd5"},"content":{"rendered":"<p>Excel\u306eFILTER\u95a2\u6570\u3092\u4f7f\u3046\u3068\u304d\u306b\u3001\u691c\u7d22\u5bfe\u8c61\u306e\u5024\u304c\u5b58\u5728\u3059\u308b\u306e\u306b\u300c#N\/A\u300d\u3068\u306a\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>A\u5217 B\u5217<br \/>\n\u756a\u53f7 \u540d\u524d<br \/>\n1 aaa<br \/>\n2 #N\/A<br \/>\n3 bbb<br \/>\n4 #N\/A<br \/>\n5 ccc<\/p>\n<p>\u4e0a\u306e\u8868\u3067\u3001<br \/>\n=FILTER(A:A,B:B=&#8221;aaa&#8221;,&#8221;&#8221;)<br \/>\n\u3068\u3059\u308b\u3068\u3001\u300c#N\/A\u300d\u3068\u306a\u308a\u307e\u3059\u3002<br \/>\n\u3053\u306e\u539f\u56e0\u306fB\u5217\u306b\u300c#N\/A\u300d\u304c\u5b58\u5728\u3059\u308b\u304b\u3089\u3067\u3059\u3002<\/p>\n<p>\u3061\u306a\u307f\u306b\u3001B\u5217\u306b\u300c#VALUE!\u300d\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u3001FILTER\u95a2\u6570\u306f\u300c#VALUE!\u300d\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>A\u5217 B\u5217<br \/>\n\u756a\u53f7 \u540d\u524d<br \/>\n1 aaa<br \/>\n2 #VALUE!<br \/>\n3 bbb<br \/>\n4 #N\/A<br \/>\n5 ccc<\/p>\n<p>\u6b21\u306e\u3088\u3046\u306b\u3001\u4e21\u65b9\u3042\u308b\u5834\u5408\u306f\u3001\u300c#N\/A\u300d\u3068\u306a\u308b\u306e\u3067\u3001<br \/>\n\u304a\u305d\u3089\u304f\u3001\u4e0a\u306b\u3042\u308b\u30a8\u30e9\u30fc\u304cFILTER\u95a2\u6570\u3067\u5e30\u3063\u3066\u304f\u308b\u306e\u3060\u3068\u601d\u308f\u308c\u307e\u3059\u3002<\/p>\n<p>A\u5217 B\u5217<br \/>\n\u756a\u53f7 \u540d\u524d<br \/>\n4 #N\/A<br \/>\n2 #VALUE!<br \/>\n3 bbb<br \/>\n1 aaa<br \/>\n5 ccc<\/p>\n<p>\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u5bfe\u51e6\u6cd5\u306fFILTER\u95a2\u6570\u306e\u6761\u4ef6\u306e\u5bfe\u8c61\u3068\u306a\u308b\u5217\u306f\u5168\u3066\u30a8\u30e9\u30fc\u304c\u306a\u3044\u72b6\u614b\u306b\u3057\u3066\u304a\u3051\u3070\u3088\u3044\u3068\u3044\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u306eFILTER\u95a2\u6570\u3092\u4f7f\u3046\u3068\u304d\u306b\u3001\u691c\u7d22\u5bfe\u8c61\u306e\u5024\u304c\u5b58\u5728\u3059\u308b\u306e\u306b\u300c#N\/A\u300d\u3068\u306a\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002 A\u5217 B\u5217 \u756a\u53f7 \u540d\u524d 1 aaa 2 #N\/A 3 bbb 4 #N\/A 5 ccc  &#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-1091","post","type-post","status-publish","format-standard","hentry","category-windows"],"_links":{"self":[{"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/posts\/1091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1091"}],"version-history":[{"count":1,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/posts\/1091\/revisions"}],"predecessor-version":[{"id":1092,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/posts\/1091\/revisions\/1092"}],"wp:attachment":[{"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}