Spreadsheet: 846816d1697975820-find-out-count-of-specific-products-invoice-by-sales-representatives-excel-2-v2
Sheet: Sheet1

SR NAME | INVOICE NO. | ITEMNAME | QTY |  | EXPECTED RESULT |  |  | CONDITIONS
Sajal Kanti Das | BILL230008869 | PCNO 40ML BICOL NMRP | 12 |  | SR NAME | TOTAL EC |  | ITEMNAME | Minimum | EC VALUE
Sajal Kanti Das | BILL230008869 | SP LOTION NM 200ML NMRP-1 | 4 |  |  | 5 |  |  | 2 | 1
Sajal Kanti Das | BILL230008872 | PCNO 350ML BICOL NMRP | 2 |  | Deloar | 9 |  | SP LOTION NM 200ML NMRP-1 | 2 | 1
Sajal Kanti Das | [NAME] | PCNO 40ML BICOL NMRP | 12 |  | [NAME] | 4 |  | PCNO 350ML BICOL NMRP | 2 | 1
Sajal Kanti Das | BILL230008905 | BELIPHOOL 35ML NMRP-2 | 24 |  | [NAME] | 5 |  | BELIPHOOL 35ML NMRP-2 | 3 | 1
Deloar | BILL230008908 | BELIPHOOL 35ML NMRP-2 | 36 |  | PSR(Sajol Kumar) | 2 |  | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 3 | 1
Deloar | BILL230008908 | PCNO 40ML BICOL NMRP | 24 |  | [NAME] | 9 |  | JFB OIL 210TK 72X100ML | 1 | 1
Deloar | BILL230008908 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 3 |  |  |  |  | BELIPHOOL 300ML NMRP-1 | 1 | 1
Deloar | BILL230008909 | JFB OIL 210TK 72X100ML | 6 |  | [NAME] |  |  | BELI CO (F 30 ML) [NAME] | 1 | 1
Deloar | BILL230008957 | BELIPHOOL 300ML NMRP-1 | 3 |  |  | Total EC |  | PCNO 500ML BICOL NMRP | 1 | 1
Deloar | BILL230008957 | JFB OIL 210TK 72X100ML | 3 |  | Sajal Kanti Das | 5 |  | BELIPHOOL 100ML NMRP-3 | 12 | 1
Deloar | BILL230008958 | BELI CO (F 30 ML) [NAME] | 9 |  | Deloar | 9 |  | PCNO 100ML BICOL NMRP | 1 | 1
Deloar | BILL230008959 | BELIPHOOL 35ML NMRP-2 | 24 |  | [NAME] | 5 |  | JFB FACE CREAM 130TK 48X50G | 1 | 1
Deloar | BILL230008959 | PCNO 500ML BICOL NMRP | 2 |  | [NAME] | 5 |  | SP LOTION NM 310TK 24X300ML | 1 | 1
[NAME] | BILL230013773 | BELIPHOOL 100ML NMRP-3 | 6 |  | PSR(Sajol Kumar) | 2 |  | PA AV Oil 165TK 96X150ML | 1 | 1
[NAME] | BILL230013773 | PCNO 40ML BICOL NMRP | 12 |  | [NAME] | 9 |  | BELIPHOOL 200ML NMRP-3 | 1 | 1
[NAME] | BILL230013780 | PCNO 100ML BICOL NMRP | 4 |  |  |  |  | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1 | 1
[NAME] | BILL230013780 | PCNO 100ML BICOL NMRP | 20 |  | [NAME] |  |  | PCNO CO (F 20ML) 155TK 72X220ML | 1 | 1
[NAME] | BILL230013780 | BELIPHOOL 100ML NMRP-3 | 24 |  |  | TOTAL EC
[NAME] | BILL230013785 | PCNO 100ML BICOL NMRP | 12 |  | Sajal Kanti Das | 5
[NAME] | BILL230013787 | PCNO 40ML BICOL NMRP | 12 |  | Deloar | 9
PSR(Sajol Kumar) | BILL230013805 | BELIPHOOL 100ML NMRP-3 | 39 |  | [NAME] | 4 |  | [NAME] | BILL230013785 | PCNO 100ML BICOL NMRP | 12 | 1
PSR(Sajol Kumar) | BILL230013805 | BELIPHOOL 100ML NMRP-3 | 105 |  | [NAME] | 4 |  | [NAME] | BILL230013787 | PCNO 40ML BICOL NMRP | 12 | 2
PSR(Sajol Kumar) | BILL230013805 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6 |  | PSR(Sajol Kumar) | 2 |  | [NAME] | BILL230013849 | PA AV Oil 165TK 96X150ML | 2 | 3
PSR(Sajol Kumar) | BILL230013805 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 78 |  | [NAME] | 9 |  | [NAME] | BILL230013850 | PA AV Oil 165TK 96X150ML | 0 | less as minumum
[NAME] | BILL230013807 | JFB FACE CREAM 130TK 48X50G | 2 |  |  |  |  | [NAME] | BILL230013855 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6 | 4
[NAME] | BILL230013807 | PCNO 500ML BICOL NMRP | 1 |  |  |  |  | [NAME] | BILL230014123 | BELIPHOOL 200ML NMRP-3 | 0 | less as minumum
[NAME] | BILL230013807 | SP LOTION NM 310TK 24X300ML | 1 |  |  |  |  | [NAME] | BILL230014124 | BELIPHOOL 100ML NMRP-3 | 6 | less as minumum
[NAME] | BILL230013810 | PCNO 100ML BICOL NMRP | 12 |  |  |  |  |  |  |  |  | End result
[NAME] | BILL230013810 | PCNO 40ML BICOL NMRP | 12 |  |  |  |  | All invoices of [NAME] are different, so there is no need to take something together. |  |  |  | 4
[NAME] | BILL230013810 | BELI CO (F 30 ML) [NAME] | 6
[NAME] | BILL230013849 | PA AV Oil 165TK 96X150ML | 2 |  |  |  |  | [NAME] | BILL230013773 | BELIPHOOL 100ML NMRP-3 | 6 | less as minimum
[NAME] | BILL230013850 | PA AV Oil 165TK 96X150ML | 0 |  |  |  |  | [NAME] | BILL230013773 | PCNO 40ML BICOL NMRP | 12 | 1
[NAME] | BILL230013855 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6 |  |  |  |  | [NAME] | BILL230013780 | PCNO 100ML BICOL NMRP | 4 | 2
[NAME] | BILL230014123 | BELIPHOOL 200ML NMRP-3 | 0 |  |  |  |  | [NAME] | BILL230013780 | PCNO 100ML BICOL NMRP | 20
[NAME] | BILL230014124 | BELIPHOOL 100ML NMRP-3 | 6 |  |  |  |  | [NAME] | BILL230013780 | BELIPHOOL 100ML NMRP-3 | 24 | 3
[NAME] | BILL230014821 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1 |  |  |  |  | [NAME] | BILL230014821 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1 | 4
[NAME] | BILL230014837 | PCNO CO (F 20ML) 155TK 72X220ML | 6 |  |  |  |  |  |  |  |  | End result
[NAME] | BILL230014999 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1 |  |  |  |  |  |  |  |  | 4
[NAME] | BILL230015000 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1