This content has been marked as final. Show 2 replies
I have few data as per enclosed file.
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