• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To get a result based upon multiple factors

S

Saurabh Singh

New Member
Product Desc Product Temp. Airway Bill No Shipment Type
HIV 1/2 ELISA 3.0 96 Test Normal 40866878
Urocolor 4S Cold 1103534
SD HAV IgG/IgM Device (s/p) - 25t Normal 1103534
Urocolor 2 Strip 100 Test Normal 1103534
Alere Afinion CRP (15t) IN, 1116058 Cold 58252468282
Alere Afinion Lipid Panel (15t) IN Normal 58252468282
TITAN III-HB Normal 58252468245
EPOC BGEM Test Cards + Glu & Lact (50t) Cold 58252468260
Microplate Reader Normal 50327458532
Microplate Reader Normal 50327458650
ALERE TM H380, 3 PART DIFFERENTIAL HEAMO Normal 50327458576

I want to have shipment type as "Cold" for any Airway Bill No. having any cold item in it. For Example, in AWB No. 1103534, I have Cold and Normal, both type of products and thus the formula result for Nature of shipment should be cold for all entries of AWB No.- 1103534. If it has only cold products, then Nature of shipment would be Cold and if has all Normal, then Nature of shipment would be Normal.

Tried to upload a sample file in .xlxs format. Giving error on that.

Thank you
Singh
 
Hi Saurabh

If you face a difficulty in uploading Excel workbooks , see if you can upload files having other file extensions such as .txt , .doc

If you are able to upload these files , just rename your .xlsx file to .txt or doc , and upload your file. Whoever downloads the file will rename it.

Narayan
 
You must log in or register to reply here.
Back
Top