Excel: Compare contents of columns

[Gabriel Rickenbacher]

Dear newsgroup

I have values in column A and values in column B. The values are not sorted
and can contain letters as well as numbers. How can I find out which values
in column B match with a value in column A?

Thank you for any feedback.

Kind regards

Gabriel Rickenbacher

 

[Bob I]

The "Match" function would probably do the trick. See Excel Help for
Examples and Usage.

 

[Gordon]

Dear newsgroup

I have values in column A and values in column B. The values are not sorted
and can contain letters as well as numbers. How can I find out which values
in column B match with a value in column A?

Thank you for any feedback.

Kind regards

Gabriel Rickenbacher

Try here:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates