I have two long columns of names in an Excel worksheet. One column has
12000 names, the other has about half that. There are some names that
occur in both lists. Is there an easy way to determine which names are
common to both lists?

---

Request for Question Clarification by rainbow-ga on 25 Sep 2005 10:34 PDT

Please take a look at this and let me know if it helps:

http://www.hightechtalks.com/archive/index.php/t-1976654-compare-cells-in-two-columns.html

Best regards,
Rainbow

---

Request for Question Clarification by rainbow-ga on 25 Sep 2005 10:41 PDT

Here's more:

http://www.excelbanter.com/q-t_31840-Seperating-duplicate-cells.html

Rainbow~

---

Request for Question Clarification by hummer-ga on 25 Sep 2005 19:27 PDT

Hi engineerbill,

Perhaps Duplicate Master is what you are looking for.

The Duplicate Master V1.3 (freeware)
A freeware Excel add-in by brettdj to manage Excel duplicates
(For Excel 2000 & higher versions)
Works with cells or entire rows!
Runs over ranges, multiple sheets or the entire Workbook!
http://members.iinet.net.au/~brettdj/

Please let me know if that works for you, I'll look forward to your reply.

Regards,
hummer

---

Clarification of Question by engineerbill-ga on 25 Sep 2005 21:04 PDT

Tried your first suggestion, Rainbow. Good try, but that solution
finds data in col A NOT in col B. What I'm looking for is data in col
A that IS ALSO in col B.
Appreciate your reply. Now going to suggestion #2!

---

Clarification of Question by engineerbill-ga on 25 Sep 2005 21:23 PDT

Suggestion #2 also searches for data in col b not in col a. I want to
make a list, say in col c, which contains data found in both col a and
col b.

Now trying Hummer's suggestion.
Thanks, Rainbow.
PS - This is my first time on Google Answers. Let me know how I'm doing.

---

Clarification of Question by engineerbill-ga on 25 Sep 2005 21:48 PDT

Hummer -

BINGO!
The Duplicate Master did the job, once I figured out the downloading,
extracting, etc.
FYI, I am registered in both civil and mechanical engineering in a
state, and wanted to find out who else was.
Duplicate Master was perfect. Thank you. 
Not to be too naieve, but how do I pay you?
The new guy,
engineerbill

Dear engineerbill,

Terrific news, thank you for letting me know and for giving me the
opportunity to post my answer, I appreciate it.  I'm glad to hear
Duplicate Master did the trick, it seems to be one of those little
programs that really does a good job.  Here it is again to make it
official.

The Duplicate Master V1.3 (freeware)
A freeware Excel add-in by brettdj to manage Excel duplicates
(For Excel 2000 & higher versions)
Works with cells or entire rows!
Runs over ranges, multiple sheets or the entire Workbook!
http://members.iinet.net.au/~brettdj/

Welcome to GA! You have used the GA service perfectly and I wish
everyone could do as well as you have.  One of the strengths of GA is
the clarification request option which gives the opportunity for
communication, but unfortunately many questioners don't use it.  To
answer your question regarding payment, your credit card will be
billed the moment I submit my answer, so all is well.

Sincerely,
hummer

This was my first question on GA, and Hummer answered it the day after
it was posted. Great!

Thank you, engineerbill, for your nice note, rating, and tip - that's
very nice of you. Welcome to GA!  Sincerely, hummer