hi all
i have a list of data in column A and B... i.e
A1 : pete rose B1 : pete sam rose (they are the same person)
A2 : amber kerr B2 : amber dawn saly kerr (they are the same person)

i am comparing these two by using =exact(..) , but the result is false
although its true. any suggestions ?