Need to have a formula to calculate the result based upon two different cell and conditions.
ear All,
I have a sheet as below:
Invoice No. Product Type Shipment Type
A1 Cold Chain
A1 Non Cold
A1 Cold Chain
A1 Non Cold
A1 Non Cold
B1 Cold Chain
B1 Cold Chain
B1 Cold Chain
B1 Cold Chain
B1 Cold Chain
C2 Non Cold
C2 Non Cold
C2 Non Cold
C2 Non Cold
C2 Non Cold
C2 Non Cold
C2 Non Cold
D2 Non Cold
D2 Non Cold
D2 Non Cold
D2 Non Cold
D2 Cold 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.
ear All,
I have a sheet as below:
Invoice No. Product Type Shipment Type
A1 Cold Chain
A1 Non Cold
A1 Cold Chain
A1 Non Cold
A1 Non Cold
B1 Cold Chain
B1 Cold Chain
B1 Cold Chain
B1 Cold Chain
B1 Cold Chain
C2 Non Cold
C2 Non Cold
C2 Non Cold
C2 Non Cold
C2 Non Cold
C2 Non Cold
C2 Non Cold
D2 Non Cold
D2 Non Cold
D2 Non Cold
D2 Non Cold
D2 Cold 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.