View Single Post
 
Old 05-17-2019, 11:18 AM
Alansidman's Avatar
Alansidman Alansidman is offline Windows 10 Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

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.
Reply With Quote