software

How can you identify duplicate entries in a singe column? Can you identify
duplicate data in 2 columns where each column in on a different worksheet?


You will need to input the following formula in as a conditional
format.

Menu -gt; Format -gt; Conditional Format -gt; [Change drop down to] Formula
is

=COUNTIF($B:$B,$B1)gt;1

That should work...

JustMe.--
JustMe602
------------------------------------------------------------------------
JustMe602's Profile: www.excelforum.com/member.php...oamp;userid=27854
View this thread: www.excelforum.com/showthread...hreadid=498031
If the values are in Column A, Sort the column. Then enter a Title for
the the column A in Cell A1 or just insert a row and leave it quot;Blankquot;.
Then in Column B you can enter the following formula.
=IF(A2=A1,quot;Duplicatequot;,quot;Non Duplicatequot;) and then copy down - this will
give you a visual representation of any duplicate values. You can enter
any value you want for Duplicate and Non Duplicate.
Second part of your Question:
Sheet 1 in Column B add Sheet1 for each value
Sheet 2 in Column B add Sheet2 for each value
Copy Columns A and B from Sheet 1 and Sheet 2 - paste them into Sheet
3
and then do the same formula as above in Column C - This will show you
where the duplicates are.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=498031Thanks! Worked like a charm!!
I appreciate your help!
Melissa

quot;JustMe602quot; wrote:

gt;
gt; You will need to input the following formula in as a conditional
gt; format.
gt;
gt; Menu -gt; Format -gt; Conditional Format -gt; [Change drop down to] Formula
gt; is
gt;
gt; =COUNTIF($B:$B,$B1)gt;1
gt;
gt; That should work...
gt;
gt; JustMe.
gt;
gt;
gt; --
gt; JustMe602
gt; ------------------------------------------------------------------------
gt; JustMe602's Profile: www.excelforum.com/member.php...oamp;userid=27854
gt; View this thread: www.excelforum.com/showthread...hreadid=498031
gt;
gt;