Excel search for douplications
 

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??

Excel search for douplications
 

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 FomatConditional 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




Niagera College Student wrote:
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??

Excel search for douplications
 

hi!

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

-via135


Niagera College Student Wrote:
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??


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=566750