Spreadsheet: 846737d1697884487-find-out-count-of-specific-products-invoice-by-sales-representatives-excel-2
Sheet: Sheet1

SR NAME | INVOICE NO. | ITEMNAME | QTY |  | RESULT |  |  | CONDITIONS
Sajal Kanti Das | BILL230008869 | PCNO 40ML BICOL NMRP | 12 |  | SR NAME | TOTAL EC |  | ITEMNAME | QTY REQUIREMENT | EC VALUE
Sajal Kanti Das | BILL230008869 | SP LOTION NM 200ML NMRP-1 | 4 |  |  |  |  |  | >=2 | 1
Sajal Kanti Das | BILL230008869 | PAEC 150ML APPLICATOR NMRP-3 | 2 |  | Deloar | 15 |  | SP LOTION NM 200ML NMRP-1 | >=2 | 1
Sajal Kanti Das | BILL230008870 | BELIPHOOL 100ML NMRP-3 | 6 |  | [NAME] | 13 |  | PAEC 150ML APPLICATOR NMRP-3 | >=2 | 1
Sajal Kanti Das | BILL230008871 | BELIPHOOL 100ML NMRP-3 | 0 |  | [NAME] | 16 |  | BELIPHOOL 100ML NMRP-3 | >=3 | 1
Sajal Kanti Das | BILL230008872 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6 |  | [NAME] | 12 |  | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | >=3 | 1
Sajal Kanti Das | BILL230008872 | PCNO 40ML BICOL NMRP | 12 |  | PSR(Sajol Kumar) | 4 |  | PCNO 350ML BICOL NMRP | >=1 | 1
Sajal Kanti Das | BILL230008872 | PCNO 350ML BICOL NMRP | 2 |  |  |  |  | PN [NAME] 2TK 960X5.25ML | >=1 | 1
Sajal Kanti Das | [NAME] | PCNO 40ML BICOL NMRP | 12 |  |  |  |  | BELI CO (F 30 ML) [NAME] | >=1 | 1
Sajal Kanti Das | [NAME] | PN [NAME] 2TK 960X5.25ML | 120 |  |  |  |  | PCNO 100ML BICOL NMRP | >=1 | 1
Sajal Kanti Das | [NAME] | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6 |  |  |  |  | BELIPHOOL 35ML NMRP-2 | >=12 | 1
Sajal Kanti Das | BILL230008874 | BELI CO (F 30 ML) [NAME] | 6 |  |  |  |  | PCNO 500ML BICOL NMRP | >=1 | 1
Sajal Kanti Das | BILL230008895 | BELI CO (F 30 ML) [NAME] | 6 |  |  |  |  | JFB OIL 210TK 72X100ML | >=1 | 1
Sajal Kanti Das | BILL230008896 | PCNO 100ML BICOL NMRP | 0 |  |  |  |  | JFB LOTION 100ML NMRP BB3Y | >=1 | 1
Sajal Kanti Das | BILL230008896 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 0 |  |  |  |  | BELIPHOOL 300ML NMRP-1 | >=1 | 1
Sajal Kanti Das | BILL230008897 | BELIPHOOL 35ML NMRP-2 | 24 |  |  |  |  | BELIPHOOL 200ML NMRP-3 | >=1 | 1
Sajal Kanti Das | BILL230008898 | PCNO 350ML BICOL NMRP | 2 |  |  |  |  | PCNO CO (F 20ML) 155TK 72X220ML | >=1 | 1
Sajal Kanti Das | BILL230008898 | PCNO 500ML BICOL NMRP | 2 |  |  |  |  | JFB FACE CREAM 130TK 48X50G | >=1 | 1
Sajal Kanti Das | BILL230008902 | BELIPHOOL 35ML NMRP-2 | 24 |  |  |  |  | SP LOTION NM 310TK 24X300ML | >=1 | 1
Sajal Kanti Das | BILL230008903 | BELIPHOOL 35ML NMRP-2 | 24 |  |  |  |  | [NAME] 72X100ML | >=1 | 1
Sajal Kanti Das | BILL230008904 | BELIPHOOL 35ML NMRP-2 | 24 |  |  |  |  | JFB LOTION 320TK 48X200ML | >=1 | 1
Sajal Kanti Das | BILL230008905 | BELIPHOOL 35ML NMRP-2 | 24 |  |  |  |  | PA AV Oil 165TK 96X150ML | >=1 | 1
Deloar | BILL230008908 | BELIPHOOL 35ML NMRP-2 | 36 |  |  |  |  | SP PJ 25TK 288X15ML | >=12 | 1
Deloar | BILL230008908 | PCNO 40ML BICOL NMRP | 24 |  |  |  |  | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | >=1 | 1
Deloar | BILL230008908 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 3 |  |  |  |  | PN SHMP DM SCHT 2TK 960X5.5ML | >=12 | 1
Deloar | BILL230008909 | JFB OIL 210TK 72X100ML | 6
Deloar | BILL230008909 | BELIPHOOL 100ML NMRP-3 | 6
Deloar | BILL230008920 | JFB LOTION 100ML NMRP BB3Y | 2
Deloar | BILL230008921 | BELIPHOOL 100ML NMRP-3 | 12
Deloar | BILL230008957 | BELIPHOOL 100ML NMRP-3 | 12
Deloar | BILL230008957 | BELIPHOOL 300ML NMRP-1 | 3
Deloar | BILL230008957 | JFB OIL 210TK 72X100ML | 3
Deloar | BILL230008958 | BELI CO (F 30 ML) [NAME] | 9
Deloar | BILL230008959 | BELIPHOOL 35ML NMRP-2 | 24
Deloar | BILL230008959 | PCNO 500ML BICOL NMRP | 2
Deloar | BILL230008959 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 12
Deloar | BILL230008959 | PCNO 40ML BICOL NMRP | 12
[NAME] | BILL230013716 | PCNO 100ML BICOL NMRP | 6
[NAME] | BILL230013751 | SP LOTION NM 200ML NMRP-1 | 4
[NAME] | BILL230013751 | SP LOTION NM 200ML NMRP-1 | 1
[NAME] | BILL230013753 | PCNO 100ML BICOL NMRP | 3
[NAME] | BILL230013764 | PCNO 40ML BICOL NMRP | 12
[NAME] | BILL230013766 | PCNO 40ML BICOL NMRP | 12
[NAME] | BILL230013766 | PCNO 100ML BICOL NMRP | 12
[NAME] | BILL230013771 | BELIPHOOL 200ML NMRP-3 | 3
[NAME] | BILL230013771 | PCNO 40ML BICOL NMRP | 12
[NAME] | BILL230013773 | BELIPHOOL 100ML NMRP-3 | 6
[NAME] | BILL230013773 | PCNO 40ML BICOL NMRP | 12
[NAME] | BILL230013780 | PCNO 100ML BICOL NMRP | 4
[NAME] | BILL230013780 | PCNO 100ML BICOL NMRP | 20
[NAME] | BILL230013780 | BELIPHOOL 100ML NMRP-3 | 24
[NAME] | BILL230013785 | PCNO 100ML BICOL NMRP | 12
[NAME] | BILL230013787 | PCNO 40ML BICOL NMRP | 12
[NAME] | BILL230013795 | PCNO CO (F 20ML) 155TK 72X220ML | 0
[NAME] | BILL230013796 | PCNO CO (F 20ML) 155TK 72X220ML | 0
[NAME] | BILL230013800 | PCNO CO (F 20ML) 155TK 72X220ML | 2
[NAME] | BILL230013802 | PCNO CO (F 20ML) 155TK 72X220ML | 2
PSR(Sajol Kumar) | BILL230013805 | BELIPHOOL 100ML NMRP-3 | 39
PSR(Sajol Kumar) | BILL230013805 | BELIPHOOL 100ML NMRP-3 | 105
PSR(Sajol Kumar) | BILL230013805 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6
PSR(Sajol Kumar) | BILL230013805 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 78
[NAME] | BILL230013807 | JFB FACE CREAM 130TK 48X50G | 2
[NAME] | BILL230013807 | PCNO 500ML BICOL NMRP | 1
[NAME] | BILL230013807 | SP LOTION NM 310TK 24X300ML | 1
[NAME] | BILL230013810 | PCNO 100ML BICOL NMRP | 12
[NAME] | BILL230013810 | PCNO 40ML BICOL NMRP | 12
[NAME] | BILL230013810 | BELI CO (F 30 ML) [NAME] | 6
[NAME] | BILL230013819 | PCNO 500ML BICOL NMRP | 1
[NAME] | BILL230013838 | SP LOTION NM 200ML NMRP-1 | 1
[NAME] | BILL230013840 | BELIPHOOL 100ML NMRP-3 | 144
[NAME] | BILL230013840 | [NAME] 72X100ML | 6
[NAME] | BILL230013840 | JFB LOTION 320TK 48X200ML | 6
[NAME] | BILL230013842 | SP LOTION NM 310TK 24X300ML | 1
[NAME] | BILL230013849 | PA AV Oil 165TK 96X150ML | 2
[NAME] | BILL230013850 | PA AV Oil 165TK 96X150ML | 0
[NAME] | BILL230013855 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6
[NAME] | BILL230013857 | SP PJ 25TK 288X15ML | 0
[NAME] | BILL230013862 | PCNO 350ML BICOL NMRP | 2
[NAME] | BILL230013864 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 0
[NAME] | BILL230014109 | BELIPHOOL 200ML NMRP-3 | 3
[NAME] | BILL230014110 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 3
[NAME] | BILL230014111 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1
[NAME] | BILL230014122 | PN SHMP DM SCHT 2TK 960X5.5ML | 24
[NAME] | BILL230014123 | BELIPHOOL 200ML NMRP-3 | 0
[NAME] | BILL230014124 | BELIPHOOL 100ML NMRP-3 | 6
[NAME] | BILL230014821 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1
[NAME] | BILL230014835 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6
[NAME] | BILL230014837 | PCNO CO (F 20ML) 155TK 72X220ML | 6
[NAME] | BILL230014999 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1
[NAME] | BILL230015000 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1