Let me know if my enclosed example can be done by any other simple way.
Check some description below to understand what I want to achieve.
- I have multiple supplier i.e. SupplierA, SupplierB, SupplierC, SupplierD for different products i.e. FRUITs
- My idea behind this example is to check % difference in prices of any supplier with respect to minimum price of all other supplier.
- Upon selection supplier from Selection (LIST BOX PROPERTIES), respective prices from column 2,3,4 or 5 will be disappeared and column 8 will show price for the same supplier.
- Column 9 will calculate % difference between price of selected supplier vs minimum price from all other supplier.
Regards,
Manish