How To Know Duplicate Values In Excel.

Know Duplicate or Repeated Values in Excel.

Normally we work on excel reports with huge data and it is difficult to pick the duplicate values without any formula or function. Excel provides us a good feature to find out duplicate or repeated values during work within the spreadsheet. To get an error-free report it is important to sort the duplicate values. During working with excel sheets we always need to identify duplicate or repeated values in data.

In Excel, We have two options to get duplicate values. Two different options are available to find duplicate values. Follow the options given below to make a good understanding.

Duplicate function is very important to use in excel, lots of use in MS Excel. If you are a MIS reporting professional, you must understand this method.

Method -1 :

Select the data
Go To Conditional Formatting.
Go To Highlighting Cell Rules.
Select Option Duplicate Values.
Dialogue Box will open
From drop-down Select Duplicate.
You can choose different cell color.
Click Ok.
You Are Done.

Method -2 :

Go To Home Menu.

Go To Conditional Formatting.

Select New Rule...

Dialogue Box will open "New Formatting Rules"

Select "Format only unique or Duplicate Values"

From drop-down Select Duplicate.

Click Format Button.

Go To Fill Tab

Select the color as you wish as a result.

Click Ok.

Again Ok.

You Are Done.

Select the only row where you would like to apply the rule. If you select the whole sheet, the rule will apply within the whole sheet and all duplicates values will appear. Which can make your work difficult. Sometimes we can find duplicate values from countif formula. For more Clarification of Count function Please Click Here . If you understood count function you can use it in different aspects and also get duplicate values.

Learn How To Find Out Duplicate Values In MS Excel With Live Examples.