I have few data as per enclosed file.
Worksheets
Supplier showing all supplier I have
A showing data for supplier A
B showing data for supplier B
C showing data for supplier C
Final showing final table I need
If I will select Supplier B from supplier table (worksheet supplier), my final table should be as below
i.e. no price will appear for all parts in Supplier B column so that they will not be calculated while getting Min price.
Column 6 will automatically show Data for Supplier B (as selected above and ignored column in getting Min price) and % difference will be calculated in column 7 (% Diff)
i.e. (Min-Supplier B)/Supplier B
Part | Supplier A | Supplier B | Supplier C | Min | Supplier B | % Diff |
X | 10 | | 20 | 10 | 40 | -75.00% |
Y | 20 | | | 20 | | |
Z | 30 | | 15 | 15 | 50 | -70.00% |
Regards,
Manish Kachhia
