Compare two lists of names

[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

 

[JE McGimpsey]

See

http://cpearson.com/excel/duplicates.aspx

 

[Smirnoff]

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

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.

 

[bam]

Perfect,
Thanks
bam

See

http://cpearson.com/excel/duplicates.aspx

 

[bam]

Thanks very much,
BAM

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.