2 Replies Latest reply: Apr 3, 2012 4:31 AM by mrkachhia RSS

    Column based on selection

      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