S
Nhờ các anh chị em giỏi Excel giúp đỡ dùm công thức Excel để lấy ra được Số hoá đơn và ngày hoá đơn nhé! Số và ngày hoá đơn nằm từ chữ HS(kép) hoặc Inv trở đi. Cảm ơn các anh chị em nhiều!:wall:
Nk A18-MRIR-P-001-PTSC. Po 205-2008/PTSC-CKHH/MHH (Rq PLDP-A-IM-0053&86) H§ 00029 (05/06/2008)PPEARL
Nk SD-MRIR-PTSC-SDA-E&I-077. Po 181-2008/PTSCMC/MHH (Rq SDA-IM-254) Inv 0805216 (23/05/2008)SD
Nk A09-MRIR/CKHH-467. Rq 113/08/P§X-X§. H§ 0090081 (26/06/2008)SXC
Nk A09-MRIR/CKHH-425. §H 271-2008/PTSCMC/MHH (Rq 186&190/XCK/2008) H§ 0141285 (30/06/2008)SXC
Nk A18-MRIR/Pearl-191. §H 2511-2008/CV-KH/CKHH (Rq 21/Pearl/KCT) H§ 0141264 (23/06/2008)PEARL
Nk A18-MRIR/Pearl-190. §H 317-2008/PTSCMC/MHH (Rq 045/08/DVTH-CKHH) H§ 0000250 (18/06/2008)PEARL
Nk §T-MRIR/§T-064. §H 292-2008/PTSCMC/MHH (Rq 104/KCT) H§ 0075620 (04/07/2008)DTAU
Nk A09-MRIR/CKHH-479. Rq 112/XDTD/2008. H§ 0027696 (04/07/2008)SXC
Nk A18-MRIR/Pearl-193. §H 2513-2008/CV-KH-CKHH (Rq 21/Pearl/KCT) H§ 0141265 (23/06/2008)PEARL
Nk A18-MRIR/Pearl-204. §H 2553-2008/CV-KH/CKHH (Rq 046/08/DVTH-CKHH) H§ 0162653 (25/06/2008)PEARL
Nk A18-MRIR/Pearl-200. Po 273-2008/PTSCMC/MHH (Rq 94/Pearl/KCT) H§ 0187770 (26/06/2008)PEARL
Nk A18-MRIR/Pearl-201&202. Po 004-2008/PTSCMC-MHH (Rq 21/Pearl/KCT) H§ 0015750&0015729(25,30/06/2008)PEARL
Nk A18-MRIR/Pearl-195&183. PO 006-2008/PTSCMC-MHH (Rq 21/Pearl/KCT) H§ 001411 (24/06/2008)PEARL
Nk A09-MRIR/CKHH-421. Po 248-2008/PTSCMC/MHH (Rq 173/XCK,71/KCT,75/XPV/KCT) H§ 0157053 (26/06/2008)SXC
Nk §T-MRIR/§T-067&057. §H298-2008/PTSCMC/MHH (Rq 101/§T/KCT) H§ 005902&03 (26/06/2008)DTAU
Nk §T-MRIR/§T-065. §H 297-2008/PTSCMC/MHH (Rq 101/D0T/KCT) H§ 004435 (14/06/20008)DTAU
Nk A09-MRIR/CKHH-470. Rq 115/08/XDTD. H§ 0031123&0097254 (01&07/07/2008)SXC
Nk XL2-MRIR/XLII-037. Po 209-2008/PTSCMC/MHH (Rq 28/§X-XL2&100/2008/CV-XL2) H§ 0069674 (01/07/2008)XL2
Nk §T-MRIR/§T-060. §H 333-2008/PTSCMC/MHH (Rq 077/§T/KCT) H§ 0076344 (03/07/2008)DTAU
Nk A09-MRIR/CKHH-478. §H 335-2008/PTSCMC/MHH (Rq 65&109/§T§/08) H§ 0076349&0076350 (04/07/2008)SXC
Nk §T-MRIR/§T-063&059. §H 335-2008/PTSCMC/MHH (Rq 114,077,101/§T/KCT&82/X§T§/08) H§ 0076349&0076350 (04/07/2008)DTAU
Nk BO-Bunga Orkid/MRIR-35. Rq 83/ORKID/M/2008. H§ 0036796 (07/07/2008)ORKID
Nk A09-MRIR/CKHH-487. Rq 124/KCT. H§ 0091253 (0707/2008)SXC
Nk §T-MRIR/§T-080. §H 290-2008/PTSCMC/MHH (Rq 077/§T/KCT) H§ 0118793 (04/07/2008)DTAU
Nk A09-MRIR/CKHH-498. §H 364-2008/PTSCMC-MHH (Rq 289/XCKLM/2008) H§ 0024858 (12/07/2008)SXC
Nk A09-MRIR/CKHH-507. §H 305-2008/PTSCMC-MHH (Rq 163/XCK/2008) H§ 005099 (09/07/2008)SXC
Nk A09-MRIR/CKHH-508. §H 2858-2008/CV-KH-CKHH (Rq 002,003,049,040,057/08/DVTH-CKHH, 298/Pearl/2008) H§ 004867 (14/07/2008)SXC
Nk A18-MRIR-E&I-002-PTSC. Po 280-2008/PTSCMC/MHH (Rq PLDP-A-IM-0080) Inv AII/08/006 (09/06/2008)PPEARL
Nk DT-MRIR/§T-102. Rq 156/§T/KCT, H§ 0091264 (7/8/08)DTAU
Nk A18-MRIR-P-001-PTSC. Po 205-2008/PTSC-CKHH/MHH (Rq PLDP-A-IM-0053&86) H§ 00029 (05/06/2008)PPEARL
Nk SD-MRIR-PTSC-SDA-E&I-077. Po 181-2008/PTSCMC/MHH (Rq SDA-IM-254) Inv 0805216 (23/05/2008)SD
Nk A09-MRIR/CKHH-467. Rq 113/08/P§X-X§. H§ 0090081 (26/06/2008)SXC
Nk A09-MRIR/CKHH-425. §H 271-2008/PTSCMC/MHH (Rq 186&190/XCK/2008) H§ 0141285 (30/06/2008)SXC
Nk A18-MRIR/Pearl-191. §H 2511-2008/CV-KH/CKHH (Rq 21/Pearl/KCT) H§ 0141264 (23/06/2008)PEARL
Nk A18-MRIR/Pearl-190. §H 317-2008/PTSCMC/MHH (Rq 045/08/DVTH-CKHH) H§ 0000250 (18/06/2008)PEARL
Nk §T-MRIR/§T-064. §H 292-2008/PTSCMC/MHH (Rq 104/KCT) H§ 0075620 (04/07/2008)DTAU
Nk A09-MRIR/CKHH-479. Rq 112/XDTD/2008. H§ 0027696 (04/07/2008)SXC
Nk A18-MRIR/Pearl-193. §H 2513-2008/CV-KH-CKHH (Rq 21/Pearl/KCT) H§ 0141265 (23/06/2008)PEARL
Nk A18-MRIR/Pearl-204. §H 2553-2008/CV-KH/CKHH (Rq 046/08/DVTH-CKHH) H§ 0162653 (25/06/2008)PEARL
Nk A18-MRIR/Pearl-200. Po 273-2008/PTSCMC/MHH (Rq 94/Pearl/KCT) H§ 0187770 (26/06/2008)PEARL
Nk A18-MRIR/Pearl-201&202. Po 004-2008/PTSCMC-MHH (Rq 21/Pearl/KCT) H§ 0015750&0015729(25,30/06/2008)PEARL
Nk A18-MRIR/Pearl-195&183. PO 006-2008/PTSCMC-MHH (Rq 21/Pearl/KCT) H§ 001411 (24/06/2008)PEARL
Nk A09-MRIR/CKHH-421. Po 248-2008/PTSCMC/MHH (Rq 173/XCK,71/KCT,75/XPV/KCT) H§ 0157053 (26/06/2008)SXC
Nk §T-MRIR/§T-067&057. §H298-2008/PTSCMC/MHH (Rq 101/§T/KCT) H§ 005902&03 (26/06/2008)DTAU
Nk §T-MRIR/§T-065. §H 297-2008/PTSCMC/MHH (Rq 101/D0T/KCT) H§ 004435 (14/06/20008)DTAU
Nk A09-MRIR/CKHH-470. Rq 115/08/XDTD. H§ 0031123&0097254 (01&07/07/2008)SXC
Nk XL2-MRIR/XLII-037. Po 209-2008/PTSCMC/MHH (Rq 28/§X-XL2&100/2008/CV-XL2) H§ 0069674 (01/07/2008)XL2
Nk §T-MRIR/§T-060. §H 333-2008/PTSCMC/MHH (Rq 077/§T/KCT) H§ 0076344 (03/07/2008)DTAU
Nk A09-MRIR/CKHH-478. §H 335-2008/PTSCMC/MHH (Rq 65&109/§T§/08) H§ 0076349&0076350 (04/07/2008)SXC
Nk §T-MRIR/§T-063&059. §H 335-2008/PTSCMC/MHH (Rq 114,077,101/§T/KCT&82/X§T§/08) H§ 0076349&0076350 (04/07/2008)DTAU
Nk BO-Bunga Orkid/MRIR-35. Rq 83/ORKID/M/2008. H§ 0036796 (07/07/2008)ORKID
Nk A09-MRIR/CKHH-487. Rq 124/KCT. H§ 0091253 (0707/2008)SXC
Nk §T-MRIR/§T-080. §H 290-2008/PTSCMC/MHH (Rq 077/§T/KCT) H§ 0118793 (04/07/2008)DTAU
Nk A09-MRIR/CKHH-498. §H 364-2008/PTSCMC-MHH (Rq 289/XCKLM/2008) H§ 0024858 (12/07/2008)SXC
Nk A09-MRIR/CKHH-507. §H 305-2008/PTSCMC-MHH (Rq 163/XCK/2008) H§ 005099 (09/07/2008)SXC
Nk A09-MRIR/CKHH-508. §H 2858-2008/CV-KH-CKHH (Rq 002,003,049,040,057/08/DVTH-CKHH, 298/Pearl/2008) H§ 004867 (14/07/2008)SXC
Nk A18-MRIR-E&I-002-PTSC. Po 280-2008/PTSCMC/MHH (Rq PLDP-A-IM-0080) Inv AII/08/006 (09/06/2008)PPEARL
Nk DT-MRIR/§T-102. Rq 156/§T/KCT, H§ 0091264 (7/8/08)DTAU