{"id":26895,"date":"2021-11-09T12:22:16","date_gmt":"2021-11-09T08:52:16","guid":{"rendered":"https:\/\/privateblog.maktabkhooneh.org\/mag\/?p=26895"},"modified":"2026-04-06T18:51:20","modified_gmt":"2026-04-06T15:21:20","slug":"identify-duplicate-data-in-excel","status":"publish","type":"post","link":"https:\/\/maktabkhooneh.org\/mag\/identify-duplicate-data-in-excel\/","title":{"rendered":"\u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644"},"content":{"rendered":"\n<p><span style=\"font-size: 14px;\">\u0627\u06af\u0631 \u0639\u0644\u0627\u0642\u0647 \u0645\u0646\u062f \u0628\u0647 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0645\u062d\u0628\u0648\u0628 \u0627\u06a9\u0633\u0644 \u06a9\u0647 \u0634\u0631\u06a9\u062a Adobe \u0622\u0646 \u0631\u0627 \u062a\u0648\u0644\u06cc\u062f \u06a9\u0631\u062f\u0647 \u0645\u06cc\u200c\u0628\u0627\u0634\u06cc\u062f\u060c \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0645\u0627\u0645\u06cc \u062a\u0631\u0641\u0646\u062f\u0647\u0627 \u0648 \u0646\u06a9\u0627\u062a \u0645\u0647\u0645 \u0631\u0627 \u062f\u0631 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f. \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062f\u0631 \u06a9\u0627\u0631 \u06a9\u0631\u062f\u0646 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u060c \u0628\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0628\u0631\u062e\u0648\u0631\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u06cc\u06a9 \u0644\u06cc\u0633\u062a\u060c \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0648 \u06cc\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f.<strong> \u0646\u0648\u0634\u062a\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/strong> \u06af\u0627\u0647\u06cc \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0645\u0634\u06a9\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0627\u0644\u0628\u062a\u0647 \u062f\u0631 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0631\u062f \u0646\u06cc\u0632\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0645\u0641\u06cc\u062f \u0647\u0633\u062a\u0646\u062f \u0648 \u0635\u0631\u0641\u0627\u064b \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0647 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u0645.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0631\u0627\u06cc <strong>\u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/strong> \u062f\u0648 \u0631\u0627\u0647 \u0631\u0627 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645. \u06cc\u06a9\u06cc \u0631\u0648\u0634 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc \u0628\u0631\u0627\u06cc<strong> \u062d\u0630\u0641 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/strong> \u0648 \u062f\u06cc\u06af\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u067e\u06cc\u0634 \u0641\u0631\u0636. \u0627\u06af\u0631 \u0627\u0632 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0648 \u0628\u0631\u062c\u0633\u062a\u0647 \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u062a\u0635\u0645\u06cc\u0645 \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u062e\u06cc\u0631 \u0645\u0627 \u0627\u0645\u0631\u0648\u0632 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0627\u0632&nbsp; \u0645\u06a9\u062a\u0628 \u062e\u0648\u0646\u0647 \u0628\u0647 \u0634\u0645\u0627 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u06cc\u0627\u062f \u062f\u0647\u06cc\u0645\u060c \u067e\u0633 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0647\u0645\u0631\u0627\u0647 \u0645\u0627 \u0628\u0627\u0634\u06cc\u062f.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0686\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u0645\u061f<\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0631\u0627\u06cc <strong>\u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/strong> \u0628\u0627\u06cc\u062f \u0628\u0647 \u062a\u0631\u062a\u06cc\u0628 \u0632\u06cc\u0631 \u0639\u0645\u0644 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"font-size: 14px;\">\u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0631\u0627\u06cc \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f\u060c \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/span><\/li>\n<\/ul>\n\n\n\n<p><span style=\"font-size: 14px;\"><strong>\u0646\u06a9\u062a\u0647<\/strong><strong>: <\/strong>\u0627\u06a9\u0633\u0644 \u0646\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0642\u0633\u0645\u062a Values \u06af\u0632\u0627\u0631\u0634 PivotTable \u0628\u0631\u062c\u0633\u062a\u0647 \u06a9\u0646\u062f.<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"font-size: 14px;\">\u0633\u067e\u0633 \u0628\u0627\u06cc\u062f \u0645\u0633\u06cc\u0631 \u0631\u0648\u0628\u0631\u0648 \u0631\u0627 \u0637\u06cc \u06a9\u0646\u06cc\u062f.&nbsp;\u0645\u0646\u0648\u06cc <strong>home<\/strong>&nbsp;&gt;&nbsp;\u06af\u0632\u06cc\u0646\u0647 <strong>Conditional Formatting<\/strong>&nbsp;&gt;&nbsp;\u06af\u0632\u06cc\u0646\u0647 <strong>Highlight Cells Rules<\/strong>&nbsp;&gt;&nbsp; \u0648 \u062f\u0631 \u0622\u062e\u0631 \u0627\u0646\u062a\u062e\u0627\u0628 \u06af\u0632\u06cc\u0646\u0647 <strong>Duplicate Values<\/strong>&nbsp;.<\/span><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"156\" height=\"302\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u0645\u061f\" class=\"wp-image-26897 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f.jpg 156w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f-155x300.jpg.webp 155w\" data-sizes=\"(max-width: 156px) 100vw, 156px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 156px; --smush-placeholder-aspect-ratio: 156\/302;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"font-size: 14px;\">\u062f\u0631 \u06a9\u0627\u062f\u0631\u06cc \u06a9\u0647 \u0628\u0627\u0632 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0628\u0627\u06cc\u062f\u060c \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u0631\u0627 \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0631\u0648\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f\u060c \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0648\u062f\u0647 \u0648 \u0633\u067e\u0633 \u0631\u0648\u06cc <strong>OK<\/strong>&nbsp;\u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"356\" height=\"123\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f-1.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u0645\u061f\" class=\"wp-image-26898 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f-1.jpg 356w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f-1-300x104.jpg 300w\" data-sizes=\"(max-width: 356px) 100vw, 356px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 356px; --smush-placeholder-aspect-ratio: 356\/123;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0686\u06af\u0648\u0646\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0627\u06a9\u0633\u0644 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\u061f<\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0632&nbsp;\u0648\u06cc\u0698\u06af\u06cc&nbsp;<strong>\u062d\u0630\u0641 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc<\/strong>&nbsp;\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u0642\u0628\u0644 \u0627\u0632 \u0647\u0631 \u0686\u06cc\u0632 \u0628\u062f\u0627\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0628\u0631\u0627\u06cc \u0647\u0645\u06cc\u0634\u0647 \u062d\u0630\u0641 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646&nbsp;\u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f\u060c \u0627\u06cc\u062f\u0647 \u062e\u0648\u0628\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0627\u0635\u0644\u06cc \u0631\u0627&nbsp;\u062f\u0631 \u06a9\u0627\u0631\u0628\u0631\u06af \u062f\u06cc\u06af\u0631\u06cc&nbsp;\u06a9\u067e\u06cc \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u0647&nbsp;\u0637\u0648\u0631 \u062a\u0635\u0627\u062f\u0641\u06cc \u0647\u06cc\u0686 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0631\u0627 \u0627\u0632 \u062f\u0633\u062a \u0646\u062f\u0647\u06cc\u062f. \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0627\u06cc\u062f \u0628\u0647 \u062a\u0631\u062a\u06cc\u0628 \u0632\u06cc\u0631 \u0639\u0645\u0644 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"font-size: 14px;\">\u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0627\u0631\u0627\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0647\u0633\u062a\u0646\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<\/ul>\n\n\n\n<p><span style=\"font-size: 14px;\"><strong>\u0646\u06a9\u062a\u0647<\/strong><strong>: <\/strong>\u0642\u0628\u0644 \u0627\u0632 \u0627\u0642\u062f\u0627\u0645 \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc\u060c \u0647\u0631 \u0637\u0631\u062d \u06a9\u0644\u06cc \u06cc\u0627 \u062c\u0645\u0639 \u0641\u0631\u0639\u06cc\u060c&nbsp;\u0631\u0627 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"font-size: 14px;\">\u0633\u067e\u0633 \u0645\u0633\u06cc\u0631 \u0631\u0648\u0628\u0631\u0648 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f. \u06a9\u0644\u06cc\u06a9 \u0631\u0648\u06cc \u0645\u0646\u0648\u06cc &gt; Data \u0627\u0646\u062a\u062e\u0627\u0628 \u06af\u0632\u06cc\u0646\u0647&nbsp;&nbsp;&nbsp;Remove Duplicates&nbsp;. \u0633\u067e\u0633 \u062f\u0631 \u0632\u06cc\u0631&nbsp;\u0633\u062a\u0648\u0646\u200c\u0647\u0627\u060c \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc\u200c\u0634\u0627\u0646 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f\u060c \u0639\u0644\u0627\u0645\u062a \u0628\u0632\u0646\u06cc\u062f \u06cc\u0627 \u0639\u0644\u0627\u0645\u062a \u0622\u0646 \u0631\u0627 \u0628\u0631\u062f\u0627\u0631\u06cc\u062f.<\/span><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"356\" height=\"123\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f-2.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u0645\u061f\" class=\"wp-image-26899 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f-2.jpg 356w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0631\u0627-\u062f\u0631-\u0627\u06a9\u0633\u0644-\u067e\u06cc\u062f\u0627-\u06a9\u0646\u06cc\u0645\u061f-2-300x104.jpg 300w\" data-sizes=\"(max-width: 356px) 100vw, 356px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 356px; --smush-placeholder-aspect-ratio: 356\/123;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u062f\u0631 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631\u06af\u060c \u0633\u062a\u0648\u0646 \u0698\u0627\u0646\u0648\u06cc\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0631\u0632\u0634\u0645\u0646\u062f\u06cc \u0631\u0627 \u062f\u0627\u0631\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0646\u06af\u0647 \u062f\u0627\u0631\u06cc\u0645.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"340\" height=\"280\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u0645\u0642\u0627\u062f\u06cc\u0631-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0627\u06a9\u0633\u0644-\u0631\u0627-\u062d\u0630\u0641-\u06a9\u0646\u06cc\u0645\u061f.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0627\u06a9\u0633\u0644 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\u061f\" class=\"wp-image-26900 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u0645\u0642\u0627\u062f\u06cc\u0631-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0627\u06a9\u0633\u0644-\u0631\u0627-\u062d\u0630\u0641-\u06a9\u0646\u06cc\u0645\u061f.jpg 340w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u0645\u0642\u0627\u062f\u06cc\u0631-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0627\u06a9\u0633\u0644-\u0631\u0627-\u062d\u0630\u0641-\u06a9\u0646\u06cc\u0645\u061f-300x247.jpg.webp 300w\" data-sizes=\"(max-width: 340px) 100vw, 340px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 340px; --smush-placeholder-aspect-ratio: 340\/280;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0628\u0627\u06cc\u062f \u062a\u06cc\u06a9&nbsp;\u0645\u0627\u0647 \u0698\u0627\u0646\u0648\u06cc\u0647 \u0631\u0627&nbsp;\u062f\u0631&nbsp;\u06a9\u0627\u062f\u0631&nbsp;<strong>Remove Duplicates<\/strong> \u0628\u0631\u062f\u0627\u0631\u06cc\u0645.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"393\" height=\"247\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u0645\u0642\u0627\u062f\u06cc\u0631-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0627\u06a9\u0633\u0644-\u0631\u0627-\u062d\u0630\u0641-\u06a9\u0646\u06cc\u0645\u061f-1.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0627\u06a9\u0633\u0644 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\u061f\" class=\"wp-image-26901 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u0645\u0642\u0627\u062f\u06cc\u0631-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0627\u06a9\u0633\u0644-\u0631\u0627-\u062d\u0630\u0641-\u06a9\u0646\u06cc\u0645\u061f-1.jpg 393w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0686\u06af\u0648\u0646\u0647-\u0645\u0642\u0627\u062f\u06cc\u0631-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u0627\u06a9\u0633\u0644-\u0631\u0627-\u062d\u0630\u0641-\u06a9\u0646\u06cc\u0645\u061f-1-300x189.jpg 300w\" data-sizes=\"(max-width: 393px) 100vw, 393px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 393px; --smush-placeholder-aspect-ratio: 393\/247;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"font-size: 14px;\">\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0647\u0645 \u0628\u0627\u06cc\u062f \u0631\u0648\u06cc&nbsp;<strong>OK<\/strong>&nbsp; \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f&nbsp;\u062a\u0627 \u06a9\u0627\u062f\u0631 \u0645\u0631\u0628\u0648\u0637\u0647 \u0628\u0633\u062a\u0647 \u0634\u0648\u062f \u0648 \u06a9\u0627\u0631 \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0628\u0631\u0633\u062f.<\/span><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u062d\u0630\u0641 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0627 \u0631\u0648\u0634 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc<\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0627 \u0631\u0648\u0634 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc \u0646\u06cc\u0632 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u062d\u0630\u0641 \u06a9\u0631\u062f. \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0644\u062f \u0628\u0627\u0634\u06cc\u062f. \u0645\u0632\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0646\u0633\u0628\u062a \u0628\u0647 \u0631\u0648\u0634 \u0642\u0628\u0644\u06cc \u062f\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0634\u0631\u0637\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0631\u0627 \u0628\u0627 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n<div class=\"jet-listing-grid--50121\" style=\"\"><div class=\"jet-listing-dynamic-field-block zht-maktab-khooneh-course cb-fb2qc30r\"data-is-block=\"jet-engine\/dynamic-field\"><div class=\"jet-listing-dynamic-field__content\" >\n<div class=\"course-card\">\n    <div class=\"course-card-img\">\n        <img decoding=\"async\" \n            data-src=\"https:\/\/media1.maktabkhooneh.org\/CACHE\/images\/courses\/images\/excel_J64Ia3k_1403-08-16-164603525\/59d596201990a1731aba7535ad501054.webp?expire=4893471932&#038;token=0a560b600497dbd229a8f62b5b1f709d&#038;md5=ClYLYASX29IpqPYrWx9wnQ==\" \n            alt=\"\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc\" \n            title=\"\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc\" \n            width=\"100%\" \n            height=\"auto\"\n           \n         src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\">\n    <\/div>\n\n    <div class=\"course-details\">\n        <a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%AF%DB%8C-%D9%86%D8%B1%D9%85%D8%A7%D9%81%D8%B2%D8%A7%D8%B1-%D9%85%D8%A7%DB%8C%DA%A9%D8%B1%D9%88%D8%B3%D8%A7%D9%81%D8%AA-%D8%A7%DA%A9%D8%B3%D9%84-mk760\/\" class=\"course-title\" target=\"_blank\" rel=\"noopener noreferrer\">\n            \u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc        <\/a>\n\n        <div class=\"course-price\">\n            \n                <span class=\"real-price\">\n                                            \u06f6\u06f9\u06f9,\u06f0\u06f0\u06f0                                    <\/span>\n\n                <span>\n                    <span class=\"discounted-price\">\n                        \u06f3\u06f9\u06f0,\u06f0\u06f0\u06f0                    <\/span>\n                    <span class=\"price-currency\">\u062a\u0648\u0645\u0627\u0646<\/span>\n                <\/span>\n\n                                    <div class=\"discount-percentage\">\n                        \u06f4\u06f4%                    <\/div>\n                \n                    <\/div>\n        <button class=\"course-cta-button\" data-course-url=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%AF%DB%8C-%D9%86%D8%B1%D9%85%D8%A7%D9%81%D8%B2%D8%A7%D8%B1-%D9%85%D8%A7%DB%8C%DA%A9%D8%B1%D9%88%D8%B3%D8%A7%D9%81%D8%AA-%D8%A7%DA%A9%D8%B3%D9%84-mk760\/\">\n            \u0645\u0634\u0627\u0647\u062f\u0647 \u0648 \u062e\u0631\u06cc\u062f        <\/button>\n    <\/div>\n<\/div>\n<\/div><\/div><\/div>\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0645\u06cc\u200c\u0628\u0627\u06cc\u0633\u062a \u067e\u0633 \u0627\u0632 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u062d\u062f\u0648\u062f\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0627\u0631\u0646\u062f\u060c \u0628\u0627\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u062f\u0631 \u0645\u0633\u06cc\u0631 \u0632\u06cc\u0631 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">Home &gt; Conditional Formatting &gt; New Rule &gt; Use a formula to determine which cells to format<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062f\u0631 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0628\u0647 \u0627\u06a9\u0633\u0644 \u0645\u06cc \u06af\u0648\u06cc\u06cc\u0645 \u06a9\u0647 \u0627\u06af\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0645\u0634\u062e\u0635 \u0634\u062f\u0647\u060c \u0628\u06cc\u0634 \u0627\u0632 \u06cc\u06a9\u0628\u0627\u0631 \u062a\u06a9\u0631\u0627\u0631 \u0634\u062f\u0647\u200c\u0627\u0646\u062f\u060c \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0645\u0634\u062e\u0635 \u06a9\u0646.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">=COUNTIF($A$1:$A$20,A1)&gt;1<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0634\u0631\u0637 \u0628\u06af\u0630\u0627\u0631\u06cc\u062f \u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u0627 \u0645\u06cc\u0632\u0627\u0646 \u062a\u06a9\u0631\u0627\u0631 \u06f4 \u0628\u0627\u0631 \u0648 \u0628\u06cc\u0634\u062a\u0631 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u062f\u060c \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0627\u06cc\u062f \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">=COUNTIF($A$1:$A$20,A1)&gt;=4<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0627\u0632 \u0648\u0631\u0648\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0686\u06af\u0648\u0646\u0647 \u0627\u0633\u062a\u061f<\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06af\u0631 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0631\u0627\u0647\u06cc \u0628\u0631\u0627\u06cc \u0645\u0627\u0646\u0639 \u0634\u062f\u0646 \u062f\u0631 \u0648\u0631\u0648\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0647\u0645\u0686\u0648\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u062a\u0646\u06cc \u0648 \u0639\u062f\u062f\u06cc \u0647\u0633\u062a\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0627\u0628\u0632\u0627\u0631 Data Validation \u062f\u0631 \u0645\u0633\u06cc\u0631 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">Data &gt; Data Validation &gt; Custom<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0646\u0648\u0634\u062a\u0646 \u06cc\u06a9 \u0627\u062e\u0637\u0627\u0631 \u06cc\u0627 \u0645\u062a\u0646 \u0628\u0647 \u062c\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0686\u06af\u0648\u0646\u0647 \u0627\u0633\u062a\u061f<\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u06af\u0627\u0647\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f \u0628\u0631\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646\u060c \u0645\u062a\u0646 \u062e\u0627\u0635\u06cc \u0646\u0648\u0634\u062a\u0647 \u0634\u0648\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0634\u0631\u0627\u06cc\u0637 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u062a\u0627\u0628\u0639 IF \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">=IF(COUNTIF($A$2:$A$13,A2)&gt;1,&#8221;\u062a\u06a9\u0631\u0627\u0631\u06cc &#8220;,&#8221;\u063a\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc&#8221;)<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0646\u062d\u0648\u0647 \u0634\u0645\u0627\u0631\u0634 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06af\u0631 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062a\u0639\u062f\u0627\u062f \u062f\u0642\u06cc\u0642 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u06cc\u06a9\u0633\u0627\u0646 \u062f\u0631 \u0628\u0631\u06af\u0647 \u0627\u06a9\u0633\u0644 \u062e\u0648\u062f \u0631\u0627 \u0628\u062f\u0627\u0646\u06cc\u062f\u060c \u0627\u0632 \u06cc\u06a9\u06cc \u0627\u0632 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0647\u0631 \u0631\u06a9\u0648\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0628\u0634\u0645\u0627\u0631\u06cc\u062f. \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0633\u062a\u0648\u0646\u06cc \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0627\u0631\u06cc\u062f\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0644\u0627\u0632\u0645 \u0628\u0627\u0634\u062f \u0628\u062f\u0627\u0646\u06cc\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0647\u0631 \u06cc\u06a9 \u0627\u0632 \u0645\u0642\u0627\u062f\u06cc\u0631\u060c \u0686\u0647 \u0645\u06cc\u0632\u0627\u0646 \u062a\u06a9\u0631\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0628\u0631\u0627\u06cc \u0641\u0647\u0645\u06cc\u062f\u0646 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u06cc\u06a9 \u0641\u0631\u0645\u0648\u0644 COUNTIF \u0633\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\u060c \u06a9\u0647 \u062f\u0631 \u0622\u0646 A2 \u0627\u0648\u0644\u06cc\u0646 \u0645\u0648\u0631\u062f \u0648 A8 \u0622\u062e\u0631\u06cc\u0646 \u0645\u0648\u0631\u062f \u0644\u06cc\u0633\u062a \u0627\u0633\u062a:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\"><strong>=COUNTIF($A$2:$A$8, $A2)<\/strong><\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f\u060c \u0641\u0631\u0645\u0648\u0644 \u062a\u0639\u062f\u0627\u062f \u062f\u0641\u0639\u0627\u062a \u0647\u0631 \u0645\u0648\u0631\u062f \u0634\u0645\u0631\u062f\u0647 \u0634\u062f\u0647 \u0648 \u0645\u0634\u062e\u0635 \u0627\u0633\u062a \u06a9\u0647&#8221;&nbsp;\u0633\u06cc\u0628&#8221;&nbsp; \u06f3 \u0628\u0627\u0631\u060c&#8221;&nbsp;\u0645\u0648\u0632 \u0633\u0628\u0632&#8221; \u06f2 \u0628\u0627\u0631 \u0648&#8221;&nbsp;\u0645\u0648\u0632&#8221; \u0648&#8221;&nbsp;\u067e\u0631\u062a\u0642\u0627\u0644&#8221; \u0641\u0642\u0637 \u06cc\u06a9 \u0628\u0627\u0631&nbsp;\u062a\u06a9\u0631\u0627\u0631 \u0634\u062f\u0647\u200c\u0627\u0646\u062f.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"256\" height=\"223\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0646\u062d\u0648\u0647-\u0634\u0645\u0627\u0631\u0634-\u0645\u0648\u0627\u0631\u062f-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644.jpg\" alt=\"\u0646\u062d\u0648\u0647 \u0634\u0645\u0627\u0631\u0634 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644\" class=\"wp-image-26902 lazyload\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256\/223;\"><figcaption><\/figcaption><\/figure>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0641\u0631\u0645\u0648\u0644 \u0634\u0645\u0627\u0631\u0634 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\"><strong>=COUNTIF(B2:B8, &#8220;duplicate&#8221;)<\/strong><\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"507\" height=\"225\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0646\u062d\u0648\u0647-\u0634\u0645\u0627\u0631\u0634-\u0645\u0648\u0627\u0631\u062f-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-1.jpg\" alt=\"\u0646\u062d\u0648\u0647 \u0634\u0645\u0627\u0631\u0634 \u0645\u0648\u0627\u0631\u062f \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644\" class=\"wp-image-26903 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2021\/11\/\u0646\u062d\u0648\u0647-\u0634\u0645\u0627\u0631\u0634-\u0645\u0648\u0627\u0631\u062f-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-1.jpg 507w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2021\/11\/\u0646\u062d\u0648\u0647-\u0634\u0645\u0627\u0631\u0634-\u0645\u0648\u0627\u0631\u062f-\u062a\u06a9\u0631\u0627\u0631\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-1-300x133.jpg.webp 300w\" data-sizes=\"(max-width: 507px) 100vw, 507px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 507px; --smush-placeholder-aspect-ratio: 507\/225;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span style=\"font-size: 14px;\"><strong>\u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0627 \u0645\u06a9\u062a\u0628 \u062e\u0648\u0646\u0647 \u062a\u062c\u0631\u0628\u0647 \u06a9\u0646\u06cc\u062f<\/strong><\/span><\/h2>\n\n\n\n<p><strong data-start=\"822\" data-end=\"862\">\u062a\u0633\u0644\u0637 \u0628\u0631 \u0627\u06a9\u0633\u0644 = \u0627\u0641\u0632\u0627\u06cc\u0634 \u0641\u0631\u0635\u062a\u200c\u0647\u0627\u06cc \u0634\u063a\u0644\u06cc!<\/strong> \u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc \u0627\u0645\u0631\u0648\u0632\u060c <strong data-start=\"879\" data-end=\"953\">\u06a9\u0627\u0631\u0641\u0631\u0645\u0627\u06cc\u0627\u0646 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0627\u0641\u0631\u0627\u062f\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0645\u0647\u0627\u0631\u062a \u062a\u062d\u0644\u06cc\u0644 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0627\u062f\u0647 \u0631\u0627 \u062f\u0627\u0631\u0646\u062f<\/strong>. \u0634\u0645\u0627 \u0647\u0645 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0627 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0627\u06a9\u0633\u0644\u060c \u06cc\u06a9 \u06af\u0627\u0645 \u0628\u0632\u0631\u06af \u0628\u0647 \u0633\u0648\u06cc \u0645\u0648\u0641\u0642\u06cc\u062a \u0634\u063a\u0644\u06cc \u0628\u0631\u062f\u0627\u0631\u06cc\u062f. <strong data-start=\"1029\" data-end=\"1062\">\u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc <a href=\"https:\/\/maktabkhooneh.org\/learn\/excel\/\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644<\/a> \u0648 \u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u0645\u0642\u062f\u0645\u0627\u062a\u06cc \u0645\u06a9\u062a\u0628\u200c\u062e\u0648\u0646\u0647<\/strong> \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u062a\u0627 \u0627\u0632 \u0633\u0637\u062d \u067e\u0627\u06cc\u0647 \u062a\u0627 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647\u060c \u0627\u06cc\u0646 \u0645\u0647\u0627\u0631\u062a \u0627\u0631\u0632\u0634\u0645\u0646\u062f \u0631\u0627 \u0628\u06cc\u0627\u0645\u0648\u0632\u06cc\u062f. <strong data-start=\"1140\" data-end=\"1175\">\u0647\u0645\u06cc\u0646 \u062d\u0627\u0644\u0627 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0631\u0627 \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc\u062f.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u06af\u0631 \u0639\u0644\u0627\u0642\u0647 \u0645\u0646\u062f \u0628\u0647 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0645\u062d\u0628\u0648\u0628 \u0627\u06a9\u0633\u0644 \u06a9\u0647 \u0634\u0631\u06a9\u062a Adobe \u0622\u0646 \u0631\u0627 \u062a\u0648\u0644\u06cc\u062f \u06a9\u0631\u062f\u0647 \u0645\u06cc\u200c\u0628\u0627\u0634\u06cc\u062f\u060c \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0645\u0627\u0645\u06cc \u062a\u0631\u0641\u0646\u062f\u0647\u0627 \u0648 \u0646\u06a9\u0627\u062a \u0645\u0647\u0645 \u0631\u0627 \u062f\u0631 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f. \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062f\u0631 \u06a9\u0627\u0631 \u06a9\u0631\u062f\u0646 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u060c \u0628\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0628\u0631\u062e\u0648\u0631\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u06cc\u06a9 \u0644\u06cc\u0633\u062a\u060c \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0648 \u06cc\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f. [&hellip;]<\/p>\n","protected":false},"author":81,"featured_media":26904,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[],"class_list":["post-26895","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-learn-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/26895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/comments?post=26895"}],"version-history":[{"count":4,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/26895\/revisions"}],"predecessor-version":[{"id":66387,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/26895\/revisions\/66387"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media\/26904"}],"wp:attachment":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media?parent=26895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/categories?post=26895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/tags?post=26895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}