How do I search for duplicate words in a column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to check for duplicate names in a column. Is there a way to do this?
 
Copy that column into a new worksheet...I don't want you to mess up your
exisiting sheet.

Then, simply create a Pivot with the data of that single column. You will
have to fist take it on rows and thewn again drag into data box as Count.

That's it.

Thanks,

Manish Bajpai
 
Without using pivot tables:

Assume your values are in the range A1:A10, paste this code in A1 and drag
down:

=IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
 
David,

You are simply great !!

Nice to brainstorm with you.

Thanks,

Manish
 
You must log in or register to reply here.

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

Augmenting an integer in a column to reflect duplicates in another 23
How to filter Unique values from Duplicates 6
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
remove duplicate rows but keeping all columns 3
using duplicate function 13
Excel Comparing two columns 1
comparing columns in two spreadsheets 1
Duplicate Values in Excel 2007 6

Back
Top