How can you identify duplicate entries in a singe column?

G

Guest

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

JustMe602

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.
 
W

wjohnson

If the values are in Column A, Sort the column. Then enter a Title fo
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 wil
give you a visual representation of any duplicate values. You can ente
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 Shee
3
and then do the same formula as above in Column C - This will show yo
where the duplicates are
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identify duplicates in row with conditional formatting 7
duplicate dates 2
Excel cash book: formula to duplicate amt in relevant exp column 1
Data Validation, Identify Duplicates and Limit imput 7
Duplicate data entries 1
Duplicates-to id when occurs in 3 columns for unique dup in 4th co 1
Duplicate entries in more than one column 5
Duplicate Values in Excel 2007 6

Top