{"id":71,"date":"2010-05-10T08:38:32","date_gmt":"2010-05-09T23:38:32","guid":{"rendered":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/?p=71"},"modified":"2025-05-13T15:44:39","modified_gmt":"2025-05-13T06:44:39","slug":"pl-2","status":"publish","type":"post","link":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/2010\/05\/pl-2.html","title":{"rendered":"Excel\u3067\u4f5c\u3063\u3066\u307f\u3088\u3046\uff5ePL\u5b9f\u8df5\u7de8\uff08\uff15\uff09\u5206\u6790\u30b7\u30fc\u30c8\uff11\uff5e"},"content":{"rendered":"

\n

\n

\u4f1a\u8a08\u7ba1\u7406\u8868\uff08\u4e88\u7b97\u5b9f\u7e3e\u7ba1\u7406\u8868\uff09\u306e\u5b9f\u969b\u306b\u4f5c\u308b\u904e\u7a0b\u3092<\/span><\/p>\n

\u3054\u7d39\u4ecb\u3057\u306a\u304c\u3089\u3001<\/span><\/p>\n

Excel\u306e\u5c0f\u6280\u3082\u5408\u308f\u305b\u3066\u3001\u9023\u8f09\u3067\u3000\u3054\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/span><\/span><\/p>\n


\n<\/span>\u203b\u79c1\u306e\u50cd\u3044\u3066\u3044\u308b\u3001\u3053\u3053\u30cb\u30e5\u30fc\u30b3\u30e0\u3067\u306f\u3001
\n\u300c\u4e88\u7b97\u3068\u5b9f\u7e3e\u306e\u7ba1\u7406\u3092EXCEL\u3067Web\u5316\u3059\u308b\u30bd\u30fc\u30b9\u516c\u958b\u578b\u30d1\u30c3\u30b1\u30fc\u30b8<\/a>\u300d\u3092\u30ea\u30ea\u30fc\u30b9
\n\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u30a8\u30af\u30bb\u30eb\u3092\u4f7f\u3063\u305f\u4e88\u7b97\u5b9f\u7e3e\u7ba1\u7406\u306e\u305f\u3081\u306e\u4f55\u304b\u826f\u3044\u30b7\u30b9\u30c6\u30e0\u3092
\n\u304a\u63a2\u3057\u306e\u65b9\u306f\u305c\u3072\u3054\u89a7\u304f\u3060\u3055\u3044\u3002
\n
\n<\/span><\/span><\/p>\n

\uff1c\u53c2\u7167\u7528\u30b7\u30fc\u30c8\u306e\u3054\u7d39\u4ecb\uff1e<\/b><\/span><\/span><\/p>\n

\u2460<\/span>\u7ba1\u7406\u8005\u7528\u3000\u3068\u3000\u2461\u7d4c\u55b6\u8005\u3000\u306e\u30b7\u30fc\u30c8\u304c\u3042\u308a\u307e\u3059\u3002<\/span><\/b><\/span><\/b><\/span><\/b><\/span><\/b><\/span><\/b><\/span><\/span><\/p>\n

\u305d\u308c\u305e\u308c<\/span><\/b><\/span><\/b><\/span><\/b><\/span><\/b><\/span><\/b>\u76ee\u7684\u3001\u8996\u70b9\u304c\u9055\u3046\u305f\u3081\u3001\u5225\u30b7\u30fc\u30c8\u3067\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/span><\/b><\/span><\/b><\/span><\/b><\/span><\/b><\/span><\/b><\/span><\/span><\/p>\n

\uff08\u7ba1\u7406\u8005\u7528\u30b7\u30fc\u30c8\uff09\u3000\u3000\u3000\u3000\u3000\uff08\u7d4c\u55b6\u8005\u7528\u30b7\u30fc\u30c8\uff09<\/span><\/span><\/p>\n

\n

\"tukurub-11.JPG\"<\/a><\/span><\/b><\/b><\/b><\/b><\/b><\/span><\/p>\n

\n

\n

\n

\n

\n

\n

\n

\n

\u2460\u7ba1\u7406\u8005<\/b><\/b><\/b>\u7528\u30b7\u30fc\u30c8\u306e\u4f5c\u6210<\/b><\/span><\/span><\/p>\n

\u5165\u529b\u30b7\u30fc\u30c8\uff08\u4e88\u7b97\u3001\u5b9f\u7e3e\uff09\u306e\u6570\u5b57\u304c\u81ea\u52d5\u7684\u306b\u53cd\u6620<\/b>\u3055\u308c\u3001<\/span><\/span><\/p>\n

\u4e88\u7b97\u3001\u5b9f\u7e3e\u3001\u9054\u6210\u7387\u304c\u3001\u4e00\u5ea6\u306b\u628a\u63e1\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/b><\/span><\/span><\/p>\n

\n

\u534a\u671f\u3001\u56db\u534a\u671f\u3001\u5e74\u9593\u306e\u5408\u8a08\u304c\u4e00\u76ee\u3067\u308f\u304b\u308b\u30b7\u30fc\u30c8\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/b><\/span><\/span><\/p>\n

Excel\u30b7\u30fc\u30c8\u3060\u3068\u3001\u67d4\u8edf\u306b\u5408\u8a08\u5217\uff08\u56db\u534a\u671f\u3001\u534a\u671f\u3001\u5e74\u9593\uff09\u3092\u8ffd\u52a0\u8868\u793a\u3067\u304d\u3001<\/span><\/span><\/p>\n

\u624b\u8efd\u306b\u5206\u6790\u3057\u3084\u3059\u3044\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3067\u304d\u308b\u306e\u304c\u30e1\u30ea\u30c3\u30c8\u3067\u3059\u3002<\/span><\/span><\/p>\n

\n

\uff08\u7ba1\u7406\u8005\u7528\u306e\u90e8\u9580\u5225\u30b7\u30fc\u30c8\uff09<\/span><\/span><\/p>\n

\n

\"tukuru-5-2.JPG\"<\/a><\/span><\/span><\/p>\n

<\/div>\n
\u30fb\u300c\u90e8\u9580\uff11\uff08\u7ba1\u7406\u8005\uff09\u300d\u30b7\u30fc\u30c8\u3092\u958b\u304d\u307e\u3059\u3002<\/span><\/span><\/span><\/div>\n
\u3000\u30bb\u30ebB5<\/b>\u306b\u6b21\u306e\u3088\u3046\u306a\u6570\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/span><\/span><\/div>\n
\u3000\u3000\u3000\u300c\uff1d\u4e88\u7b97\u5165\u529b!B4\u300d<\/b>\u3000<\/span><\/span><\/div>\n
\"tukurub-3.JPG\"<\/a><\/span><\/span><\/span><\/div>\n
\u203b\u300c\uff1d<\/b>\u300d\uff08\u30a4\u30b3\u30fc\u30eb\uff09\u3092\u5165\u529b\u3057\u3066\u305d\u306e\u307e\u307e<\/span><\/div>\n
\n
\u300c\u4e88\u7b97\u5165\u529b\u300d\u30b7\u30fc\u30c8\u306e\u30bb\u30ebB4<\/b>\u3092\u30af\u30ea\u30c3\u30af\u3057\uff08\u4e0b\u56f3\uff09\u3001\u300cOK\u300d<\/b>\u3092\u62bc\u3057\u307e\u3059\u3002<\/span><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\"tukurub-2.JPG\u306e\u30b5\u30e0\u30cd\u30fc\u30eb\u753b\u50cf\"<\/a><\/span><\/span><\/span><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u30fb\u90e8\u9580\uff11\uff08\u7ba1\u7406\u8005\uff09\u30b7\u30fc\u30c8\u306eB5\u306e\u6570\u5f0f\u3092\u4e0b\u306e\u30bb\u30eb\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/span><\/div>\n
\u5341\u5b57\u306e\u72b6\u614b\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/span><\/span><\/div>\n
\"tukurub-4.JPG\"<\/a><\/span><\/span><\/span><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u30fb\u300c\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u300c\u66f8\u5f0f\u306a\u3057\u30b3\u30d4\u30fc\u300d\u3092\u62bc\u3057\u307e\u3059\u3002<\/span><\/span><\/div>\n
\"tukurub-7.JPG\"<\/a><\/span><\/span><\/span><\/div>\n<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u30fb\u5b9f\u7e3e\uff08\u96a3\u308a\u306e\u5217\uff09\u3082\u540c\u69d8\u306b\u4eca\u5ea6\u306f\u300c\u5b9f\u7e3e\u5165\u529b\u30b7\u30fc\u30c8\u300d\u3092\u53c2\u7167\u3059\u308b\u6570\u5f0f\u3092\u5165\u529b\u3057\u3001\u4e0b\u306e\u30bb\u30eb\u307e\u3067\u30b3\u30d4\u30fc\u3092\u3057\u307e\u3059\u3002<\/span><\/div>\n
\"tukurub-8.JPG\"<\/a><\/span><\/span><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u30fb\u9054\u6210\u7387\u306e\u5217\u306b\u3001\u6b21\u306e\u3088\u3046\u306a\u6570\u5f0f\u3092\u5165\u308c\u3001\u4e0b\u306e\u30bb\u30eb\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/span><\/div>\n
\u3000\u3000\u3000\u300c\u3000\uff1d<\/span><\/span>IF<\/span><\/span>\uff08<\/span><\/span>OR<\/span><\/span>\uff08<\/span><\/span>B5<\/span><\/span>\uff1d\uff10<\/span><\/span>,B<\/span><\/span>\uff15\uff1d<\/span><\/span>“”<\/span><\/span>\uff09<\/span><\/span>,””,C5\/B5<\/span><\/span>\uff09<\/span><\/span>\u3000\u300d<\/b><\/span><\/span><\/div>\n
<\/div>\n
\u203b\u3053\u306e\u6570\u5f0f\u306f\u3001B\u5217\u304c\u7a7a\u767d\u306e\u3068\u304d\u30a8\u30e9\u30fc\u3092\u8868\u793a\u3057\u306a\u3044\u305f\u3081\u3001<\/b><\/span><\/span><\/div>\n
\u3000IF\u95a2\u6570\u3092\u53d6\u308a\u5165\u308c\u305f\u6570\u5f0f\uff08\u9054\u6210\u7387\u304c\u6c42\u3081\u3089\u308c\u308b\uff09\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/b><\/span><\/b><\/span><\/b><\/span><\/span><\/div>\n
\"tukurub-10.JPG\"<\/a><\/span><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u30fb\u4e0b\u56f3\u306e\u3088\u3046\u306b\u3001\u56db\u534a\u671f\u3054\u3068\u3001\u534a\u671f\u3054\u3068\u3001\u5e74\u9593\u306e\u5408\u8a08\u5217\u3092\u8868\u793a\u3057\u306a\u304c\u3089\u3001<\/span><\/div>\n
\u5206\u6790\u3067\u304d\u308b\u3088\u3046\u306a\u30b7\u30fc\u30c8\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/span><\/div>\n
\"tukurub-12.JPG\"<\/a><\/span><\/span><\/div>\n
<\/div>\n
\uff08\u56db\u534a\u671f\u5408\u8a08\uff09<\/div>\n
\uff14\uff0c\uff15\uff0c\uff16\u6708\uff08\uff13\u30ab\u6708\u5206\uff09\u306e\u5408\u8a08\u3092\u51fa\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\uff08\u534a\u671f\u5408\u8a08\uff09<\/div>\n
\u56db\u534a\u671f\u3053\u3068\u306e\u5408\u8a08\u3092\u8db3\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\uff08\u5e74\u9593\u5408\u8a08\uff09<\/div>\n
\u534a\u671f\u3054\u3068\u306e\u5408\u8a08\u3092\u8db3\u3059\u6570\u5f0f\u3092\u5165\u529b\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u7ba1\u7406\u8005\u306f\u3001\u4e88\u7b97\u3001\u5b9f\u7e3e\u3001\u9054\u6210\u7387\u306a\u3069\u3001\u6570\u5b57\u3092\u5e38\u306b\u628a\u63e1\u3057\u305f\u3044\u306e\u3067\u3001<\/span><\/div>\n
\u305d\u306e\u70b9\u3092\u8003\u616e\u3057\u3066\u3001\u3054\u7d39\u4ecb\u3057\u305f\u3088\u3046\u306a\u3001\u53c2\u7167\uff08\u5206\u6790\uff09\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/span><\/div>\n
<\/div>\n
\u305c\u3072\u3001\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002<\/span><\/div>\n
\u6b21\u30da\u30fc\u30b8<\/a><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

\u4f1a\u8a08\u7ba1\u7406\u8868\uff08\u4e88\u7b97\u5b9f\u7e3e\u7ba1\u7406\u8868\uff09\u306e\u5b9f\u969b\u306b\u4f5c\u308b\u904e\u7a0b\u3092 \u3054\u7d39\u4ecb\u3057\u306a\u304c\u3089\u3001 Excel\u306e\u5c0f\u6280\u3082\u5408\u308f\u305b\u3066\u3001\u9023\u8f09\u3067\u3000\u3054\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\u3059\u3002 \u203b\u79c1\u306e\u50cd\u3044\u3066\u3044\u308b\u3001\u3053\u3053\u30cb\u30e5\u30fc\u30b3\u30e0\u3067\u306f\u3001 \u300c\u4e88\u7b97\u3068\u5b9f\u7e3e\u306e\u7ba1\u7406\u3092EXCEL\u3067Web\u5316\u3059\u308b\u30bd\u30fc\u30b9\u516c\u958b\u578b […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[10],"tags":[],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-10"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/comments?post=71"}],"version-history":[{"count":1,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":2300,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/71\/revisions\/2300"}],"wp:attachment":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media?parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/categories?post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/tags?post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}