Compare Text Columns and return same value

[sbr]

Hi, I need expert to provide some guidance.

I have 2 columns which I would like to compare. These columns are in text.
Those vaules(text) which occurred in both columns are return in another column. can this be done?

thanks in advance for the advise. Thankie

 

[Richard Schollar]

Try this in column C (assuming A and B are the columns to compare, the text in B occupies B1:B1000):

=IF(ISNUMBER(MATCH(A1,$B$1:$B$1000,0)),A1,"")

and copy down to whatever row the values in column A extend to.

regards

Richard

 

[Aladin Akyurek]

Hi, I need expert to provide some guidance.

I have 2 columns which I would like to compare. These columns are in text.
Those vaules(text) which occurred in both columns are return in another column. can this be done?

thanks in advance for the advise. Thankie

See my post in:

http://www.mrexcel.com/board2/viewtopic.php?t=144521

for extracting common items from two lists.