5 Replies Latest reply: Oct 30, 2015 9:19 AM by Massimo Grossi RSS

    Need to have a formula to calculate the result based upon two different cell and conditions

      Dear All,

       

      I have a sheet as below:

       

        

      Invoice No.Product TypeShipment Type
      A1Cold Chain
      A1Non Cold
      A1Cold Chain
      A1Non Cold
      A1Non Cold
      B1Cold Chain
      B1Cold Chain
      B1Cold Chain
      B1Cold Chain
      B1Cold Chain
      C2Non Cold
      C2Non Cold
      C2Non Cold
      C2Non Cold
      C2Non Cold
      C2Non Cold
      C2Non Cold
      D2Non Cold
      D2Non Cold
      D2Non Cold
      D2Non Cold
      D2Cold Chain

      In the table above, for any invoice, if it contains even one "Cold Chain" product type, the shipment type should be "Cold Chain" for all entries of that invoice.

      For Example: I have 5 items in invoice A1, of which 2 are cold chain and 3 are non cold. Need a formula to ensure, against each entry of invoice no. A1, it should define Shipment type as Cold Chain.

       

      Please help me to get the solution of. You can also mark me on my personal mail id - saurabh_kumar09@yahoo.com