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
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