Live Course on Drafting of Appeal and Reply of Penalty Notice by CA Sachin Sinha. Register Now!!

How to check duplicacy in excel

SANJAY MAHESHWARI ACA ACS (Chartered Accountant) (123 Points)

02 January 2012

Please,

Let me know how to trace any duplicacy of Data/ values in a particular column having thousands of values. Such that repetition of same value in that particular column can be found out.

Reply
Follow
Share

4 Replies

Nirmal (Employee) (67 Points)
Replied 02 January 2012

Step1: Select the coulmn or row in which you want to Find Duplicacy Value.

Step2:Select Conditional Formatting from Home tab in office ribbon Button.

Step3:From the menu appeared through step2,Select New Rule option.

Step4:Select Rule Type as "Format only unique or Dulicate Value"

Step4:Keep Format All as "Duplicate" & Select Format option and give the font style or colour you want the Excel to give for all duplicate values.

Step5;Select Ok and you would see the format you desired for all duplicate values.

Note:If value "1" appears twice in your coulmn selected then format you desired would appear for all values,in you case all value "1" will be given the format you so desired.

Thank User if you liked my Reply

CA Abhinav (Chartered Accountant) (496 Points)
Replied 02 January 2012

Use countif formula...search google if u don't know how to apply this formula..count appearing more than 1 are duplicate filler them out and delete......but before doing anything take the backup your excel file if anything goes wrong backup file can be used.