comparing 2 columns

[YuLing]

Hi
i would like to compare two columns in excel and return the text tha
is repeated on both of the first 2 (A and B) columns and list all th
text that was repeated in another 3rd(C) column

example:
---A---|---B---|---C---|
text1 | text1 | text1 |
text2 | text2 | text2 |
text3 | text5 | text5 |
text4 | text6 | text6 |
text5 | text7 |
text6 | text9 |

how can this be done??

thank

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

 

[crossplatform]

put this for your third column:
=VLOOKUP(B1,A:A,1,FALSE)

hope this help

 

[YuLing]

Thanks for all the help Frank and crossplatform

Took me a few try but i finally got the result that i wanted...so
just wanted to put up a post here with the solution i've found tha
work the best for me in case anyone having the same problem as me wil
find it helpfull

Enter this formula to the C column
=IF(COUNTIF($A$1:$A$10,B1)>0,B1,"")

you can change the B1, A$1:A$10 as according to your requirement

for me, i've change it to
=IF(COUNTIF($B$1:$B$1133,A1)>0,A1,"")

then after you enter the formula, go to EDIT and use the FILL > DOWN

it will then list out in column C the repeated text that was in colum
A & B

Thanks again for all the help


YuLin