How to find duplicate from excel spreadsheet

[Yaaram]

How to find duplicates from excel spreadsheet

Steps
1) Select the area you wish to be included in the search
2) On home tab click on Conditional Formatting > Highlight Cell rules > Duplicate Values (See the image below for help)

3) All the values will be highlighted and following popup will appear.. select the color you wish for the values to be highlighted with.


4) Done

[ahsaas]

Re: How to find duplicate from excel spreadsheet

acha ...tou ye aise kerty hein :D


thanx for share

[Yaaram]

Re: How to find duplicate from excel spreadsheet

haan ji aisay karty hain !

[.]

Re: How to find duplicate from excel spreadsheet

thanx for sharing :rose aap koon sa version use kar rehay ho?

[Yaaram]

Re: How to find duplicate from excel spreadsheet

thanx for sharing :rose aap koon sa version use kar rehay ho?

My office is on 2007 while I am using 2013.

[ahsaas]

Re: How to find duplicate from excel spreadsheet

duniya agey jati hai ... aur yahan :tasali:

[Aslam1981]

Re: How to find duplicate from excel spreadsheet

Good

Sent from my HTC Desire 820 using Tapatalk

[.]