Dear Expert,
Need help to get result as mentioned below,
<tbody>
</tbody>
if i type or validate in column B3, want display result as per attached file in in column c
<colgroup><col><col></colgroup><tbody>
</tbody>
Regards,
Yaseen
Need help to get result as mentioned below,
AWB No | Remark | Reason |
12345678 | cash not ready | here i want result |
<tbody>
</tbody>
if i type or validate in column B3, want display result as per attached file in in column c
Tomorrow | Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (customer not available) |
Residence closed | Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (residence close) |
Cash not ready | Spoken to Mr, as per Consignee cash not ready want delivery on 20.08.2018 |
Not Respond | Try to Mr, call not respond, will next attempt 20.08.2018 (short address) SMS SEND |
Unreachable | Try to Mr, call not reachable, will next attempt 20.08.2018 (customer not available) SMS SEND |
Switchedoff | Try to Mr, call switch off, will next attempt 20.08.2018 (customer not available)SMS SEND |
Self Collect | Spoken to Mr, as per Consignee he will self-collect from office |
Double order | Spoken to Mr, as per Consignee want to cancelled shipment dueDOUBLE ORDER |
RTO | Spoken toMr, as per Consignee want to cancelled shipment due CHANGE OF MIND |
Cancelled | Spoken to Mr, as per Consignee want to cancelled shipment due DELAY IN DELIVERY |
Out of station | Spoken to Mr, as per Consignee want shipment delivery on dated. 20.08.2018 (out off station) |
Office closed | Spoken to Mr, as per Consignee want shipment delivery on dated 20.08.2018 (Office closed) |
Misrout | Misrout within city |
ODA | Spoken to Mr, as per Consignee shipment address is out of delivery area |
Non attempt | Spoke to Mr, apologised and committed to next day delivery (NOT ATTEMPTED ) |
<colgroup><col><col></colgroup><tbody>
</tbody>
Regards,
Yaseen