Spreadsheet: 735223d1622772527-help-cant-work-out-after-two-days-trying-unique-count-with-multiple-criteria-excelforum-test-data
Sheet: Sheet1

Customer ID | Customer Name | Item Number | Item Name | Quantity | Document Number | Date | Sales Rep |  |  | Select Sales Rep | WA
022587 | My Medical & Dental Centre | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 4 | SO87113 | 2020-12-05 00:00:00 | WA |  |  | Select Item Number | 1021
022587 | My Medical & Dental Centre | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 1 | SO87113 | 2020-12-05 00:00:00 | WA |  |  | ANSWER -->
018100 | Rejuvie Skin Therapy | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 4 | SO87114 | 2020-12-05 00:00:00 | QLD1
000515 | La Bella Health & Beauty Pty Ltd | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 5 | SO87117 | 2020-12-05 00:00:00 | QLD2
017970 | Champagne Therapy Beauty & Massage | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87122 | 2020-12-05 00:00:00 | SA/NT |  |  | Hi, I want to be able to count how many customers from WA bought Item # 1021. I don’t want the count
015099 | Set Me Free Spa | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 1 | SO87123 | 2020-12-05 00:00:00 | VIC |  |  | to count a customer twice, so its "Unique" customers
023017 | YOR Aesthetics | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 2 | SO87124 | 2020-12-06 00:00:00 | WA
016904 | Essential Beauty - Indooroopilly | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 1 | SO87125 | 2020-12-06 00:00:00 | QLD1 |  |  | eg in the sample data you can see customers "MY Medical & Dental Centre" and "YOR Aesthetics" have bought item #1021
016904 | Essential Beauty - Indooroopilly | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87125 | 2020-12-06 00:00:00 | QLD1 |  |  | twice/on two occassions. I only want "MY Medical & Dental Centre" and "YOR Aesthetics" to be counted once
017613 | Essential [NAME] | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87127 | 2020-12-06 00:00:00 | SA/NT
015383 | Beauty By [NAME] | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87136 | 2020-12-07 00:00:00 | WA |  |  | So I'm trying to work out how many customers from WA have bought item # 1021
002047 | [NAME] | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87137 | 2020-12-07 00:00:00 | NSW1
020461 | Agave Beauty | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 1 | SO87138 | 2020-12-07 00:00:00 | NSW1 |  |  | I want to use cells L1 and L2 to be able to change the Sales Rep and the Item Number
019987 | DH [NAME] | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87143 | 2020-12-07 00:00:00 | QLD1
002129 | [NAME] | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87157 | 2020-12-07 00:00:00 | SA/NT
002129 | [NAME] | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 1 | SO87157 | 2020-12-07 00:00:00 | SA/NT
023745 | Sundoctors Byron Bay | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 3 | SO87159 | 2020-12-07 00:00:00 | QLD2 |  |  | Hope this makes sense
018285 | Intoto Face and Body Centre | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87163 | 2020-12-07 00:00:00 | WA
022476 | Ripley Medical & Skin Clinic | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 1 | SO87164 | 2020-12-07 00:00:00 | QLD2 |  |  | Many thanks. [NAME]
022476 | Ripley Medical & Skin Clinic | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 1 | SO87164 | 2020-12-07 00:00:00 | QLD2
005313 | Pharmacy Express Mount Annan | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 3 | SO87166 | 2020-12-07 00:00:00 | NSW2
000756 | Respect Cosmetic Medicine & Beauty | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 3 | SO87170 | 2020-12-07 00:00:00 | SA/NT
016889 | Skindulgence | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 2 | SO87171 | 2020-12-07 00:00:00 | SA/NT
016889 | Skindulgence | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 3 | SO87171 | 2020-12-07 00:00:00 | SA/NT
022587 | My Medical & Dental Centre | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 6 | SO87000 | 2020-12-15 00:00:00 | WA
022587 | My Medical & Dental Centre | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 1 | SO87001 | 2020-12-15 00:00:00 | WA
023017 | YOR Aesthetics | 1064 | 1.PRODUCT - ASAP : [NAME] 15ml | 2 | SO88000 | 2020-12-26 00:00:00 | WA
023018 | YOR Aesthetics | 1021 | 1.PRODUCT - ASAP : Super C Serum 30ml | 4 | SO88001 | 2020-12-27 00:00:00 | WA