comparing 2 columns

  • Thread starter Thread starter YuLing
  • Start date Start date
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
 
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
 
Back
Top