Compare values in two columns

K

Kathy

Hello,

I have a list of names in Coluumn A and another list of
names in column B, I need Column C to display the names
that appear in both column A and column B.
 
G

Guest

=IF(A1=B1,A1)You could return either A1 or B1, or course,
since they're the same. This function will return FALSE if
they are not equal, unless you specify otherwise.

Mike
 

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

MS Project Center-Autolink column fields 0
Extracting a cell value 2
Finding the right style field in VBA 0
How to center adjust text above and image in a two column document. 1
Excel does not accept text format! 0
Finding the proper style field and the numbered paragraph value within the style 0
Two columns followed by single page-width column on same page 0
Format column widths from one table to a separate table on same page 1

Top