Compare values using contains does not work as expected

[aparna0208]

Hi,

I am trying to compare two values between column A and B row by row and see if any part of the string is contained in the other column

Example

Column A                                                                 Column B                                                                       Column C

ABC Brokerage Services                                       ABC Advisory Services                                                   True

XYZ Network Advisory Services                            XYZ Network Advisory Services                                      True

ABC Corp                                                               XYZ Corp                                                                         False

I tried to use contains for example Contains(Column A, Column B) but does not do a good job in comparing the values and returns just few rows and not all what I expected. So, I wanted to see if there is any other better way to compare values. Thank you in advance

[tfitz · Accepted solution]

Use a formula and filter to compare this example. Formula: Column C = Left([A], 3). Then filter if Column B contains letters found in Column C.

This extracts a common key identifier. You could then union the two together to get back to a full population with TRUE/FALSE values.

[tfitz · Accepted solution]

[aparna0208]

@tfitz It worked:) Thank you so much!