{"id":8243,"date":"2026-11-19T11:46:25","date_gmt":"2026-11-19T02:46:25","guid":{"rendered":"https:\/\/jfs.or.jp\/jfs-cs\/?p=8243"},"modified":"2026-11-19T11:46:25","modified_gmt":"2026-11-19T02:46:25","slug":"google-form-key-link","status":"publish","type":"post","link":"https:\/\/jfs.or.jp\/jfs-cs\/google-form-key-link\/","title":{"rendered":"Google Form\u306e\u5229\u7528\u6cd5\u3000\u30de\u30b9\u30bf\u3068\u30ea\u30f3\u30af\u3057\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8\u65b0\u898f\u4f5c\u6210"},"content":{"rendered":"<h1>\u51fa\u6b20\u306b\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5<\/h1>\n<p>Google \u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54\u304b\u3089\u300c\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3054\u3068\u306e\u6700\u65b0\u7248\u3060\u3051\u300d<b>\u3092\u62bd\u51fa\u3057\u305f<\/b>\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8<b>\u3092\u4f5c\u308a\u3001\u305d\u308c\u3092<\/b>\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\uff08\u9023\u756a\u30fb\u7ba1\u7406\u756a\u53f7\u306a\u3069\uff09\u3067\u4e26\u3079\u66ff\u3048\u3066\u51fa\u529b\u30b7\u30fc\u30c8\u306b\u4f5c\u308b\u624b\u9806\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n<p>\u4eca\u56de\u306e\u6d41\u308c\u306f <b>\u300c2\u6bb5\u968e\uff08\u2460\u6700\u65b0\u7248\u3060\u3051\u306e\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8\u4f5c\u6210 \u2192 \u2461\u30de\u30b9\u30bf\u30fc\u756a\u53f7\u3067\u30bd\u30fc\u30c8\u3057\u3066\u51fa\u529b\u30b7\u30fc\u30c8\u751f\u6210\uff09\u300d<\/b> \u306b\u5206\u3051\u308b\u3068\u3001\u6570\u5f0f\u304c\u30b7\u30f3\u30d7\u30eb\u306b\u306a\u308a\u3001\u9014\u4e2d\u306e\u78ba\u8a8d\u3084\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u3082\u3057\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n<h3>1. \u30b7\u30fc\u30c8\u306e\u5f79\u5272\u3068\u69cb\u6210\u4f8b<\/h3>\n<ul>\n<li><b><code>\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 1 <\/code><\/b>\uff08\u30d5\u30a9\u30fc\u30e0\u81ea\u52d5\u751f\u6210\uff09\n<ul>\n<li><code>A <\/code>\u5217\uff1a\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7 \/ <code>B <\/code>\u5217\uff1a\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9 \/ <code>C <\/code>\u5217\u4ee5\u964d\uff1a\u56de\u7b54\u5185\u5bb9\uff08\u4f8b\uff1a <code>C <\/code>\u5217\uff1d\u51fa\u6b20\u3001 <code>D <\/code>\u5217\uff1d\u5099\u8003\uff09<\/li>\n<\/ul>\n<\/li>\n<li><b><code>\u30de\u30b9\u30bf\u30fc <\/code><\/b>\n<ul>\n<li><code>A <\/code>\u5217\uff1a\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\uff08\u7d50\u5408\u30ad\u30fc\uff09 \/ <code>B <\/code>\u5217\uff1a<b>\u756a\u53f7<\/b>\uff08\u30bd\u30fc\u30c8\u30ad\u30fc\uff1a\u4f8b <code>1, 2, 3... <\/code> \u3084 <code>001, 002... <\/code>\uff09 \/ <code>C <\/code>\u5217\uff1a\u6c0f\u540d \/ <code>D <\/code>\u5217\uff1a\u6240\u5c5e<\/li>\n<\/ul>\n<\/li>\n<li><b><code>\u30c7\u30fc\u30bf <\/code> \u30b7\u30fc\u30c8<\/b>\uff08\u65b0\u3057\u304f\u4f5c\u6210\u2460\uff1a\u56de\u7b54\u306e\u300c\u6700\u65b0\u7248\u3060\u3051\u300d\u3092\u62bd\u51fa\u3057\u305f\u30b7\u30fc\u30c8\uff09<\/li>\n<li><b><code>\u51fa\u529b <\/code> \u30b7\u30fc\u30c8<\/b>\uff08\u65b0\u3057\u304f\u4f5c\u6210\u2461\uff1a\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\u3067\u30bd\u30fc\u30c8\u3057\u3066\u7d50\u5408\u3057\u305f\u6700\u7d42\u30b7\u30fc\u30c8\uff09<\/li>\n<\/ul>\n<h3>2. \u30b9\u30c6\u30c3\u30d7\u2460\uff1a <code>\u30c7\u30fc\u30bf <\/code> \u30b7\u30fc\u30c8\u3092\u4f5c\u308b\uff08\u56de\u7b54\u306e\u300c\u6700\u65b0\u7248\u3060\u3051\u300d\u3092\u62bd\u51fa\uff09<\/h3>\n<ol>\n<li>\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u8ffd\u52a0\u3057\u3001\u540d\u524d\u3092 <b> <code>\u30c7\u30fc\u30bf <\/code><\/b> \u306b\u3057\u307e\u3059\u3002<\/li>\n<li>1\u884c\u76ee\uff08 <code>A1:D1 <\/code>\uff09\u306b\u898b\u51fa\u3057\u3092\u5165\u308c\u307e\u3059\uff08\u4f8b\uff1a <code>\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7 <\/code>, <code>\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9 <\/code>, <code>\u51fa\u6b20 <\/code>, <code>\u5099\u8003 <\/code>\uff09\u3002<\/li>\n<li><b><code>A2 <\/code> \u30bb\u30eb<\/b>\u306b\u3001\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3054\u3068\u306e<b>\u6700\u65b0\u56de\u7b54\uff08\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u304c\u6700\u3082\u65b0\u3057\u3044\u884c\uff09\u3060\u3051<\/b>\u3092\u62bd\u51fa\u3059\u308b\u6570\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n<p>Excel<\/p>\n<pre><code>=LET(\r\nraw, FILTER('\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 1'!A2:D, '\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 1'!B2:B&lt;&gt;\"\"),\r\nnorm_email, ARRAYFORMULA(LOWER(TRIM(INDEX(raw, 0, 2)))),\r\nwith_norm, HSTACK(raw, norm_email),\r\nsorted_desc, SORT(with_norm, 1, FALSE),\r\nlatest_with_norm, SORTN(sorted_desc, 9^9, 2, COLUMNS(with_norm), TRUE),\r\nCHOOSECOLS(latest_with_norm, SEQUENCE(COLUMNS(raw)))\r\n)\r\n<\/code><\/pre>\n<h4>\u3053\u306e\u6570\u5f0f\u306e\u52d5\u304d<\/h4>\n<ul>\n<li><code>FILTER(..., '\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 1'!B2:B&lt;&gt;\"\") <\/code>\uff1a\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u7a7a\u306e\u884c\u3092\u9664\u5916\u3057\u307e\u3059\u3002<\/li>\n<li><code>norm_email <\/code>\uff1a\u5927\u6587\u5b57\u30fb\u5c0f\u6587\u5b57\u3084\u524d\u5f8c\u30b9\u30da\u30fc\u30b9\u3092\u63c3\u3048\u305f\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u4f5c\u308a\u307e\u3059\u3002<\/li>\n<li><code>SORT(with_norm, 1, FALSE) <\/code>\uff1a\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\uff081\u5217\u76ee\uff09\u306e\u964d\u9806\uff08\u65b0\u3057\u3044\u9806\uff09\u306b\u4e26\u3079\u66ff\u3048\u307e\u3059\u3002<\/li>\n<li><code>SORTN(..., 9^9, 2, COLUMNS(with_norm), TRUE) <\/code>\uff1a\u6b63\u898f\u5316\u6e08\u307f\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u5217\u3092\u57fa\u6e96\u306b\u91cd\u8907\u3092\u524a\u308a\u3001<b>\u5404\u30a2\u30c9\u30ec\u30b9\u306e1\u4ef6\u76ee\uff08\uff1d\u6700\u65b0\u56de\u7b54\uff09\u3060\u3051<\/b>\u3092\u6b8b\u3057\u307e\u3059\u3002<\/li>\n<li><code>CHOOSECOLS(..., SEQUENCE(COLUMNS(raw))) <\/code>\uff1a\u4f5c\u696d\u7528\u306b\u3064\u3051\u305f\u672b\u5c3e\u306e\u6b63\u898f\u5316\u30e1\u30fc\u30eb\u5217\u3092\u53d6\u308a\u9664\u304d\u3001\u5143\u306e\u5217\u6570\uff08 <code>A:D <\/code>\uff09\u306b\u623b\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n<h3>3. \u30b9\u30c6\u30c3\u30d7\u2461\uff1a <code>\u51fa\u529b <\/code> \u30b7\u30fc\u30c8\u3092\u4f5c\u308b\uff08\u30de\u30b9\u30bf\u30fc\u3068\u7d50\u5408\u3057\u3001\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\u3067\u30bd\u30fc\u30c8\uff09<\/h3>\n<ol>\n<li>\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u8ffd\u52a0\u3057\u3001\u540d\u524d\u3092 <b> <code>\u51fa\u529b <\/code><\/b> \u306b\u3057\u307e\u3059\u3002<\/li>\n<li>1\u884c\u76ee\uff08 <code>A1:H1 <\/code>\uff09\u306b\u898b\u51fa\u3057\u3092\u5165\u308c\u307e\u3059\u3002\n<ul>\n<li>\u4f8b\uff1a <code>A1 <\/code>= <code>\u756a\u53f7 <\/code>\u3001 <code>B1 <\/code>= <code>\u6c0f\u540d <\/code>\u3001 <code>C1 <\/code>= <code>\u6240\u5c5e <\/code>\u3001 <code>D1 <\/code>= <code>\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9 <\/code>\u3001 <code>E1 <\/code>= <code>\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7 <\/code>\u3001 <code>F1 <\/code>= <code>\u51fa\u6b20 <\/code>\u3001 <code>G1 <\/code>= <code>\u5099\u8003\u3000\u3001H1 = \u305d\u306e\u4ed6<\/code><\/li>\n<\/ul>\n<\/li>\n<li><b><code>A2 <\/code> \u30bb\u30eb<\/b>\u306b\u3001\u6700\u65b0\u56de\u7b54\u30c7\u30fc\u30bf\uff08 <code>\u30c7\u30fc\u30bf <\/code> \u30b7\u30fc\u30c8\uff09\u3068 <code>\u30de\u30b9\u30bf\u30fc <\/code> \u3092\u30e1\u30fc\u30eb\u3067\u7d50\u5408\u3057\u3001<b>\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\uff08\u6607\u9806\uff09\u3067\u30bd\u30fc\u30c8<\/b>\u3057\u3066\u51fa\u529b\u3059\u308b\u6570\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n<p>Excel<\/p>\n<pre><code>=LET(\r\nd_ts, '\u30c7\u30fc\u30bf'!A2:A,\r\nd_emails, '\u30c7\u30fc\u30bf'!B2:B,\r\nd_ans, '\u30c7\u30fc\u30bf'!C2:D,\r\nm_keys, ARRAYFORMULA(LOWER(TRIM('\u30de\u30b9\u30bf\u30fc'!A2:A))),\r\nm_no, '\u30de\u30b9\u30bf\u30fc'!B2:B,\r\nm_info, '\u30de\u30b9\u30bf\u30fc'!C2:D,\r\njoined, MAP(d_ts, d_emails, SEQUENCE(ROWS(d_emails)), LAMBDA(t, e, idx,\r\nIF(t=\"\", {\"\",\"\",\"\",\"\",\"\",\"\",\"\"},\r\nLET(\r\nk, LOWER(TRIM(e)),\r\nno_val, XLOOKUP(k, m_keys, m_no, 999999),\r\ninfo_val, XLOOKUP(k, m_keys, m_info, {\"\u672a\u767b\u9332\", \"\"}),\r\nHSTACK(no_val, info_val, e, t, INDEX(d_ans, idx))\r\n)\r\n)\r\n)),\r\nvalid_rows, FILTER(joined, INDEX(joined, 0, 5)&lt;&gt;\"\"),\r\nSORT(valid_rows, 1, TRUE)\r\n)\r\n<\/code><\/pre>\n<h4>\u3053\u306e\u6570\u5f0f\u306e\u30dd\u30a4\u30f3\u30c8<\/h4>\n<ul>\n<li><b>\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\u30921\u5217\u76ee\uff08 <code>no_val <\/code>\uff09\u306b\u914d\u7f6e\uff1a<\/b> \u6700\u5f8c\u306b <code>SORT(valid_rows, 1, TRUE) <\/code> \u3068\u3059\u308b\u3053\u3068\u3067\u30011\u5217\u76ee\uff08\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\uff09\u306e\u6607\u9806\uff08\u5c0f\u3055\u3044\u9806\uff09\u306b\u81ea\u52d5\u3067\u4e26\u3073\u307e\u3059\u3002<\/li>\n<li><b>\u30de\u30b9\u30bf\u672a\u767b\u9332\u30e1\u30fc\u30eb\u306e\u6271\u3044\uff1a<\/b> <code>XLOOKUP <\/code> \u306e\u898b\u3064\u304b\u3089\u306a\u3044\u3068\u304d\u306e\u5024\u3092 <code>999999 <\/code> \u306b\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u30de\u30b9\u30bf\u30fc\u306b\u672a\u767b\u9332\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u3042\u3063\u3066\u3082\u30a8\u30e9\u30fc\u306b\u306a\u3089\u305a\u3001\u30bd\u30fc\u30c8\u6642\u306b\u4e00\u756a\u4e0b\u3078\u56de\u308a\u307e\u3059\uff08\u756a\u53f7\u304c\u6570\u5024\u3067\u306f\u306a\u304f\u6587\u5b57\u5217\u30fb\u30b3\u30fc\u30c9\u306e\u5834\u5408\u306f <code>\"\" <\/code> \u3084 <code>\"ZZZZ\" <\/code> \u306a\u3069\u904b\u7528\u306b\u5408\u308f\u305b\u3066\u8abf\u6574\u3057\u3066\u304f\u3060\u3055\u3044\uff09\u3002<\/li>\n<li><b>\u30bd\u30fc\u30c8\u57fa\u6e96\u306e\u5207\u308a\u66ff\u3048\uff1a<\/b> \u3082\u3057\u300c\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\u9806\u3067\u306f\u306a\u304f\u3001\u56de\u7b54\u306e\u65b0\u3057\u3044\u9806\u306b\u623b\u3057\u305f\u3044\u300d\u3068\u601d\u3063\u305f\u3089\u3001 <code>SORT(valid_rows, 1, TRUE) <\/code> \u306e\u7b2c2\u5f15\u6570\u3092 <code>5 <\/code>\uff08\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u5217\uff09\u306b\u3057\u3001\u7b2c3\u5f15\u6570\u3092 <code>FALSE <\/code> \u306b\u5909\u3048\u308b\u3060\u3051\u3067\u5207\u308a\u66ff\u3048\u3089\u308c\u307e\u3059\u3002<\/li>\n<\/ul>\n<h3>\u5b9f\u52d9\u4e0a\u306e\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8<\/h3>\n<ul>\n<li><b>\u30de\u30b9\u30bf\u30fc\u5074\u306e\u300c\u756a\u53f7\u300d\u3068\u300c\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u300d\u306e\u91cd\u8907\uff1a<\/b> \u30de\u30b9\u30bf\u30fc\u30b7\u30fc\u30c8\u306b\u540c\u3058\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u8907\u6570\u884c\u3042\u308b\u3068\u3001\u6700\u521d\u306b\u898b\u3064\u304b\u3063\u305f\u884c\u306e\u756a\u53f7\u30fb\u60c5\u5831\u304c\u4f7f\u308f\u308c\u307e\u3059\u3002\u30de\u30b9\u30bf\u30fc\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u306f\u4e00\u610f\u306b\u306a\u308b\u3088\u3046\u7ba1\u7406\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<li><b>\u756a\u53f7\u306e\u4e26\u3073\u9806\uff08\u6570\u5024 vs \u6587\u5b57\u5217\uff09\uff1a<\/b> <code>1, 2, 10 <\/code> \u306e\u3088\u3046\u306a\u756a\u53f7\u3092\u6607\u9806\u30bd\u30fc\u30c8\u3059\u308b\u3068\u304d\u3001\u3059\u3079\u3066\u6570\u5024\u3068\u3057\u3066\u5165\u3063\u3066\u3044\u308c\u3070 <code>1 \u2192 2 \u2192 10 <\/code> \u306e\u9806\u306b\u306a\u308a\u307e\u3059\u304c\u3001\u4e00\u90e8\u304c\u6587\u5b57\u5217\u3060\u3068\u6587\u5b57\u5217\u9806\uff08 <code>1 \u2192 10 \u2192 2 <\/code>\uff09\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u756a\u53f7\u5217\u306f\u6570\u5024\uff08\u307e\u305f\u306f\u6841\u63c3\u3048\u3057\u305f\u30b3\u30fc\u30c9\uff09\u3067\u7d71\u4e00\u3057\u3066\u304a\u304f\u306e\u304c\u78ba\u5b9f\u3067\u3059\u3002<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h1>\u30de\u30b9\u30bf\u30fc\u306b\u51fa\u6b20\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u306f\uff1f<\/h1>\n<p>\u5148\u307b\u3069\u306f\u300cGoogle \u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54\uff08\u6700\u65b0\u7248\uff09\u3092\u8ef8\u306b\u3057\u3066\u3001\u30de\u30b9\u30bf\u30fc\u306e\u60c5\u5831\u3092\u4ed8\u3051\u8db3\u3057\u3001\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\u3067\u30bd\u30fc\u30c8\u3059\u308b\u300d\u6d41\u308c\u3067\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u9006\u306b <b>\u300c\u30de\u30b9\u30bf\u30fc\u30c7\u30fc\u30bf\uff08\u540d\u7c3f\u30fb\u53f0\u5e33\u306a\u3069\uff09\u3092\u8ef8\u306b\u3057\u3066\u3001\u305d\u306e\u884c\u3054\u3068\u306b\u6700\u65b0\u306e\u30d5\u30a9\u30fc\u30e0\u56de\u7b54\u3092\u5f15\u3063\u5f35\u308a\u51fa\u3057\u3001\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8\u3092\u4f5c\u308b\u300d<\/b> \u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u5f62\u306b\u3059\u308b\u3068\u3001<b>\u30de\u30b9\u30bf\u30fc\u30c7\u30fc\u30bf\u306e\u4e26\u3073\u9806\u304c\u305d\u306e\u307e\u307e\u57fa\u6e96\u306b\u306a\u308a\u3001\u307e\u3060\u56de\u7b54\u3057\u3066\u3044\u306a\u3044\u4eba\uff08\u672a\u56de\u7b54\u8005\uff09\u3082\u6f0f\u308c\u306a\u304f\u4e00\u89a7\u306b\u8f09\u305b\u3089\u308c\u308b<\/b>\u306e\u304c\u5927\u304d\u306a\u5229\u70b9\u3067\u3059\u3002<\/p>\n<h3>1. \u30b7\u30fc\u30c8\u306e\u69cb\u6210\u4f8b<\/h3>\n<ul>\n<li><b><code>\u30de\u30b9\u30bf\u30fc <\/code><\/b>\uff08\u57fa\u6e96\u3068\u306a\u308b\u53f0\u5e33\u30fb\u540d\u7c3f\uff09\n<ul>\n<li><code>A <\/code>\u5217\uff1a\u756a\u53f7\uff08\u307e\u305f\u306fID\u30fb\u7ba1\u7406\u756a\u53f7\uff09 \/ <code>B <\/code>\u5217\uff1a\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\uff08\u203b\u7d50\u5408\u30ad\u30fc\uff09 \/ <code>C <\/code>\u5217\uff1a\u6c0f\u540d \/ <code>D <\/code>\u5217\uff1a\u6240\u5c5e<\/li>\n<\/ul>\n<\/li>\n<li><b><code>\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 1 <\/code><\/b>\uff08\u30d5\u30a9\u30fc\u30e0\u81ea\u52d5\u751f\u6210\uff09\n<ul>\n<li><code>A <\/code>\u5217\uff1a\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7 \/ <code>B <\/code>\u5217\uff1a\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9 \/ <code>C <\/code>\u5217\u4ee5\u964d\uff1a\u56de\u7b54\u5185\u5bb9\uff08\u4f8b\uff1a <code>C <\/code>\u5217\uff1d\u51fa\u6b20\u3001 <code>D <\/code>\u5217\uff1d\u5099\u8003\uff09<\/li>\n<\/ul>\n<\/li>\n<li><b><code>\u65b0\u30c7\u30fc\u30bf <\/code> \u30b7\u30fc\u30c8<\/b>\uff08\u65b0\u3057\u304f\u4f5c\u6210\u3059\u308b\u30b7\u30fc\u30c8\uff09<\/li>\n<\/ul>\n<p>\u203b\u30de\u30b9\u30bf\u30fc\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c <code>A <\/code> \u5217\u306b\u3042\u308b\u5834\u5408\u306f\u3001\u6570\u5f0f\u5185\u306e <code>m_emails <\/code> \u3092 <code>'\u30de\u30b9\u30bf\u30fc'!A2:A <\/code>\u3001 <code>m_base <\/code> \u3092 <code>'\u30de\u30b9\u30bf\u30fc'!B2:D <\/code> \u306e\u3088\u3046\u306b\u5217\u4f4d\u7f6e\u306b\u5408\u308f\u305b\u3066\u8aad\u307f\u66ff\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h3>2. \u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u4f5c\u308b\u624b\u9806<\/h3>\n<ol>\n<li>\u753b\u9762\u5de6\u4e0b\u306e <b> <code>+ <\/code><\/b> \u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u8ffd\u52a0\u3057\u3001\u540d\u524d\u3092 <b> <code>\u65b0\u30c7\u30fc\u30bf <\/code><\/b> \u306b\u3057\u307e\u3059\u3002<\/li>\n<li>1\u884c\u76ee\uff08 <code>A1:G1 <\/code>\uff09\u306b\u898b\u51fa\u3057\u3092\u5165\u308c\u307e\u3059\u3002\n<ul>\n<li>\u4f8b\uff1a <code>A1 <\/code>= <code>\u756a\u53f7 <\/code>\u3001 <code>B1 <\/code>= <code>\u6c0f\u540d <\/code>\u3001 <code>C1 <\/code>= <code>\u6240\u5c5e <\/code>\u3001 <code>D1 <\/code>= <code>\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9 <\/code>\u3001 <code>E1 <\/code>= <code>\u6700\u65b0\u56de\u7b54\u65e5\u6642 <\/code>\u3001 <code>F1 <\/code>= <code>\u51fa\u6b20 <\/code>\u3001 <code>G1 <\/code>= <code>\u5099\u8003 <\/code><\/li>\n<\/ul>\n<\/li>\n<li><b><code>A2 <\/code> \u30bb\u30eb<\/b>\u306b\u3001\u6b21\u306e\u6570\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n<p>Excel<\/p>\n<p>&nbsp;<\/p>\n<pre><code>=LET(\r\nm_no, '\u30de\u30b9\u30bf\u30fc'!A2:A,\r\nm_emails, '\u30de\u30b9\u30bf\u30fc'!B2:B,\r\nm_info, '\u30de\u30b9\u30bf\u30fc'!C2:D,\r\nr_ts, '\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 1'!A2:A,\r\nr_emails, ARRAYFORMULA(LOWER(TRIM('\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 1'!B2:B))),\r\nr_ans, '\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54 1'!C2:D,\r\n\/* \u56de\u7b54\u30c7\u30fc\u30bf\u3092\u300c\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u964d\u9806\uff08\u65b0\u3057\u3044\u9806\uff09\u300d\u306b\u4e26\u3079\u66ff\u3048 *\/\r\norder_desc, SORTN(\r\nHSTACK(r_ts, r_emails, r_ans, SEQUENCE(ROWS(r_ts))),\r\nROWS(r_ts), 0, 1, FALSE\r\n),\r\ns_emails, INDEX(order_desc, 0, 2),\r\ns_ans, CHOOSECOLS(order_desc, 3, 4),\r\ns_ts, INDEX(order_desc, 0, 1),\r\nMAP(m_no, m_emails, SEQUENCE(ROWS(m_no)), LAMBDA(no, em, idx,\r\nIF(AND(no=\"\", em=\"\"), {\"\",\"\",\"\",\"\",\"\",\"\",\"\"},\r\nLET(\r\nk, LOWER(TRIM(em)),\r\n\/* \u65b0\u3057\u3044\u9806\u306b\u4e26\u3093\u3067\u3044\u308b\u305f\u3081\u3001XLOOKUP\u3067\u6700\u521d\u306b\u898b\u3064\u304b\u308b\uff1d\u6700\u65b0\u56de\u7b54 *\/\r\nhit_ts, IF(k=\"\", \"\", XLOOKUP(k, s_emails, s_ts, \"\u672a\u56de\u7b54\")),\r\nhit_ans, IF(k=\"\", {\"\",\"\"}, XLOOKUP(k, s_emails, s_ans, {\"\",\"\"})),\r\nHSTACK(no, INDEX(m_info, idx), em, hit_ts, hit_ans)\r\n)\r\n)\r\n))\r\n)\r\n<\/code><\/pre>\n<h3>3. \u3053\u306e\u65b9\u6cd5\u306e\u30e1\u30ea\u30c3\u30c8\u3068\u6ce8\u610f\u70b9<\/h3>\n<ul>\n<li><b>\u672a\u56de\u7b54\u8005\u304c\u81ea\u52d5\u3067\u628a\u63e1\u3067\u304d\u308b\uff1a<\/b> \u30de\u30b9\u30bf\u30fc\u5074\u306e\u5168\u54e1\u304c\u4e26\u3076\u305f\u3081\u3001\u56de\u7b54\u304c\u307e\u3060\u6765\u3066\u3044\u306a\u3044\u4eba\u306f <code>\u6700\u65b0\u56de\u7b54\u65e5\u6642 <\/code> \u306b <code>\"\u672a\u56de\u7b54\" <\/code> \u3068\u8868\u793a\u3055\u308c\u3001\u56de\u7b54\u5185\u5bb9\uff08 <code>\u51fa\u6b20 <\/code>\u30fb <code>\u5099\u8003 <\/code>\uff09\u306f\u7a7a\u6b04\u306b\u306a\u308a\u307e\u3059\u3002<\/li>\n<li><b>\u300c\u6700\u65b0\u56de\u7b54\u300d\u306e\u5224\u5b9a\u304c\u30b7\u30f3\u30d7\u30eb\u306b\u306a\u308b\uff1a<\/b> \u4e8b\u524d\u306b\u56de\u7b54\u30c6\u30fc\u30d6\u30eb\u5168\u4f53\u3092 <code>SORTN(..., ROWS(r_ts), 0, 1, FALSE) <\/code> \u3067\u300c\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u65b0\u3057\u3044\u9806\u300d\u306b\u4e26\u3079\u3066\u304a\u3051\u3070\u3001 <code>XLOOKUP <\/code> \u306f\u4e0a\u304b\u3089\u63a2\u3057\u3066\u6700\u521d\u306b\u898b\u3064\u304b\u3063\u305f\u884c\uff08\uff1d\u6700\u65b0\u56de\u7b54\uff09\u3092\u81ea\u52d5\u3067\u8fd4\u3057\u307e\u3059\uff08\u8907\u6570\u56de\u56de\u7b54\u3057\u3066\u3044\u3066\u3082\u6700\u65b01\u4ef6\u3060\u3051\u304c\u63a1\u7528\u3055\u308c\u307e\u3059\uff09\u3002<\/li>\n<li><b>\u30bd\u30fc\u30c8\u64cd\u4f5c\u304c\u4e0d\u8981\uff1a<\/b> \u305d\u3082\u305d\u3082 <code>\u30de\u30b9\u30bf\u30fc <\/code> \u30b7\u30fc\u30c8\u306e\u884c\u9806\uff08\u756a\u53f7\u9806\u306a\u3069\uff09\u3092\u30d9\u30fc\u30b9\u306b <code>MAP <\/code> \u3067\u56de\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u30de\u30b9\u30bf\u30fc\u5074\u304c\u756a\u53f7\u9806\u306b\u4e26\u3093\u3067\u3044\u308c\u3070\u3001\u51fa\u529b\u30b7\u30fc\u30c8\u3082\u305d\u306e\u307e\u307e\u756a\u53f7\u9806\u306b\u306a\u308a\u307e\u3059\u3002\u3082\u3057\u30de\u30b9\u30bf\u30fc\u5074\u304c\u756a\u53f7\u9806\u306b\u306a\u3063\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001\u5168\u4f53\u3092 <code>SORT(..., 1, TRUE) <\/code> \u3067\u56f2\u3081\u3070\u756a\u53f7\u9806\u306b\u4e26\u3079\u66ff\u3048\u3089\u308c\u307e\u3059\u3002<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u51fa\u6b20\u306b\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5 Google \u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54\u304b\u3089\u300c\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3054\u3068\u306e\u6700\u65b0\u7248\u3060\u3051\u300d\u3092\u62bd\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u30b7\u30fc\u30c8\u3092\u4f5c\u308a\u3001\u305d\u308c\u3092\u30de\u30b9\u30bf\u30fc\u306e\u756a\u53f7\uff08\u9023\u756a\u30fb\u7ba1\u7406\u756a\u53f7\u306a\u3069\uff09\u3067\u4e26\u3079\u66ff\u3048\u3066\u51fa\u529b\u30b7\u30fc\u30c8\u306b\u4f5c\u308b\u624b\u9806\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002  [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"common","vkexunit_cta_each_option":"","_lightning_design_setting":{"layout":"default"},"footnotes":"","vk-ltc-link":"","vk-ltc-target":"0"},"categories":[24],"tags":[],"class_list":["post-8243","post","type-post","status-publish","format-standard","hentry","category-iot-it"],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/posts\/8243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/comments?post=8243"}],"version-history":[{"count":2,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/posts\/8243\/revisions"}],"predecessor-version":[{"id":8245,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/posts\/8243\/revisions\/8245"}],"wp:attachment":[{"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/media?parent=8243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/categories?post=8243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/tags?post=8243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}