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?
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 -> Format -> Conditional Format -> [Change drop down to] Formula is
=COUNTIF($B:$B,$B1)>1
That should work...
JustMe.
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 "Blank". Then in Column B you can enter the following formula. =IF(A2=A1,"Duplicate","Non Duplicate") 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.
Thanks! Worked like a charm!!
I appreciate your help!
Melissa
"JustMe602" wrote:
>
> You will need to input the following formula in as a conditional
> format.
>
> Menu -> Format -> Conditional Format -> [Change drop down to] Formula
> is
>
> =COUNTIF($B:$B,$B1)>1
>
> That should work...
>
> JustMe.
>
>
> --
> JustMe602
> ------------------------------------------------------------------------
> JustMe602's Profile: http://www.excelforum.com/member.php...o&userid=27854
> View this thread: http://www.excelforum.com/showthread...hreadid=498031
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks