Hi
I woild request someone to please help ne out once again in excel . What I am trying to achieve in excel by way of a formulae is to try and match cells in the same column which are partially same for a particular category mentioned in the corresponding cells.So lets assume I have 2 columns , col A and col B. Col A has categories such as 1, 2, 3and each categpry has 8 -10 entries. Now I need to check the cells in col B for each of these categories for partial or exact match.So col B may have entries like this; cell B1 may contain terms like apple +banana+mango and B3 may contain entries like apple+grapes+oranges. Both these cells may pertain to the same category say category 1. In that case excel should give me true.Even if any one word matches it should give me true.
Regards
Murtuza