View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kashish kashish is offline
external usenet poster
 
Posts: 18
Default Search of particular combinations

In Column A & B there is different name but I want "yes" for below
particular combination else "No"

A A Yes
A B Yes
A C Yes
A D Yes
B A Yes
B B Yes
B C Yes
B D Yes
C A Yes
C B Yes
C C Yes
C D Yes
D A Yes
D B Yes
D C Yes
D D Yes
A E No
D F No
C L No