Find Duplicate Value in Excel


Prev Tutorial Next Tutorial

How to Find Duplicate Value in Excel

This article is helpful to easly find duplicate value in your excel sheet.

Steps to Find Duplicate Value in Excel Sheet

  • Select the Range
  • On the Home tab, in the Styles group, click Conditional Formatting.
  • Click Highlight Cells Rules, Duplicate Values.
  • Select a formatting style and click OK.
  • Result. Excel highlights the duplicate names.
find duplicate value setting in excel

Excel highlights duplicates, triplicates, quadruplicates (if we have any), etc. Execute the following steps to highlight triplicates only.

  • First, clear the previous conditional formatting rule.
  • Select the range A1:C10.
  • On the Home tab, in the Styles group, click Conditional Formatting.
  • Click New Rule.
  • Select 'Use a formula to determine which cells to format'.
  • Enter the formula =COUNTIF($A$1:$C$10,A1)=3
  • Select a formatting style and click OK.
  • Result. Excel highlights the triplicate names.

Remove Duplicate Values

  • Select Home Tab
  • See Conditional Formatting
  • Now One Dialog Box will Appear
  • Click on Clear Rules
  • Clear Rules for Selected Cells or Clear Rules for Entire Sheet
  • Work Done
remove duplicate value setting in excel
Prev Tutorial Next Tutorial

Google Advertisements

Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain, Tutorialday.com, SeosmoTools.com @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: hitesh.xc@gmail.com WhatsApp no. 8882538826

Yahoo Advertisements