Compare two lists of names

B

bam

Hello, I have a list of names in column A (a subset of the names on list B)
and a list of names in column B (the entire list of names). Is there some
way to compare the two lists and highlight, copy elsewhere, or somehow flag
the names that are in list A but not in list B.

Thanks

BAM
 
S

Smirnoff

bam said:
Hello, I have a list of names in column A (a subset of the names on
list B) and a list of names in column B (the entire list of names). Is
there some way to compare the two lists and highlight, copy elsewhere,
or somehow flag the names that are in list A but not in list B.

Thanks

BAM
Click to expand...
Are you talking about two worksheets?
If so, with both open, try the Compare side by side function under the
Window menu.

http://office.microsoft.com/trainin...ID=RP011212121033&CTT=6&Origin=RP011212401033

Not sure whether this allows editing but see tutorial in link above.
 

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

Weekly Report 2
Insert name and adress from a list in a word document 1
Finding the right style field in VBA 0
Extracting a cell value 2
Finding the proper style field and the numbered paragraph value within the style 0
Change a great number of words in word files, with a macro as short as possible. 5
How to make repeating drop-down lists? 2
MS Project Center-Autolink column fields 0

Top