{"id":330,"date":"2025-10-18T17:04:02","date_gmt":"2025-10-18T08:04:02","guid":{"rendered":"https:\/\/connectedbase-blog.jp\/?p=330"},"modified":"2025-10-26T17:06:30","modified_gmt":"2025-10-26T08:06:30","slug":"%e3%81%a8%e3%82%8a%e3%81%82%e3%81%88%e3%81%9aexcel%e5%8d%92%e6%a5%ad%ef%bc%9a%e8%aa%b0%e3%81%a7%e3%82%82%e5%ae%9f%e8%b7%b5%e3%81%a7%e3%81%8d%e3%82%8b%e3%82%86%e3%82%8b%e5%bc%b7excel","status":"publish","type":"post","link":"https:\/\/connectedbase-blog.jp\/?p=330","title":{"rendered":"\u3068\u308a\u3042\u3048\u305aExcel\u5352\u696d\uff1a\u8ab0\u3067\u3082\u5b9f\u8df5\u3067\u304d\u308b\u201c\u3086\u308b\u5f37\u201dExcel\u8853\u2014 \u5c0f\u3055\u304f\u59cb\u3081\u3066\u3001\u52dd\u624b\u306b\u30ad\u30ec\u30a4\u306b\u306a\u3063\u3066\u3044\u304f\u4ed5\u7d44\u307f"},"content":{"rendered":"\n<ul id=\"4cac43ed-4bfa-4cff-a949-99e8ac13028a\" class=\"wp-block-list\">\n<li>\u6700\u521d\u304b\u3089\u201c\u5b8c\u74a7\u30eb\u30fc\u30eb\u201d\u306f\u3044\u3089\u306a\u3044\u3002<strong>5\u3064\u306e\u8d85\u30df\u30cb\u30eb\u30fc\u30eb<\/strong>\u3067\u5341\u5206\u30b9\u30bf\u30fc\u30c8\u3067\u304d\u308b\u3002<\/li>\n\n\n\n<li>\u30ad\u30e2\u306f\u300c<strong>\u539f\u6587\u3092\u6b8b\u3059<\/strong>\u300d\u300c<strong>\u6b63\u540d\u306b\u5bc4\u305b\u308b<\/strong>\u300d\u300c<strong>\u4f8b\u5916\u306f\u8f9e\u66f8\u306b\u5438\u53ce<\/strong>\u300d\u3002<\/li>\n\n\n\n<li>1\u304b\u6708\u3067\u3001\u8868\u8a18\u3086\u308c\u304c\u52dd\u624b\u306b\u6e1b\u308b\u201c\u30bb\u30eb\u30d5\u30af\u30ea\u30fc\u30cb\u30f3\u30b0\u201d\u904b\u7528\u3078\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"21a3e4dd-305a-4511-9532-1ee3f39893fa\">\u307e\u305a\u306f\u3053\u306e5\u3064\u3060\u3051\uff08\u4eca\u65e5\u304b\u3089\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"e353f121-f11f-4d3c-98da-522ec4c21fce\">1) \u30d5\u30a1\u30a4\u30eb\u540d\u3092\u201c\u6642\u7cfb\u5217\u3067\u4e26\u3076\u201d\u3088\u3046\u306b<\/h3>\n\n\n\n<pre id=\"5252c7ad-95f0-4e6b-801f-523ad6dc8c61\" class=\"wp-block-code\"><code>YYYYMMDD_\u6848\u4ef6_\u7248\u6570.xlsx\n\u4f8b\uff0920251018_\u8cfc\u8cb7\u660e\u7d30_v1.xlsx<\/code><\/pre>\n\n\n\n<p>copy<\/p>\n\n\n\n<ul id=\"91613553-8390-417b-bf2d-fe9d59b88d04\" class=\"wp-block-list\">\n<li>\u76ee\u7684\uff1a\u6700\u65b0\u7248\u3092\u8ff7\u308f\u306a\u3044\u3002\u5dee\u5206\u304c\u8ffd\u3048\u308b\u3002<\/li>\n\n\n\n<li>\u8ff7\u3063\u305f\u3089 YYYYMMDD_\u540d\u79f0_v1.xlsx \u3060\u3051\u3067OK\u3002<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"2b4469c2-0ae9-4282-adc9-d62dfa12697c\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"00d6dd0b-a77d-4bda-8440-1f15c8fb9f71\">2) \u6700\u5c0f\u30b9\u30ad\u30fc\u30de\uff0812\u5217\uff09\u3060\u3051\u306f\u56fa\u5b9a<\/h3>\n\n\n\n<p id=\"4ac74ff0-b03e-4a1f-9ecf-5cb79ef19369\">\u300c\u3068\u308a\u3042\u3048\u305a\u5165\u308c\u308b\u300d\u304c\u30b4\u30df\u5316\u3059\u308b\u6700\u5927\u8981\u56e0\u306f\u201c\u5217\u304c\u6bce\u56de\u9055\u3046\u201d\u3053\u3068\u3002<strong>\u4e0b\u306e12\u5217\u3060\u3051\u56fa\u5b9a<\/strong>\u3057\u3066\u3001\u4ed6\u306f\u30e1\u30e2\u5217\u306b\u9003\u304c\u3059\u3002<\/p>\n\n\n\n<pre id=\"0657df1c-13f4-4bdf-8cc5-3ae04a1e1c2b\" class=\"wp-block-code\"><code>\u65e5\u4ed8 \/ \u53d6\u5f15\u5148\u539f\u6587 \/ \u53d6\u5f15\u5148ID \/ \u53d6\u5f15\u5148\u6b63\u5f0f\u540d\n\u54c1\u76ee\u539f\u6587 \/ \u54c1\u76ee\u30ab\u30c6\u30b4\u30ea\n\u6570\u91cf \/ \u5358\u4f4d\u539f\u6587 \/ \u5358\u4f4d\uff08\u6b63\uff09\n\u5358\u4fa1 \/ \u91d1\u984d \/ \u7a0e\u533a\u5206\n\uff08\u4efb\u610f\uff09\u30e1\u30e2 \/ \u62c5\u5f53 \/ \u78ba\u5b9a\u2714 \/ \u66f4\u65b0\u65e5\n<\/code><\/pre>\n\n\n\n<p>copy<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p id=\"00bcf74c-44f2-4dad-961f-b9e8830691d9\">\u30eb\u30fc\u30eb\u306f\u300c<strong>\u539f\u6587\u306f\u6d88\u3055\u306a\u3044<\/strong>\uff08\u5f8c\u3067\u898b\u8fd4\u305b\u308b\uff09\u300d\uff0b\u300c<strong>\u6b63\u306b\u5bc4\u305b\u308b\u5217\u3092\u5225\u306b\u3082\u3064<\/strong>\u300d\u3002<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"3ddd9704-d9ed-4cda-94da-adcccb62ceb9\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"190ddd49-650d-4eef-a8e5-e8b83a1b81b3\">3) \u3059\u3079\u3066\u3092\u201c\u30c6\u30fc\u30d6\u30eb\u5316\u201d\uff08Ctrl+T\uff09<\/h3>\n\n\n\n<ul id=\"5157ba32-5965-490b-8dfc-51f863b0cd25\" class=\"wp-block-list\">\n<li>\u7bc4\u56f2\u3092\u9078\u629e \u2192\u00a0<strong>Ctrl+T<\/strong>\u00a0\u2192 \u300c\u5148\u982d\u884c\u3092\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u4f7f\u7528\u300d\u306b\u30c1\u30a7\u30c3\u30af<\/li>\n\n\n\n<li>\u52b9\u679c\uff1a<strong>\u30d8\u30c3\u30c0\u30fc\u56fa\u5b9a\u30fb\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb<\/strong>\u30fb\u30d5\u30a3\u30eb\u30bf\u30fc\u6a19\u6e96\u88c5\u5099\u3002\u65b0\u884c\u306b\u3082\u5f0f\u304c\u81ea\u52d5\u3067\u5165\u308b\u3002<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"90b82540-6334-4b74-957d-b45e8a135b96\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"ed63914f-bd89-40d2-b8d9-84a205842a2c\">4) \u5165\u529b\u898f\u5247\u3067\u201c\u8868\u8a18\u3086\u308c\u201d\u3092\u672a\u7136\u306b\u9632\u3050\uff08\u6700\u4f4e2\u3064\u3060\u3051\uff09<\/h3>\n\n\n\n<p id=\"795d2b7c-3aea-4f36-9a40-701e1352f631\"><strong>\u300c\u5358\u4f4d\u300d\u300c\u7a0e\u533a\u5206\u300d\u3060\u3051<\/strong>\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u306b\u3002<\/p>\n\n\n\n<ul id=\"c638fe45-df8b-4da5-9cf9-220c5703d718\" class=\"wp-block-list\">\n<li>\u300c\u30c7\u30fc\u30bf\u300d\u2192\u300c\u30c7\u30fc\u30bf\u306e\u5165\u529b\u898f\u5247\u300d\u2192\u00a0<strong>\u30ea\u30b9\u30c8<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5358\u4f4d\uff1am\u00b2, m, \u500b, \u53f0, \u672c, \u7bb1\uff08\u3042\u3068\u3067\u5897\u3084\u305b\u3070OK\uff09<\/li>\n\n\n\n<li>\u7a0e\u533a\u5206\uff1a\u7a0e\u8fbc, \u7a0e\u629c<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p id=\"2b4ec7b1-9629-416c-b175-c1c72eac4bb2\">\u8ff7\u3063\u3066\u3082\u5165\u529b\u3067\u304d\u308b\u3088\u3046\u306b<strong>\u5358\u4f4d\u201c\u539f\u6587\u201d\u5217<\/strong>\u306f\u81ea\u7531\u5165\u529b\u306e\u307e\u307e\u306b\u3057\u3066\u304a\u304f\uff08\u5f8c\u3067\u6b63\u306b\u5bc4\u305b\u308b\uff09\u3002<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"2bd745fa-96d0-48b9-a740-c69e41e7f648\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"a34495bf-6a10-4466-8855-0695689eefdf\">5) \u5909\u63db\u306f\u201c\u8f9e\u66f8\u8868\u201d\u3067\u5bc4\u305b\u308b\uff08XLOOKUP 1\u672c\u3067OK\uff09<\/h3>\n\n\n\n<p id=\"18a10b59-1e64-4f0e-99a0-d10ca8c893ad\">\u5225\u30b7\u30fc\u30c8\u306b\u8f9e\u66f8\u3092\u7f6e\u304d\u3001<strong>\u539f\u6587\u2192\u6b63\u540d<\/strong>\u3078\u5bc4\u305b\u308b\u3002\u6700\u521d\u306f10\u884c\u3067\u5341\u5206\u3002<\/p>\n\n\n\n<p id=\"ceb353cb-d51d-4d49-b45e-105beaaa42b7\"><strong>\u30b7\u30fc\u30c8\u540d\uff1a\u8f9e\u66f8_\u53d6\u5f15\u5148<\/strong><\/p>\n\n\n\n<pre id=\"0b880b51-404f-40cd-a5e8-34de87313a60\" class=\"wp-block-code\"><code>A\u5217: \u539f\u6587            B\u5217: \u6b63\u5f0f\u540d                  C\u5217: \u53d6\u5f15\u5148ID\n\uff08\u682a\uff09\u30e8\u30ba\u30dc\u30b7       \u682a\u5f0f\u4f1a\u793eYOZBOSHI             CUST-0001\nYOZBOSHI(\u682a)        \u682a\u5f0f\u4f1a\u793eYOZBOSHI             CUST-0001\n\u30e8\u30ba\u30dc\u30b7            \u682a\u5f0f\u4f1a\u793eYOZBOSHI             CUST-0001<\/code><\/pre>\n\n\n\n<p>copy<\/p>\n\n\n\n<p id=\"23e4e63c-5b52-4b97-a895-7ee4ce485206\"><strong>\u30b7\u30fc\u30c8\u540d\uff1a\u8f9e\u66f8_\u5358\u4f4d<\/strong><\/p>\n\n\n\n<pre id=\"af301ae6-56f0-4115-b201-17f99108b7a9\" class=\"wp-block-code\"><code>A\u5217: \u5225\u540d   B\u5217: \u6b63\u5f0f\u5358\u4f4d\n\u5e73\u7c73       m\u00b2\n\u33a1         m\u00b2\nm2         m\u00b2\n\u672c         \u672c\n\u53f0         \u53f0<\/code><\/pre>\n\n\n\n<p>copy<\/p>\n\n\n\n<p id=\"7ca4872d-240e-4738-863e-e7eb1c61ea25\"><strong>\u660e\u7d30\u30c6\u30fc\u30d6\u30eb\u5074\u306e\u5f0f\uff08\u4f8b\uff1a\u884c2\uff09<\/strong><\/p>\n\n\n\n<pre id=\"7af171bf-c62b-4b90-883a-1323aa767584\" class=\"wp-block-code\"><code>C2: =XLOOKUP(B2, \u8f9e\u66f8_\u53d6\u5f15\u5148!A:A, \u8f9e\u66f8_\u53d6\u5f15\u5148!C:C, \"\")\nD2: =XLOOKUP(B2, \u8f9e\u66f8_\u53d6\u5f15\u5148!A:A, \u8f9e\u66f8_\u53d6\u5f15\u5148!B:B, B2)\nI2: =XLOOKUP(H2, \u8f9e\u66f8_\u5358\u4f4d!A:A, \u8f9e\u66f8_\u5358\u4f4d!B:B, H2)\nK2: =IF(AND(ISNUMBER(G2),ISNUMBER(J2)), G2*J2, \"\")<\/code><\/pre>\n\n\n\n<p>copy<\/p>\n\n\n\n<ul id=\"04a13485-8ed3-400e-9b04-a3f4031154ab\" class=\"wp-block-list\">\n<li>\u3067\u304d\u308b\u3060\u3051<strong>XLOOKUP<\/strong>\u3002\u53e4\u3044Excel\u306a\u3089 VLOOKUP \u3067\u3082OK\u3002<\/li>\n\n\n\n<li>\u8ff7\u3063\u305f\u3089\u3001<strong>\u307e\u305a\u539f\u6587\u3092\u5165\u308c\u308b\u2192\u8f9e\u66f8\u306b\u8ffd\u52a0\u2192\u52dd\u624b\u306b\u63c3\u3046<\/strong>\u6d41\u308c\u306b\u3002<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"b6a4bdc9-e6a8-40ab-9b2a-6eb84ffd2644\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"9906892f-bffb-4112-8ea3-098861d2c0a2\">\u3053\u3053\u307e\u3067\u3084\u308c\u305f\u3089\u201c\uff0b\u03b1\u201d\u3067\u52b9\u304f\u88dc\u52a9\u30eb\u30fc\u30eb<\/h2>\n\n\n\n<ol id=\"fe732287-06b3-4041-b188-ab678cf9e32d\" class=\"wp-block-list\">\n<li><strong>\u5c0f\u8a08\u30fb\u5408\u8a08\u306f\u5225\u30b7\u30fc\u30c8<\/strong>\uff08\u660e\u7d30\u3068\u6df7\u305c\u306a\u3044\uff09<\/li>\n\n\n\n<li><strong>\u6570\u91cf\u306f\u6570\u5b57\u3060\u3051<\/strong>\uff08\u300c10\u7bb1\u300d\u2192 \u6570\u91cf=10, \u5358\u4f4d=\u7bb1\uff09<\/li>\n\n\n\n<li><strong>\u65e5\u4ed8\u306fYYYY-MM-DD<\/strong>\uff08\u5217\u306e\u8868\u793a\u5f62\u5f0f\u3067\u56fa\u5b9a\uff09<\/li>\n\n\n\n<li><strong>\u7a0e\u533a\u5206\u306f\u5fc5\u9808<\/strong>\uff08\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\uff09<\/li>\n\n\n\n<li><strong>\u78ba\u5b9a\u2714\/\u62c5\u5f53\/\u66f4\u65b0\u65e5<\/strong>\u306e3\u5217\u3092\u201c\u76e3\u67fb\u201d\u3068\u3057\u3066\u3082\u3064\n<ul class=\"wp-block-list\">\n<li>\u66f4\u65b0\u65e5\uff1a\u65e5\u4ed8\u30bb\u30eb\u3067 Ctrl + ;\uff08\u4eca\u65e5\u306e\u65e5\u4ed8\u3092\u56fa\u5b9a\uff09<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"365e18cd-0d38-4651-ba65-a35087a07adf\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2a62a9c3-b245-470f-9af0-ae51dcc8d57d\">NG\u2192OK \u4f8b\uff08\u305d\u306e\u307e\u307e\u8cbc\u308c\u308b\u6307\u5dee\u3057\u78ba\u8a8d\uff09<\/h2>\n\n\n\n<p id=\"6e08457b-04df-4a23-a81e-d8e50fee6483\">NG\uff08\u3042\u308a\u304c\u3061\uff09OK\uff08\u3086\u308b\u5f37\u30eb\u30fc\u30eb\uff092025\/10\/18 9\u6642 \u8acb\u6c42\u30c7\u30fc\u30bf<strong>20251018_\u8acb\u6c42\u660e\u7d30_v1.xlsx<\/strong>\u5408\u8a08\u5217\u304c\u660e\u7d30\u3068\u540c\u3058\u8868\u5185<strong>\u96c6\u8a08\u306f\u5225\u30b7\u30fc\u30c8<\/strong>\u306b\u3002\u660e\u7d30\u306f\u660e\u7d30\u3060\u3051\u6570\u91cf: 10\u7bb1<strong>\u6570\u91cf=10 \/ \u5358\u4f4d=\u7bb1<\/strong>\u00a0\u306b\u5206\u96e2\u5358\u4f4d: \u33a1\/m2\/\u5e73\u7c73\u6df7\u5728\u5358\u4f4d\uff08\u539f\u6587\uff09\u306f\u8a31\u5bb9\u3001\u5358\u4f4d\uff08\u6b63\uff09\u306f\u8f9e\u66f8\u3067m\u00b2\u306b\u5bc4\u305b\u308b\u3231\/\uff08\u682a\uff09\/\u30ab\u30bf\u30ab\u30ca\u63fa\u308c<strong>\u53d6\u5f15\u5148\u539f\u6587<\/strong>\u306f\u4fdd\u6301\u3001<strong>\u6b63\u5f0f\u540d\/ID<\/strong>\u306f\u8f9e\u66f8\u3067\u5bc4\u305b\u308b<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"d1347f67-e3a8-4462-9215-06e55f610e38\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"40f47f08-e1e5-4ac5-a8f1-854020fcb2f8\">30\u65e5\u3067\u300c\u52dd\u624b\u306b\u30ad\u30ec\u30a4\u300d\u3092\u4f5c\u308b\u5c0e\u5165\u30d7\u30e9\u30f3<\/h2>\n\n\n\n<p id=\"34a9a08d-3472-4feb-9f02-9a2dfb2aaaeb\"><strong>Week 1<\/strong><\/p>\n\n\n\n<ul id=\"2a6b421c-2761-4916-868a-bbaa0f40f3d6\" class=\"wp-block-list\">\n<li>\u6700\u5c0f\u30b9\u30ad\u30fc\u30de12\u5217\u3067\u30c6\u30fc\u30d6\u30eb\u5316\uff08Ctrl+T\uff09<\/li>\n\n\n\n<li>\u300c\u5358\u4f4d\u300d\u300c\u7a0e\u533a\u5206\u300d\u3092\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u5316<\/li>\n\n\n\n<li>\u8f9e\u66f8\u30b7\u30fc\u30c8\u30922\u3064\u4f5c\u308b\uff08\u53d6\u5f15\u5148\/\u5358\u4f4d\uff09\u300110\u884c\u3060\u3051\u767b\u9332<\/li>\n<\/ul>\n\n\n\n<p id=\"4b616564-813b-4259-81ce-53a1d2d896ef\"><strong>Week 2<\/strong><\/p>\n\n\n\n<ul id=\"b0776520-c47d-4606-b079-da4a09314fb7\" class=\"wp-block-list\">\n<li>\u65e5\u3005\u306e\u201c\u63fa\u308c\u201d\u3092\u898b\u3064\u3051\u305f\u3089<strong>\u8f9e\u66f8\u306b\u8ffd\u8a18<\/strong>\uff083\u5206\u904b\u7528\uff09<\/li>\n\n\n\n<li>\u65e2\u5b58\u5206\u3082<strong>\u539f\u6587\u306f\u89e6\u3089\u305a\u3001\u6b63\u5217\u304c\u81ea\u52d5\u3067\u63c3\u3046<\/strong>\u306e\u3092\u78ba\u8a8d<\/li>\n<\/ul>\n\n\n\n<p id=\"1293cd06-4515-4147-a6c1-8bc6d7c6cc54\"><strong>Week 3<\/strong><\/p>\n\n\n\n<ul id=\"2987276b-e60b-416d-b665-a3654f927419\" class=\"wp-block-list\">\n<li>\u96c6\u8a08\u306f\u5225\u30b7\u30fc\u30c8\u3067 SUMIFS\/\u30d4\u30dc\u30c3\u30c8 \u306b\u7d71\u4e00<\/li>\n\n\n\n<li>\u78ba\u5b9a\u2714\/\u62c5\u5f53\/\u66f4\u65b0\u65e5\u3092\u904b\u7528\u306b\u306e\u305b\u308b<\/li>\n<\/ul>\n\n\n\n<p id=\"dc4b65c7-89a2-469b-ae03-8d767680de9b\"><strong>Week 4<\/strong><\/p>\n\n\n\n<ul id=\"af3dd211-95a3-413b-b576-8a10de9606bf\" class=\"wp-block-list\">\n<li>\u76f4\u8fd11,000\u884c\u3092\u70b9\u691c\u3057\u3066\u8f9e\u66f8\u306e<strong>\u7a74TOP10<\/strong>\u3092\u57cb\u3081\u308b<\/li>\n\n\n\n<li>\u4ee5\u964d\u306f\u201c\u8f9e\u66f8\u8ffd\u8a18\u3060\u3051\u201d\u3092\u9031\u30a4\u30c15\u5206<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p id=\"a7f98a44-e44a-4d21-8aa0-c809ec3d1b5a\">\u30dd\u30a4\u30f3\u30c8\uff1a<strong>\u73fe\u5834\u306e\u81ea\u7531\u5ea6\u306f\u6b8b\u3059<\/strong>\uff08\u539f\u6587\u5217\uff09\u3002<strong>\u7ba1\u7406\u306e\u4e00\u8cab\u6027\u306f\u8f9e\u66f8\u3067\u62c5\u4fdd<\/strong>\uff08\u6b63\u5217\uff09\u3002\u3053\u308c\u304c\u201c\u3086\u308b\u5f37\u201d\u3002<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"38fb8800-36f0-4a99-b979-6956549b9694\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"ccda5b9d-7616-49a2-8051-ada694c66888\">\u3088\u304f\u3042\u308b\u8a70\u307e\u308a\u3069\u3053\u308d\uff08Q&amp;A\uff09<\/h2>\n\n\n\n<p id=\"06599269-c3bb-44f1-9263-e2ccb380f1d9\"><strong>Q. \u6700\u521d\u306e\u8f9e\u66f8\u3065\u304f\u308a\u304c\u9762\u5012\u2026<\/strong><br>A. 10\u884c\u3067\u5341\u5206\u3002<strong>\u51fa\u3066\u304d\u305f\u63fa\u308c\u3092\u8db3\u3059<\/strong>\u65b9\u5f0f\u306b\u3059\u308c\u3070\u3001\u521d\u671f\u8ca0\u8377\u30bc\u30ed\u3067\u56de\u308b\u3002<\/p>\n\n\n\n<p id=\"253c7fc7-8d87-4815-aabd-445eba87d907\"><strong>Q. \u904e\u53bb\u30c7\u30fc\u30bf\u306f\u3069\u3046\u3059\u308b\uff1f<\/strong><br>A. \u3044\u3058\u3089\u306a\u3044\u3002<strong>\u539f\u6587\u306f\u305d\u306e\u307e\u307e<\/strong>\u3001\u6b63\u5217\u3060\u3051\u8f9e\u66f8\u3067\u5f8c\u8ffd\u3044\u6574\u5099\u3002<\/p>\n\n\n\n<p id=\"e18454fc-3f39-4f20-adff-38549e370e60\"><strong>Q. \u9593\u9055\u3063\u305f\u8f9e\u66f8\u3067\u5168\u4f53\u304c\u8aa4\u5909\u63db\u3057\u306a\u3044\uff1f<\/strong><br>A. \u3060\u304b\u3089\u3053\u305d<strong>\u539f\u6587\u5217\u306f\u6d88\u3055\u306a\u3044<\/strong>\u3002\u8aa4\u308a\u306b\u6c17\u3065\u3044\u305f\u3089\u8f9e\u66f81\u884c\u76f4\u3059\u3060\u3051\u3067<strong>\u5168\u4f53\u304c\u5373\u4fee\u6b63<\/strong>\u3002<\/p>\n\n\n\n<p id=\"eda7ad78-47f9-4252-b64d-7abd41c03c20\"><strong>Q. XLOOKUP\u304c\u4f7f\u3048\u306a\u3044Excel\u3067\u3059<\/strong><br>A. =IFERROR(VLOOKUP(B2, \u8f9e\u66f8_\u53d6\u5f15\u5148!A:C, 3, FALSE), &#8220;&#8221;) \u306e\u3088\u3046\u306b\u4ee3\u66ff\u53ef\u80fd\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"9ec859b6-b2f9-47eb-ae63-8ce67fb4897d\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"884c4b65-60b9-48fb-995c-be4a8affc9e6\">\u4ed5\u4e0a\u3052\uff1a\u30b3\u30d4\u30da\u7528\u201c\u30b9\u30bf\u30fc\u30bf\u30fc\u201d\u884c<\/h2>\n\n\n\n<p id=\"5d05a60c-023f-42a5-b52d-5ff552cfc71d\"><strong>\u8f9e\u66f8_\u53d6\u5f15\u5148\uff08\u5148\u982d5\u884c\u306e\u4f8b\uff09<\/strong><\/p>\n\n\n\n<pre id=\"d627bb07-4794-40d2-ae3d-a0d84674fd32\" class=\"wp-block-code\"><code>\u539f\u6587,\u6b63\u5f0f\u540d,\u53d6\u5f15\u5148ID\n\uff08\u682a\uff09YOZBOSHI,\u682a\u5f0f\u4f1a\u793eYOZBOSHI,CUST-0001\nYOZBOSHI(\u682a),\u682a\u5f0f\u4f1a\u793eYOZBOSHI,CUST-0001\n\u30e8\u30ba\u30dc\u30b7,\u682a\u5f0f\u4f1a\u793eYOZBOSHI,CUST-0001\n(\u6709)\u30df\u30e9\u30a4\u5de5\u696d,\u6709\u9650\u4f1a\u793e\u30df\u30e9\u30a4\u5de5\u696d,CUST-0023<\/code><\/pre>\n\n\n\n<p>copy<\/p>\n\n\n\n<p id=\"4b0b8b31-d1e2-45a4-aad1-65acc6fa800e\"><strong>\u8f9e\u66f8_\u5358\u4f4d\uff08\u5148\u982d5\u884c\u306e\u4f8b\uff09<\/strong><\/p>\n\n\n\n<pre id=\"494ccd72-0cf2-4d8e-9244-90f972633e7e\" class=\"wp-block-code\"><code>\u5225\u540d,\u6b63\u5f0f\u5358\u4f4d\n\u5e73\u7c73,m\u00b2\nm2,m\u00b2\n\u33a1,m\u00b2\n\u672c,\u672c\n\u53f0,\u53f0<\/code><\/pre>\n\n\n\n<p id=\"91b8e275-177a-4933-8eb3-c27a624eea87\"><strong>\u7a0e\u533a\u5206\uff08\u5165\u529b\u898f\u5247\u30ea\u30b9\u30c8\uff09<\/strong><\/p>\n\n\n\n<pre id=\"20c4f96b-a551-4744-a332-479a41a5dbd5\" class=\"wp-block-code\"><code>\u7a0e\u8fbc,\u7a0e\u629c<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" id=\"6bd4d491-9385-4cb7-8baa-f1548e728cba\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"d3994027-735a-4d98-9101-d37d0b2ce9b5\">\u307e\u3068\u3081<\/h2>\n\n\n\n<ul id=\"bfdc658f-9746-41e2-847c-c4f33eb03799\" class=\"wp-block-list\">\n<li><strong>\u5b8c\u74a7\u4e3b\u7fa9\u3092\u6368\u3066\u308b\u3002<\/strong>\u00a0\u6700\u5c0f\u30b9\u30ad\u30fc\u30de\uff0b\u8f9e\u66f8\uff0b\u5165\u529b\u898f\u5247\u306e<strong>3\u70b9\u30bb\u30c3\u30c8<\/strong>\u3067\u5341\u5206\u3002<\/li>\n\n\n\n<li><strong>\u539f\u6587\u306f\u6b8b\u3059\u3001\u6b63\u306b\u5bc4\u305b\u308b\u3002<\/strong>\u00a0\u76f4\u3057\u3084\u3059\u3055\uff1d\u5c06\u6765\u306e\u81ea\u7531\u5ea6\u3002<\/li>\n\n\n\n<li><strong>\u8f9e\u66f8\u3092\u80b2\u3066\u308b<\/strong>\u3060\u3051\u3067\u3001Excel\u306f<strong>\u52dd\u624b\u306b\u30ad\u30ec\u30a4<\/strong>\u306b\u306a\u3063\u3066\u3044\u304f\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"6c4235fa-b5f8-4985-a82c-00829c5e61d9\">\uff08\u304a\u77e5\u3089\u305b\uff09Connected Base\u3068\u3044\u3046\u30a2\u30d7\u30ed\u30fc\u30c1<\/h2>\n\n\n\n<p id=\"ab19c42f-c9a5-4d79-a50b-79bcfc9847fc\"><strong>\u3069\u3093\u306a\u30bd\u30d5\u30c8\u3092\u5165\u308c\u3066\u3082\u3001\u30c7\u30fc\u30bf\u306e\u53ce\u96c6\u30fb\u6574\u5099\u30fb\u6295\u5165\u306b\u306f\u201c\u4eba\u306e\u624b\u201d\u304c\u6b8b\u308b\u3002<\/strong><br>Connected Base\u306f\u3001<strong>\u5224\u65ad\u30ed\u30b0\u306e\u5b66\u7fd2\u00d7\u6b63\u898f\u5316\u30b9\u30ad\u30fc\u30de\u00d7\u4f8b\u5916UI<\/strong>\u3092\u6838\u306b\u3001<br>\u7d19\/Excel\u4e2d\u5fc3\u306e\u73fe\u5834\u304b\u3089\u201c\u696d\u52d9\u3067\u4f7f\u3048\u308b\u30c7\u30fc\u30bf\u201d\u3078\u6a4b\u6e21\u3057\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul id=\"b9c95a2b-25d7-4241-982d-2bbdd852c29e\" class=\"wp-block-list\">\n<li>\u65e2\u5b58Excel\u306f\u305d\u306e\u307e\u307e<\/li>\n\n\n\n<li>\u4f8b\u5916\u306e\u4e00\u767a\u78ba\u5b9a\u2192\u81ea\u52d5\u5316\u306b\u53ce\u675f<\/li>\n\n\n\n<li>\u4f1a\u8a08\u30fb\u8cfc\u8cb7\u30fbBI\u3078\u30af\u30ea\u30fc\u30f3\u306b\u9023\u643a<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u307e\u305a\u306f\u3053\u306e5\u3064\u3060\u3051\uff08\u4eca\u65e5\u304b\u3089\uff09 1) \u30d5\u30a1\u30a4\u30eb\u540d\u3092\u201c\u6642\u7cfb\u5217\u3067\u4e26\u3076\u201d\u3088\u3046\u306b copy 2) \u6700\u5c0f\u30b9\u30ad\u30fc\u30de\uff0812\u5217\uff09\u3060\u3051\u306f\u56fa\u5b9a \u300c\u3068\u308a\u3042\u3048\u305a\u5165\u308c\u308b\u300d\u304c\u30b4\u30df\u5316\u3059\u308b\u6700\u5927\u8981\u56e0\u306f\u201c\u5217\u304c\u6bce\u56de\u9055\u3046\u201d\u3053\u3068\u3002\u4e0b\u306e12\u5217\u3060\u3051\u56fa\u5b9a\u3057\u3066\u3001\u4ed6\u306f\u30e1\u30e2 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":331,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[32,34,30,29],"tags":[43,54,53,45,52,46],"class_list":["post-330","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cb-product","category-backoffice","category-construction-dx","category-manufacturing-dx","tag-excel","tag-54","tag-53","tag-45","tag-dx","tag-46"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=330"}],"version-history":[{"count":1,"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/330\/revisions"}],"predecessor-version":[{"id":332,"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/330\/revisions\/332"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=\/wp\/v2\/media\/331"}],"wp:attachment":[{"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/connectedbase-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}