View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susanne Susanne is offline
external usenet poster
 
Posts: 20
Default compare & match text

In column A I have the names of the participants and in column B I have the
names of their room mate. Meaning that everybody are mentioned in both
columns of course. Now I need to check that if John is Kenns room mate then
Kenn is also Johns room mate.

Could anyone please help me.

Thanks,
Susanne