{"id":802,"date":"2020-02-05T07:03:00","date_gmt":"2020-02-05T00:03:00","guid":{"rendered":"http:\/\/www.gis2me.com\/geospatial\/?p=802"},"modified":"2025-04-30T09:34:39","modified_gmt":"2025-04-30T02:34:39","slug":"excel4gis-%e0%b8%a5%e0%b8%9a%e0%b8%8a%e0%b8%b7%e0%b9%88%e0%b8%ad%e0%b8%88%e0%b8%b1%e0%b8%87%e0%b8%ab%e0%b8%a7%e0%b8%b1%e0%b8%94%e0%b8%97%e0%b8%b5%e0%b9%88%e0%b8%a1%e0%b8%b5%e0%b8%84%e0%b9%88","status":"publish","type":"post","link":"http:\/\/www.gis2me.com\/geospatial\/?p=802","title":{"rendered":"Excel4GIS : \u0e25\u0e1a\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e17\u0e35\u0e48\u0e21\u0e35\u0e04\u0e48\u0e32\u0e0b\u0e49\u0e33 remove duplicate \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e19\u0e33\u0e21\u0e32\u0e17\u0e33 Dropdown List"},"content":{"rendered":"<p>Excel4GIS : \u0e25\u0e1a\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e17\u0e35\u0e48\u0e21\u0e35\u0e04\u0e48\u0e32\u0e0b\u0e49\u0e33 remove duplicate \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e19\u0e33\u0e21\u0e32\u0e17\u0e33 Dropdown List \u0e25\u0e1a\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e17\u0e35\u0e48\u0e21\u0e35\u0e04\u0e48\u0e32\u0e0b\u0e49\u0e33\u0e14\u0e49\u0e27\u0e22\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 remove duplicate \u0e2a\u0e23\u0e49\u0e32\u0e07 list \u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e14\u0e49\u0e27\u0e22 Dropdown List \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e25\u0e14\u0e02\u0e49\u0e2d\u0e1c\u0e34\u0e14\u0e1e\u0e25\u0e32\u0e14\u0e08\u0e32\u0e01\u0e01\u0e32\u0e23\u0e1e\u0e34\u0e21\u0e1e\u0e4c<br \/>\u0e43\u0e19\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07 <strong data-start=\"11\" data-end=\"50\">Dropdown List \u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e41\u0e1a\u0e1a\u0e44\u0e21\u0e48\u0e21\u0e35\u0e04\u0e48\u0e32\u0e0b\u0e49\u0e33<\/strong> (Unique) \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19\u0e43\u0e19 Excel \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e25\u0e14\u0e04\u0e27\u0e32\u0e21\u0e1c\u0e34\u0e14\u0e1e\u0e25\u0e32\u0e14\u0e43\u0e19\u0e01\u0e32\u0e23\u0e1e\u0e34\u0e21\u0e1e\u0e4c\u0e41\u0e25\u0e30\u0e40\u0e15\u0e23\u0e35\u0e22\u0e21\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e43\u0e19\u0e07\u0e32\u0e19 GIS \u0e2b\u0e23\u0e37\u0e2d\u0e41\u0e1a\u0e1a\u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e14\u0e34\u0e08\u0e34\u0e17\u0e31\u0e25 \u0e04\u0e38\u0e13\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e17\u0e33\u0e15\u0e32\u0e21\u0e02\u0e31\u0e49\u0e19\u0e15\u0e2d\u0e19\u0e15\u0e48\u0e2d\u0e44\u0e1b\u0e19\u0e35\u0e49 \u0e42\u0e14\u0e22\u0e2d\u0e34\u0e07\u0e08\u0e32\u0e01\u0e44\u0e1f\u0e25\u0e4c\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 <a class=\"\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1UJdsMIiuv5Sy56EcdDpXg5zH__0GOboRCp-TS68wmds\/edit#gid=0\" target=\"_new\" rel=\"noopener\" data-start=\"221\" data-end=\"336\">\u0e42\u0e23\u0e07\u0e1e\u0e22\u0e32\u0e1a\u0e32\u0e25 44 \u0e41\u0e2b\u0e48\u0e07<\/a><\/p>\n<p>\u0e41\u0e2b\u0e25\u0e48\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e42\u0e23\u0e07\u0e1e\u0e22\u0e32\u0e1a\u0e32\u0e25 44 \u0e41\u0e2b\u0e48\u0e07 <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1UJdsMIiuv5Sy56EcdDpXg5zH__0GOboRCp-TS68wmds\/edit#gid=0\">https:\/\/docs.google.com\/spreadsheets\/d\/1UJdsMIiuv5Sy56EcdDpXg5zH__0GOboRCp-TS68wmds\/edit#gid=0<\/a><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/jCu7wTPnWEs\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n\n\n<h2 class=\"wp-block-heading\">\u2705 \u0e02\u0e31\u0e49\u0e19\u0e15\u0e2d\u0e19\u0e01\u0e32\u0e23 <strong>Remove Duplicate<\/strong> \u0e41\u0e25\u0e30\u0e2a\u0e23\u0e49\u0e32\u0e07 <strong>Dropdown List<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u278a <strong>\u0e25\u0e1a\u0e04\u0e48\u0e32\u0e0b\u0e49\u0e33\u0e43\u0e19\u0e23\u0e32\u0e22\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14 (Remove Duplicates)<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0e40\u0e1b\u0e34\u0e14 <strong>Google Sheets<\/strong> \u0e2b\u0e23\u0e37\u0e2d <strong>Microsoft Excel<\/strong> \u0e41\u0e25\u0e49\u0e27\u0e40\u0e25\u0e37\u0e2d\u0e01 <strong>\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c\u0e17\u0e35\u0e48\u0e21\u0e35\u0e23\u0e32\u0e22\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14<\/strong><\/li>\n\n\n\n<li>\u0e44\u0e1b\u0e17\u0e35\u0e48\u0e40\u0e21\u0e19\u0e39:\n<ul class=\"wp-block-list\">\n<li><strong>Excel<\/strong>: <code>Data<\/code> > <code>Remove Duplicates<\/code><\/li>\n\n\n\n<li><strong>Google Sheets<\/strong>: <code>Data<\/code> > <code>Data cleanup<\/code> > <code>Remove duplicates<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e43\u0e2b\u0e49\u0e41\u0e19\u0e48\u0e43\u0e08\u0e27\u0e48\u0e32\u0e40\u0e25\u0e37\u0e2d\u0e01\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c\u0e17\u0e35\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e25\u0e1a\u0e04\u0e48\u0e32\u0e0b\u0e49\u0e33 (\u0e40\u0e0a\u0e48\u0e19 <code>\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14<\/code>)<\/li>\n\n\n\n<li>\u0e01\u0e14 <strong>OK<\/strong> \u0e2b\u0e23\u0e37\u0e2d <strong>Remove duplicates<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udccc \u0e08\u0e30\u0e44\u0e14\u0e49\u0e23\u0e32\u0e22\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e0b\u0e49\u0e33\u0e01\u0e31\u0e19\u0e41\u0e25\u0e49\u0e27 \u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e19\u0e33\u0e44\u0e1b\u0e2a\u0e23\u0e49\u0e32\u0e07 list \u0e44\u0e14\u0e49<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u278b <strong>\u0e2a\u0e23\u0e49\u0e32\u0e07 Dropdown List \u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u25b6\ufe0f \u0e43\u0e19 <strong>Microsoft Excel<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0e04\u0e25\u0e34\u0e01\u0e40\u0e0b\u0e25\u0e25\u0e4c\u0e17\u0e35\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07 Dropdown (\u0e40\u0e0a\u0e48\u0e19 \u0e40\u0e0b\u0e25\u0e25\u0e4c\u0e43\u0e19\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c <code>\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14<\/code>)<\/li>\n\n\n\n<li>\u0e44\u0e1b\u0e17\u0e35\u0e48\u0e40\u0e21\u0e19\u0e39 <code>Data<\/code> > <code>Data Validation<\/code><\/li>\n\n\n\n<li>\u0e43\u0e19\u0e2b\u0e19\u0e49\u0e32\u0e15\u0e48\u0e32\u0e07 Data Validation:\n<ul class=\"wp-block-list\">\n<li>\u0e40\u0e25\u0e37\u0e2d\u0e01 <code>Allow: List<\/code><\/li>\n\n\n\n<li>\u0e43\u0e19\u0e0a\u0e48\u0e2d\u0e07 <code>Source<\/code> \u0e1e\u0e34\u0e21\u0e1e\u0e4c\u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e25\u0e37\u0e2d\u0e01\u0e0a\u0e48\u0e27\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e0b\u0e49\u0e33 (\u0e40\u0e0a\u0e48\u0e19 <code>=$F$2:$F$20<\/code>)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u0e01\u0e14 OK<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">\u25b6\ufe0f \u0e43\u0e19 <strong>Google Sheets<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0e04\u0e25\u0e34\u0e01\u0e40\u0e0b\u0e25\u0e25\u0e4c\u0e40\u0e1b\u0e49\u0e32\u0e2b\u0e21\u0e32\u0e22 > <code>Data<\/code> > <code>Data validation<\/code><\/li>\n\n\n\n<li>\u0e40\u0e25\u0e37\u0e2d\u0e01 <code>Criteria: List from a range<\/code><\/li>\n\n\n\n<li>\u0e23\u0e30\u0e1a\u0e38\u0e0a\u0e48\u0e27\u0e07 (\u0e40\u0e0a\u0e48\u0e19 <code>Sheet2!A2:A20<\/code>)<\/li>\n\n\n\n<li>\u0e01\u0e14 Save<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udfaf \u0e02\u0e49\u0e2d\u0e14\u0e35\u0e02\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49 Dropdown<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 \u0e25\u0e14\u0e04\u0e27\u0e32\u0e21\u0e1c\u0e34\u0e14\u0e1e\u0e25\u0e32\u0e14\u0e08\u0e32\u0e01\u0e01\u0e32\u0e23\u0e2a\u0e30\u0e01\u0e14\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e44\u0e21\u0e48\u0e16\u0e39\u0e01\u0e15\u0e49\u0e2d\u0e07<\/li>\n\n\n\n<li>\u2705 \u0e17\u0e33\u0e43\u0e2b\u0e49\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e43\u0e0a\u0e49\u0e23\u0e48\u0e27\u0e21\u0e01\u0e31\u0e1a\u0e23\u0e30\u0e1a\u0e1a GIS \u0e44\u0e14\u0e49\u0e17\u0e31\u0e19\u0e17\u0e35 \u0e40\u0e0a\u0e48\u0e19 QGIS, ArcGIS<\/li>\n\n\n\n<li>\u2705 \u0e40\u0e15\u0e23\u0e35\u0e22\u0e21\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e43\u0e2b\u0e49\u0e1e\u0e23\u0e49\u0e2d\u0e21\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e01\u0e32\u0e23 <strong>\u0e17\u0e33 Pivot Table<\/strong>, <strong>Geo Coding<\/strong>, <strong>Map Visualization<\/strong><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcda \u0e41\u0e2b\u0e25\u0e48\u0e07\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e40\u0e2a\u0e23\u0e34\u0e21<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udd17 <a class=\"\">Google Sheets &#8211; Remove duplicates<\/a><\/li>\n\n\n\n<li>\ud83d\udd17 <a class=\"\" href=\"https:\/\/support.microsoft.com\/th-th\/excel-data-validation\">Microsoft Excel &#8211; Data Validation Dropdown<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel4GIS : \u0e25\u0e1a\u0e0a\u0e37\u0e48\u0e2d\u0e08\u0e31\u0e07\u0e2b\u0e27\u0e31\u0e14\u0e17\u0e35\u0e48\u0e21\u0e35\u0e04\u0e48\u0e32\u0e0b\u0e49\u0e33 remove duplicate \u0e40 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[20],"tags":[616,618,611,610,612,609,617,613,619,606,62,607,614,615,608],"class_list":["post-802","post","type-post","status-publish","format-standard","hentry","category--excel","tag-cleaning-data","tag-data-preparation-gis","tag-data-validation-excel","tag-dropdown-list-excel","tag-excel-gis","tag-excel4gis","tag-geocoding","tag-google-sheets-dropdown","tag-hospital-data-thailand","tag-remove-duplicates","tag-62","tag-607","tag-614","tag--list-","tag--gis"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=802"}],"version-history":[{"count":1,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/802\/revisions"}],"predecessor-version":[{"id":803,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/802\/revisions\/803"}],"wp:attachment":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=802"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}