Comparing three columns

Hello,

I need some help! I have a spreadsheet and columns A , E and I contain phrases ( up to 5 words) . I want to compare the three columns to find exact matches that appear in all three. Is there a formula I could use. I can compare two columns but I don't know what to do to compare the three.


Thanks!

Hi

You could use

Please Login or Register  to view this content.

in the cell you want to store your result in. This example will compare A1 to E1 and I1, if both are equal then it writes 'True', otherwise 'False'. Just copy this formula down through all the cells you require.

Hope it helps.

Regards
Stephen.

Hey Guys,

Thanks for your help.

benishiryo, I changed your formula a bit to match the number of rows containing words and it no longer works. I get an error. I am comparing all together.

=SUMPRODUCT(--(A2:A1001&E2:E501=E2:E501&I2:I328))=ROWS(A2:A1001)

I would ideally like the phrase to be copied to the formula cell if there is a match.

Thanks again,