{"id":1234,"date":"2025-07-23T14:39:45","date_gmt":"2025-07-23T09:09:45","guid":{"rendered":"https:\/\/www.infotech.edu.sg\/blog\/?p=1234"},"modified":"2026-05-26T17:20:36","modified_gmt":"2026-05-26T11:50:36","slug":"find-and-remove-duplicates-in-excel","status":"publish","type":"post","link":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/","title":{"rendered":"How To Remove Duplicates in Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Have you ever looked through a big Excel sheet and thought&nbsp;you&#8217;ve&nbsp;seen the same name, email address, or number pop up more than once?&nbsp;You&#8217;re&nbsp;right. Duplicate data is one of the most common\u2014and often ignored\u2014problems in Excel spreadsheets.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In 2026,&nbsp;professionals&nbsp;use spreadsheets for many things. These include keeping student records, tracking attendance, managing payroll,&nbsp;maintaining&nbsp;CRM lists, and handling inventory. But watch out! Duplicate entries can cause big problems without you noticing. They can make totals too high, mess up your analysis, and lead to expensive mistakes in reports. These days, knowing how to find and get rid of duplicates in Excel&nbsp;isn&#8217;t&nbsp;just a bonus skill.&nbsp;It&#8217;s&nbsp;a must-have for working in the digital world.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>How do you find and remove duplicates in Excel?<\/strong>&nbsp;<\/p>\n\n\n\n<p class=\"has-background wp-block-paragraph\" style=\"background-color:#abeafd\"><strong>Excel offers several ways to spot and&nbsp;delete&nbsp;duplicates. You can use Conditional Formatting to highlight repeated values or turn to the Remove Duplicates tool under the Data tab to get rid of them for good. If you want to check or&nbsp;pull out&nbsp;unique records without erasing original data, Excel lets you use formulas like COUNTIF and Advanced Filters.&nbsp;<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Why Do Duplicates Show Up in Excel Files?&nbsp;<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Professionals&nbsp;add duplicates on purpose. They sneak in during everyday work. Some common reasons include copying data from&nbsp;different sources, making typing mistakes, and getting exports from systems.&nbsp;You&#8217;ll&nbsp;often see repeated entries in things like attendance reports, sales data, and contact lists without even realizing it.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The issue is that repeated values might seem fine at first. However, as time passes, they can mess up analysis, give decision-makers the wrong idea, and make work go slower.&nbsp;That&#8217;s&nbsp;why&nbsp;it&#8217;s&nbsp;crucial to learn how to spot and fix duplicates on when using Excel.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How Excel Helps You Handle Repeated Data?\u00a0<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Excel gives you several built-in ways to deal with duplicates. You can choose to&nbsp;<strong>point them out<\/strong>,&nbsp;<strong>get rid of them<\/strong>, or&nbsp;<strong>look them over<\/strong>&nbsp;before you do anything. Knowing which method to use when makes you quicker and more precise at your job.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What are Some Easy Ways to Remove Duplicates in Excel?\u00a0<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>Method<\/strong>\u00a0<\/th><th><strong>Best Used When<\/strong>\u00a0<\/th><th><strong>What It Does<\/strong>\u00a0<\/th><\/tr><\/thead><tbody><tr><td><\/td><td><\/td><td><\/td><\/tr><tr><td>Conditional Formatting&nbsp;<\/td><td>You want to review duplicates visually&nbsp;<\/td><td>Highlights&nbsp;duplicates&nbsp;without&nbsp;deleting&nbsp;data&nbsp;<\/td><\/tr><tr><td>Remove Duplicates Tool&nbsp;<\/td><td>You want clean, unique data&nbsp;<\/td><td>Permanently removes duplicate rows&nbsp;<\/td><\/tr><tr><td>Excel formulas&nbsp;<\/td><td>You need more control&nbsp;<\/td><td>Flags duplicates based on logic&nbsp;<\/td><\/tr><tr><td>Advanced Filter&nbsp;<\/td><td>You want a clean copy&nbsp;<\/td><td>Displays unique records without changing original data&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Knowing how to use all these methods makes you much&nbsp;more sure&nbsp;of yourself when working with real datasets.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Spot Duplicates Using Conditional Formatting&nbsp;<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For those just starting out, Conditional Formatting is the safest way to find duplicates because it&nbsp;doesn&#8217;t&nbsp;erase anything. It just makes repeated values stand out so you can look them over with your own eyes.&nbsp;<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Pick the cells<\/strong>\u202fyou want to check (like A1:A100).&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Look at the\u202f<strong>Home<\/strong>\u202ftab on the Excel ribbon.&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Select\u202f<strong>Conditional Formatting &gt; Highlight Cells Rules &gt; Duplicate Values.<\/strong>&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Pick the&nbsp;color&nbsp;you want (Excel usually chooses Light Red by default).&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>Click\u202f<strong>OK<\/strong>.&nbsp;<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Tada! All duplicate values are now highlighted.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This approach works well when&nbsp;you&#8217;re&nbsp;still going through data or when getting things right is more important than doing&nbsp;them .&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Get Rid of Duplicates Using Excel&#8217;s Built-In Tool&nbsp;<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When&nbsp;you&#8217;re&nbsp;sure that certain duplicates need to go, Excel&#8217;s&nbsp;<strong>Remove Duplicates<\/strong>&nbsp;tool makes cleanup quick and dependable.&nbsp;<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Pick your data range (add column headers for clarity).&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Head to the\u202f<strong>Data<\/strong>\u202ftab.&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Hit\u202f<strong>Remove Duplicates.<\/strong>&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>In the pop-up, check the columns where duplicates might be.&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>Hit OK.&nbsp;<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Excel will then:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Remove the duplicates&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Let you know how many were found and deleted&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tell you the number of unique items left&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Professionals&nbsp;often use this method to clean up contact lists, attendance records, and transaction data\u2014but always back up important files before using it.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Use Excel Formulas to Flag Duplicates&nbsp;<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Sometimes, you&nbsp;don&#8217;t&nbsp;want to get rid of duplicates right away. Instead, you might want to mark them to look at later. This is where formulas like COUNTIF come in handy.&nbsp;nt a bit more control or aim to flag duplicates without getting rid of them, try formulas like:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. COUNTIF Formula<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"181\" height=\"22\" src=\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/image.png\" alt=\"\" class=\"wp-image-1235\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This gives you a TRUE result when A2\u2019s value shows up more than once in column A. You can then&nbsp;sort&nbsp;or filter based on these TRUE values.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. IF and COUNTIF Together<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"366\" height=\"22\" src=\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/image-1.png\" alt=\"\" class=\"wp-image-1236\" srcset=\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/image-1.png 366w, https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/image-1-300x18.png 300w, https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/image-1-360x22.png 360w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This puts a label next to each row making it easy to spot duplicates before&nbsp;taking action.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These formulas let you be flexible if you want to get rid of duplicates under certain conditions.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This method comes in handy for HR teams, finance departments, and admin staff who need to make sure their data is correct before they&nbsp;delete&nbsp;anything.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Display Unique Records Using Advanced Filter&nbsp;<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you want a clean list but&nbsp;don&#8217;t&nbsp;want to change your original data, Excel&#8217;s&nbsp;<strong>Advanced Filter<\/strong>&nbsp;is your best bet. This tool makes a copy of your data without any duplicates, while keeping your original dataset intact.&nbsp;<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Select your data.&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Head to the\u202f<strong>Data<\/strong>\u202ftab &gt;\u202f<strong>Advanced<\/strong>\u202f(under the Sort &amp; Filter group).&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Select\u202f<strong>Copy to another location<\/strong>.&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Check **<strong>Unique Records Only<\/strong>**.&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>Choose a destination cell for the results.&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>Hit\u202f<strong>OK<\/strong>.&nbsp;<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">This helps with reporting, analysis, or sharing clean data with stakeholders.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How This Skill Applies in Real Life?\u00a0<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Getting rid of duplicates&nbsp;isn&#8217;t&nbsp;just an Excel trick\u2014it&#8217;s&nbsp;something&nbsp;professionals&nbsp;do at work every day. Students use it to clean up survey data and assignment lists. HR teams use it on <strong><a href=\"https:\/\/www.info-tech.com.sg\/time-attendance-software\">time attendance<\/a><\/strong> and <strong><a href=\"https:\/\/www.info-tech.com.sg\/payroll-software\">payroll<\/a><\/strong> files. Admin staff use it to manage contact databases and applications. Finance teams use it to stop duplicate transactions and reporting mistakes.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In all these cases, knowing how to handle duplicates saves time, makes work more&nbsp;accurate, and keeps your professional reputation intact.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Stop Duplicates from Happening in the First Place?<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Getting rid of duplicates is&nbsp;good, but&nbsp;stopping them from happening is even better.&nbsp;&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use\u202f <strong>Data Validation<\/strong>\u202fto create dropdown lists and restrict inputs.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Turn on\u202f <strong>Excel Tables<\/strong>\u202fwhich let you use structured references and fill in data more intelligently.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create\u202f <strong>Unique Identifiers<\/strong>\u202f(IDs, email addresses) for each entry.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Professionals&nbsp;learn these ways to prevent duplicates in organized training sessions, not by teaching themselves.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Why This Skill Is Taught in WSQ Essential Office Skills Courses?\u00a0<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">At InfoTech Academy managing duplicates is part of the&nbsp;<strong><a href=\"https:\/\/www.infotech.edu.sg\/\">WSQ<\/a>: <a href=\"https:\/\/www.infotech.edu.sg\/courses\/essential-office-skills-course-singapore\">Essential Office Skills Course<\/a><\/strong>. Students work with Excel files that look like ones used in Singapore offices. Instead of made-up examples,&nbsp;professionals&nbsp;in the course practice with datasets that are like those used in HR, admin, and operations jobs.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Since the course has WSQ certification and&nbsp;SkillsFuture&nbsp;eligibility, students get hands-on experience and a credential that catches employers&#8217; eyes.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Final Thoughts: Clean Data Builds Trust&nbsp;<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Learning to spot and&nbsp;eliminate&nbsp;duplicates in Excel does more than clean up spreadsheets. It enhances precision, speeds up work, and&nbsp;instills&nbsp;trust when dealing with data. This basic Excel skill pays off right away, whether&nbsp;you&#8217;re&nbsp;getting ready for your first job or managing company data at work.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Clean data leads to clearer choices\u2014and your work speaks volumes.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Remove Duplicates in Excel FAQs<\/strong><\/h2>\n\n\n\n<div class=\"\">\n<div class=\"mi-faq\">\n<div id=\"accordionExample\" class=\"accordion\">\n<div class=\"card\">\n<div id=\"headingOne\" class=\"card-head\">\n<div class=\"acc-arrow\" data-toggle=\"collapse\" data-target=\"#collapseOne\" aria-expanded=\"true\" aria-controls=\"collapseOne\">\n<h4 class=\"Positionheader\">Is removing duplicates in Excel safe?<\/h4>\n<\/div>\n<\/div>\n<div id=\"collapseOne\" class=\"collapse show\" aria-labelledby=\"headingOne\" data-parent=\"#accordionExample\">\n<div class=\"card-body\">\n<p>Yes as long as you take a look at your data first and save a backup. Using Conditional Formatting or Advanced Filters gives you a chance to see duplicates before you delete anything.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"card\">\n<div id=\"headingtwo\" class=\"card-head\">\n<div class=\"collapsed acc-arrow\" data-toggle=\"collapse\" data-target=\"#collapsetwo\" aria-expanded=\"false\" aria-controls=\"collapsetwo\">\n<h4 class=\"Positionheader\">What is the easiest way for beginners to find duplicates?<\/h4>\n<\/div>\n<\/div>\n<div id=\"collapsetwo\" class=\"collapse\" aria-labelledby=\"headingtwo\" data-parent=\"#accordionExample\">\n<div class=\"card-body\">\n<p>Conditional Formatting is the simplest way to go. It shows duplicates right away without getting rid of data making it great for new users and students.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"card\">\n<div id=\"headingthree\" class=\"card-head\">\n<div class=\"collapsed acc-arrow\" data-toggle=\"collapse\" data-target=\"#collapsethree\" aria-expanded=\"false\" aria-controls=\"collapsethree\">\n<h4 class=\"Positionheader\">Can Excel get rid of duplicates across multiple columns?<\/h4>\n<\/div>\n<\/div>\n<div id=\"collapsethree\" class=\"collapse\" aria-labelledby=\"headingthree\" data-parent=\"#accordionExample\">\n<div class=\"card-body\">\n<p>Yes. When you use the Remove Duplicates tool, you can pick multiple columns. Excel will see rows as duplicates if all chosen column values match.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"card\">\n<div id=\"headingfour\" class=\"card-head\">\n<div class=\"collapsed acc-arrow\" data-toggle=\"collapse\" data-target=\"#collapsefour\" aria-expanded=\"false\" aria-controls=\"collapsefour\">\n<h4 class=\"Positionheader\">Should I erase duplicates or just mark them?<\/h4>\n<\/div>\n<\/div>\n<div id=\"collapsefour\" class=\"collapse\" aria-labelledby=\"headingfour\" data-parent=\"#accordionExample\">\n<div class=\"card-body\">\n<p>It hinges on the job. For reports and paychecks erasing duplicates might be needed. For checks or reviews, marking duplicates first is safer.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"Is removing duplicates in Excel safe?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Yes as long as you take a look at your data first and save a backup. Using Conditional Formatting or Advanced Filters gives you a chance to see duplicates before you delete anything.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What is the easiest way for beginners to find duplicates?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Conditional Formatting is the simplest way to go. It shows duplicates right away without getting rid of data making it great for new users and students.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Can Excel get rid of duplicates across multiple columns?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Yes. When you use the Remove Duplicates tool, you can pick multiple columns. Excel will see rows as duplicates if all chosen column values match.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Should I erase duplicates or just mark them?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"It hinges on the job. For reports and paychecks erasing duplicates might be needed. For checks or reviews, marking duplicates first is safer.\"\n    }\n  }]\n}\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever looked through a big Excel sheet and thought&nbsp;you&#8217;ve&nbsp;seen the same[&#8230;]<\/p>\n","protected":false},"author":17,"featured_media":1258,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[157],"tags":[181,180,111,182],"class_list":["post-1234","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-essential-office-skills-course","tag-duplicate-data","tag-excel","tag-microsoft-excel","tag-remove-duplicates-in-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Remove Duplicates in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to remove duplicates in Excel with step-by-step. Simple techniques using conditional formatting, formulas &amp; more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Remove Duplicates in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to remove duplicates in Excel with step-by-step. Simple techniques using conditional formatting, formulas &amp; more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Infotech Academy Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/infotechacademy.sg\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-23T09:09:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-26T11:50:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1704\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ajolin L Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ajolin L Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/\"},\"author\":{\"name\":\"Ajolin L Robert\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/person\/9cfa2665579d95f2b75e1874f0dd9029\"},\"headline\":\"How To Remove Duplicates in Excel\",\"datePublished\":\"2025-07-23T09:09:45+00:00\",\"dateModified\":\"2026-05-26T11:50:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/\"},\"wordCount\":1507,\"publisher\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg\",\"keywords\":[\"duplicate data\",\"excel\",\"microsoft excel\",\"Remove duplicates in Excel\"],\"articleSection\":[\"Essential Office Skills Course\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/\",\"url\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/\",\"name\":\"How to Remove Duplicates in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg\",\"datePublished\":\"2025-07-23T09:09:45+00:00\",\"dateModified\":\"2026-05-26T11:50:36+00:00\",\"description\":\"Learn how to remove duplicates in Excel with step-by-step. Simple techniques using conditional formatting, formulas & more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#primaryimage\",\"url\":\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg\",\"contentUrl\":\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg\",\"width\":2560,\"height\":1704,\"caption\":\"How to Find and Remove Duplicates in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.infotech.edu.sg\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Remove Duplicates in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#website\",\"url\":\"https:\/\/www.infotech.edu.sg\/blog\/\",\"name\":\"Infotech Academy Blog\",\"description\":\"IT, Tech &amp; Digital Skills Insights\",\"publisher\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.infotech.edu.sg\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#organization\",\"name\":\"InfoTech Academy\",\"url\":\"https:\/\/www.infotech.edu.sg\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2024\/06\/infotech_logo.png\",\"contentUrl\":\"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2024\/06\/infotech_logo.png\",\"width\":330,\"height\":116,\"caption\":\"InfoTech Academy\"},\"image\":{\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/infotechacademy.sg\/\",\"https:\/\/www.linkedin.com\/company\/infotech-academy-edu\",\"https:\/\/www.instagram.com\/infotechacademy.sg\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/person\/9cfa2665579d95f2b75e1874f0dd9029\",\"name\":\"Ajolin L Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/379e92b5a1e2fb0fd8842e021bdcf5237257ad79f95ccfd173abef446f5e9cda?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/379e92b5a1e2fb0fd8842e021bdcf5237257ad79f95ccfd173abef446f5e9cda?s=96&d=mm&r=g\",\"caption\":\"Ajolin L Robert\"},\"description\":\"I\u2019ve always been drawn to the power of writing! As a content writer, I love the challenge of finding the right words to capture the essence of HR, payroll, and accounting software.\u00a0I enjoy breaking down complex concepts, making technical information easy to understand, and helping businesses see the real impact of the right tools.\",\"url\":\"https:\/\/www.infotech.edu.sg\/blog\/author\/ajolin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Remove Duplicates in Excel","description":"Learn how to remove duplicates in Excel with step-by-step. Simple techniques using conditional formatting, formulas & more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Remove Duplicates in Excel","og_description":"Learn how to remove duplicates in Excel with step-by-step. Simple techniques using conditional formatting, formulas & more.","og_url":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/","og_site_name":"Infotech Academy Blog","article_publisher":"https:\/\/www.facebook.com\/infotechacademy.sg\/","article_published_time":"2025-07-23T09:09:45+00:00","article_modified_time":"2026-05-26T11:50:36+00:00","og_image":[{"width":2560,"height":1704,"url":"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg","type":"image\/jpeg"}],"author":"Ajolin L Robert","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ajolin L Robert","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/"},"author":{"name":"Ajolin L Robert","@id":"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/person\/9cfa2665579d95f2b75e1874f0dd9029"},"headline":"How To Remove Duplicates in Excel","datePublished":"2025-07-23T09:09:45+00:00","dateModified":"2026-05-26T11:50:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/"},"wordCount":1507,"publisher":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/#organization"},"image":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg","keywords":["duplicate data","excel","microsoft excel","Remove duplicates in Excel"],"articleSection":["Essential Office Skills Course"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/","url":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/","name":"How to Remove Duplicates in Excel","isPartOf":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg","datePublished":"2025-07-23T09:09:45+00:00","dateModified":"2026-05-26T11:50:36+00:00","description":"Learn how to remove duplicates in Excel with step-by-step. Simple techniques using conditional formatting, formulas & more.","breadcrumb":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#primaryimage","url":"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg","contentUrl":"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2025\/07\/How-to-Find-and-Remove-Duplicates-in-Excel-scaled.jpg","width":2560,"height":1704,"caption":"How to Find and Remove Duplicates in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.infotech.edu.sg\/blog\/find-and-remove-duplicates-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.infotech.edu.sg\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Remove Duplicates in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.infotech.edu.sg\/blog\/#website","url":"https:\/\/www.infotech.edu.sg\/blog\/","name":"Infotech Academy Blog","description":"IT, Tech &amp; Digital Skills Insights","publisher":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.infotech.edu.sg\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.infotech.edu.sg\/blog\/#organization","name":"InfoTech Academy","url":"https:\/\/www.infotech.edu.sg\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2024\/06\/infotech_logo.png","contentUrl":"https:\/\/www.infotech.edu.sg\/blog\/wp-content\/uploads\/2024\/06\/infotech_logo.png","width":330,"height":116,"caption":"InfoTech Academy"},"image":{"@id":"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/infotechacademy.sg\/","https:\/\/www.linkedin.com\/company\/infotech-academy-edu","https:\/\/www.instagram.com\/infotechacademy.sg\/"]},{"@type":"Person","@id":"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/person\/9cfa2665579d95f2b75e1874f0dd9029","name":"Ajolin L Robert","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.infotech.edu.sg\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/379e92b5a1e2fb0fd8842e021bdcf5237257ad79f95ccfd173abef446f5e9cda?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/379e92b5a1e2fb0fd8842e021bdcf5237257ad79f95ccfd173abef446f5e9cda?s=96&d=mm&r=g","caption":"Ajolin L Robert"},"description":"I\u2019ve always been drawn to the power of writing! As a content writer, I love the challenge of finding the right words to capture the essence of HR, payroll, and accounting software.\u00a0I enjoy breaking down complex concepts, making technical information easy to understand, and helping businesses see the real impact of the right tools.","url":"https:\/\/www.infotech.edu.sg\/blog\/author\/ajolin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/posts\/1234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/comments?post=1234"}],"version-history":[{"count":17,"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/posts\/1234\/revisions"}],"predecessor-version":[{"id":2826,"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/posts\/1234\/revisions\/2826"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/media\/1258"}],"wp:attachment":[{"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/media?parent=1234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/categories?post=1234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.infotech.edu.sg\/blog\/wp-json\/wp\/v2\/tags?post=1234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}