Compare Text Columns and return same value

sbr

New Member
Joined
Dec 10, 2005
Messages
1
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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,732
Messages
5,573,903
Members
412,555
Latest member
mark84
Top