{"id":1425,"date":"2022-02-22T00:09:25","date_gmt":"2022-02-21T15:09:25","guid":{"rendered":"https:\/\/coralnet.co.jp\/wordpress\/?p=1425"},"modified":"2022-02-23T23:54:54","modified_gmt":"2022-02-23T14:54:54","slug":"%e3%80%90excel%e3%80%91%e6%96%87%e5%ad%97%e5%88%97%e6%a4%9c%e7%b4%a2%e3%81%a7value%e3%81%ab%e3%81%aa%e3%82%8b%e3%81%a8%e3%81%8d","status":"publish","type":"post","link":"https:\/\/coralnet.co.jp\/wordpress\/?p=1425","title":{"rendered":"\u3010\u30a8\u30af\u30bb\u30eb\u3011\u6587\u5b57\u5217\u691c\u7d22\u3067#VALUE\u306b\u306a\u308b\u3068\u304d"},"content":{"rendered":"\n<p class=\"has-medium-font-size wp-block-paragraph\">\u30a8\u30af\u30bb\u30eb\u3067\u6587\u5b57\u5217\u691c\u7d22\u3059\u308b\u95a2\u6570\u306f\u3000FIND\/FINDB\u3084SERCH\/SERCHB\u3000\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u691c\u7d22\u7d50\u679c\u304c\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3057\u305f\u3002\u7c21\u5358\u306a\u5f0f\u3067\u3001\u6587\u5b57\u5217\u3082\u4e00\u81f4\u3057\u3066\u3044\u308b\u306e\u306b\u306a\u305c\u304b\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u306e\u3067\u305d\u306e\u6642\u306e\u3053\u3068\u3092\u30e1\u30e2\u306b\u6b8b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"excel\u3067\u6587\u5b57\u5217\u691c\u7d22\u3059\u308b\u306b\u306f\">Excel\u3067\u6587\u5b57\u5217\u691c\u7d22\u3059\u308b\u306b\u306f<\/h2>\n\n\n\n<ul class=\"has-medium-font-size wp-block-list\"><li>FIND(\u691c\u7d22\u6587\u5b57\u5217, \u5bfe\u8c61, [\u958b\u59cb\u4f4d\u7f6e])\u3000<br>\u4f8b\uff1aFIND(&#8220;Test&#8221;,B1)\u3000Test\u304cB1\u304b\u3089\u4f55\u6587\u5b57\u76ee\u306b\u3067\u3066\u304f\u308b\u304b\uff1f<\/li><li>FINDB(\u691c\u7d22\u6587\u5b57\u5217, \u5bfe\u8c61, [\u958b\u59cb\u4f4d\u7f6e])\u3000<br>\u4f8b\uff1aFINDB(&#8220;Test&#8221;,B1)\u3000Test\u304cB1\u304b\u3089\u4f55\u30d0\u30a4\u30c8\u76ee\u306b\u3067\u3066\u304f\u308b\u304b\uff1f\u3000<\/li><\/ul>\n\n\n\n<ul class=\"has-medium-font-size wp-block-list\"><li>SEARCH(\u691c\u7d22\u6587\u5b57\u5217,\u5bfe\u8c61,[\u958b\u59cb\u4f4d\u7f6e])\u3000\u4f8b\uff1aFIND(&#8220;Test&#8221;,B1)<br>\u4f8b\uff1aSEARCH(&#8220;Test&#8221;,B1)\u3000Test\/test\/TEAT\u304cB1\u304b\u3089\u4f55\u6587\u5b57\u76ee\u306b\u3067\u3066\u304f\u308b\u304b\uff1f<\/li><li>SEARCHB(\u691c\u7d22\u6587\u5b57\u5217,\u5bfe\u8c61,[\u958b\u59cb\u4f4d\u7f6e])\u3000\u4f8b\uff1aFIND(&#8220;Test&#8221;,B1)<br>\u4f8b\uff1aSEARCHB(&#8220;Test&#8221;,B1)\u3000Test\/test\/TEAT\u304cB1\u304b\u3089\u4f55\u30d0\u30a4\u30c8\u76ee\u306b\u3067\u3066\u304f\u308b\u304b\uff1f<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\">\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f<\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\u4e0b\u306e\u5f0f\u306f\u898b\u305f\u76ee\u306f\u540c\u3058\u3067\u3059\u304c\u7247\u65b9\u306f\u30a8\u30e9\u30fc\uff03VALUE\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">H\u5217\u306fG\u5217\u306e\u5f0f\u306e\u4e2d\u8eab\u3067\u3059\u3002\u540c\u3058\u5f0f\u3067\u3082G4\u30bb\u30eb\u306e\u7d50\u679c\u304c\uff03VALUE\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/02\/EXCEL_ERR-1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"239\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/02\/EXCEL_ERR-1-1024x239.jpg\" alt=\"\" class=\"wp-image-1427\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/02\/EXCEL_ERR-1-1024x239.jpg 1024w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/02\/EXCEL_ERR-1-300x70.jpg 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/02\/EXCEL_ERR-1-768x179.jpg 768w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/02\/EXCEL_ERR-1-485x113.jpg 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/02\/EXCEL_ERR-1.jpg 1382w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"value\u304c\u51fa\u308b\u539f\u56e0\">\uff03VALUE\u304c\u51fa\u308b\u539f\u56e0<\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\uff03VALUE\u306f<br>\u3000\u6307\u5b9a\u3057\u305f\u6587\u5b57\u5217\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408\u3001<br>\u3000\u691c\u7d22\u4f4d\u7f6e\u304c\u6587\u5b57\u5217\u3088\u308a\u591a\u3044\u5834\u5408\uff08\u691c\u7d22\u4f4d\u7f6e\u306f\u7b2c\u4e09\u5f15\u6570\u3067\u8a2d\u5b9a\u3067\u304d\u308b\uff09<br>\u304c\u8981\u56e0\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\u3053\u306e\u5834\u5408\u306f\u201d<span class=\"span-stk-maker-pink\">\u6587\u5b57\u5217\u304c\u307f\u3064\u304b\u3089\u306a\u3044<\/span>\u201d\u3068\u3044\u3046\u7406\u7531\u4ee5\u5916\u8003\u3048\u3089\u308c\u306a\u3044\u306e\u3067\u3059\u304c\u3001\u6587\u5b57\u5217\u3068\u3057\u3066\u306f\u540c\u3058\u306b\u898b\u3048\u308b\u306e\u306b\u3001<strong>\u306a\u305c\uff1f<\/strong>\u3068\u3044\u3046\u72b6\u614b\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u539f\u56e0-\u5f8c\u308d\u306b\u30b9\u30da\u30fc\u30b9\u304c\u5165\u3063\u3066\u3044\u305f\">\u539f\u56e0\uff1a\u5f8c\u308d\u306b\u30b9\u30da\u30fc\u30b9\u304c\u5165\u3063\u3066\u3044\u305f<\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\u3082\u3068\u3082\u3068\u3001\u3053\u306e\u73fe\u8c61\u306b\u3042\u305f\u3063\u305f\u3068\u304d\u306e\u30c7\u30fc\u30bf\u304c\u3001\u8cc7\u6599\u304b\u3089\u30b3\u30d4\u30da\u3057\u305f\u3082\u306e\u3092\u6761\u4ef6\u3068\u3057\u3066\u4f7f\u3063\u3066\u3044\u305f\u305f\u3081\u3001\u5f8c\u308d\u306b\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u304c\u5165\u3063\u3066\u3044\u305f\u306e\u304c\u539f\u56e0\u3067\u3057\u305f\u3002<br>\u4f8b\u3060\u3068\u3000<br>\u3000D3\u30bb\u30eb\u306f\u3000<strong><span class=\"span-stk-maker-yellow\"><span class=\"span-stk-fs-l\">\u201d\u6771\u4eac\u201d<\/span><\/span><\/strong>\u3067\u3059\u304c<br>\u3000D4\u30bb\u30eb\u306f\u3000<span class=\"span-stk-maker-yellow\"><strong><span class=\"span-stk-fs-l\">\u201d\u6771\u4eac \u201d<\/span><\/strong><\/span>\u306b\u306a\u3063\u3066\u3044\u305f\u305f\u3081\u3067\u3059\u3002<br>\u305d\u306e\u305f\u3081\u6587\u7ae0\u306e\u4e2d\u306b\u4e00\u81f4\u3059\u308b\u7b87\u6240\u304c\u306a\u304b\u3063\u305f\u306e\u3067\u30a8\u30e9\u30fc\u3068\u306a\u3063\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\u3053\u3093\u306a\u7c21\u5358\u306a\u4e8b\u306a\u306e\u306b\u3001\u7d50\u69cb\u306f\u307e\u3063\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uff53<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30a8\u30af\u30bb\u30eb\u3067\u6587\u5b57\u5217\u691c\u7d22\u3059\u308b\u95a2\u6570\u306f\u3000FIND\/FINDB\u3084SERCH\/SERCHB\u3000\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u691c\u7d22\u7d50\u679c\u304c\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3057\u305f\u3002\u7c21\u5358\u306a\u5f0f\u3067\u3001\u6587\u5b57\u5217\u3082\u4e00\u81f4\u3057\u3066\u3044\u308b\u306e\u306b\u306a\u305c\u304b\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u306e\u3067\u305d\u306e\u6642\u306e\u3053\u3068\u3092\u30e1\u30e2\u306b\u6b8b\u3057\u307e&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1158,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[134],"tags":[],"class_list":{"0":"post-1425","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-pc","8":"article"},"aioseo_notices":[],"modified_by":"\u3089\u304f\u308d\u3050","_links":{"self":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1425"}],"version-history":[{"count":3,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1425\/revisions"}],"predecessor-version":[{"id":1431,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1425\/revisions\/1431"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1158"}],"wp:attachment":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}