You can do this with VBA and use the Case Select functions. You will need to identity each of the combinations and the expected result for each of the combos. If you would like to upload a sample (representative) workbook with these scenarios, I am sure that a viable solution can be supplied. Without seeing some actual information, it is difficult to prescribe a solution.
|