comparing 2 columns

Y

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
 
Y

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
 

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

Top