Excel search for douplications

[Guest]

I am currently gathering a lot of data; I have been referencing several list
that may contain the same information. Is there a way to have Excel show me
if there are any duplications in a select row or column??

 

[shail]

Hi friend,

You can do so by using the conditional formatting

Hope you know how to use the conditinal formating.
Say you want the A:A column to seach for the duplicates
1. Select A1 then,
In Fomat>Conditional Formating select Formula Is and type the formula

=countif(A:A,A1)>1

2. Click Format button
3. Go to Patterns tab, select a colour (say Red)
4. Click Ok
5. Copy A1 and select the whole column
6. Right click your mouse button, select Paste Special, select formats

You will find the duplicate values in Red colour

You can repeat this for each of your columns


Hope this works fine with you

Shail

 

[via135]

hi!

gathering data is not a tough job!
but the data should be in an organised manner!!

-via135