Spreadsheet: 874981d1721525503-stuck-trying-to-figure-last-condition-with-let-and-filter-function-stuck-trying-to-figure-last-condition-with-let-and-filter-function2-1-
Sheet: SaleData

OrderDate | Region | Manager | SalesMan | Item | Units | Unit_price | Sale_amt |  | Item | Region | Units | Year | Month |  | Item | Units | OrderDate | Region |  | Workings: | Item | Region | Units | Year | Month | All Criteria
2018-01-06 00:00:00 | East | [NAME] | [NAME] | Television | 95 | 1198 |  |  | Cell Phone |  | 20 | 2018 | Jan
2018-01-23 00:00:00 | Central | Hermann | [NAME] | Home Theater | 50 | 500 |  |  | Desk |  | 20 | 2019 | Feb |  |  |  |  |  |  |  | 3 | #N/A | 1 | 1 | 1 | False
2018-02-09 00:00:00 | Central | Hermann | [NAME] | Television | 36 | 1198 |  |  | Home Theater |  | 50 |  | Mar |  |  |  |  |  |  |  | 4 | #N/A | 1 | 1 | 2 | False
2018-02-26 00:00:00 | Central | Timothy | [NAME] | Cell Phone | 27 | 225 |  |  | Television |  | 50 |  | Apr |  |  |  |  |  |  |  | 1 | #N/A | 1 | 1 | 2 | False
2018-03-15 00:00:00 | West | Timothy | Stephen | Television | 56 | 1198 |  |  | Video Games |  | 75 |  | May |  |  |  |  |  |  |  | 4 | #N/A | 1 | 1 | #N/A | False
2018-04-01 00:00:00 | East | [NAME] | [NAME] | Home Theater | 60 | 500 |  |  |  |  |  |  | Jun |  |  |  |  |  |  |  | 3 | #N/A | 1 | 1 | 4 | False
2018-04-18 00:00:00 | Central | [NAME] | [NAME] | Television | 75 | 1198 |  |  |  |  |  |  | Jul |  |  |  |  |  |  |  | 4 | #N/A | #[NAME]! | 1 | 4 | False
2018-05-05 00:00:00 | Central | Hermann | [NAME] | Television | 90 | 1198 |  |  |  |  |  |  | Aug |  |  |  |  |  |  |  | 4 | #N/A | #[NAME]! | 1 | #N/A | False
2018-05-22 00:00:00 | West | [NAME] | [NAME] | Television | 32 | 1198 |  |  |  |  |  |  | Sep |  |  |  |  |  |  |  | 4 | #N/A | 1 | 1 | #N/A | False
2018-06-08 00:00:00 | East | [NAME] | [NAME] | Home Theater | 60 | 500 |  |  |  |  |  |  | Oct |  |  |  |  |  |  |  | 3 | #N/A | 1 | 1 | 6 | False
2018-06-25 00:00:00 | Central | Hermann | Sigal | Television | 90 | 1198 |  |  |  |  |  |  | Nov |  |  |  |  |  |  |  | 4 | #N/A | #[NAME]! | 1 | 6 | False
2018-07-12 00:00:00 | East | [NAME] | [NAME] | Home Theater | 29 | 500 |  |  |  |  |  |  | Dec |  |  |  |  |  |  |  | 3 | #N/A | 1 | 1 | 7 | False
2018-07-29 00:00:00 | East | [NAME] | [NAME] | Home Theater | 81 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | #N/A | #[NAME]! | 1 | 7 | False
2018-08-15 00:00:00 | East | [NAME] | [NAME] | Television | 35 | 1198 |  |  | Cell Phone | Central | 20 | 2018 | Jan |  |  |  |  |  |  |  | 4 | #N/A | 1 | 1 | #N/A | False
2018-09-01 00:00:00 | Central | [NAME] | [NAME] | Desk | 2 | 125 |  |  | Desk |  | 20 | 2019 | Feb |  |  |  |  |  |  |  | 2 | #N/A | 1 | 1 | 9 | False
2018-09-18 00:00:00 | East | [NAME] | [NAME] | Video Games | 16 | 58.5 |  |  | Home Theater |  | 50 |  | Mac |  |  |  |  |  |  |  | 5 | #N/A | 1 | 1 | 9 | False
2018-10-05 00:00:00 | Central | Hermann | Sigal | Home Theater | 28 | 500 |  |  | Television |  | 50 |  | Apr |  |  |  |  |  |  |  | 3 | #N/A | 1 | 1 | #N/A | False
2018-10-22 00:00:00 | East | [NAME] | [NAME] | Cell Phone | 64 | 225 |  |  | Video Games |  | 75 |  | [NAME] |  |  |  |  |  |  |  | 1 | #N/A | 1 | 1 | #N/A | False
2018-11-08 00:00:00 | East | [NAME] | [NAME] | Cell Phone | 15 | 225 |  |  |  |  | 75 |  | Jun |  |  |  |  |  |  |  | 1 | #N/A | 1 | 1 | 11 | False
2018-11-25 00:00:00 | Central | Hermann | [NAME] | Video Games | 96 | 58.5 |  |  |  |  |  |  | Jul |  |  |  |  |  |  |  | 5 | #N/A | #[NAME]! | 1 | 11 | False
2018-12-12 00:00:00 | Central | [NAME] | [NAME] | Television | 67 | 1198 |  |  |  |  |  |  | Ogo |  |  |  |  |  |  |  | 4 | #N/A | 1 | 1 | #N/A | False
2018-12-29 00:00:00 | East | [NAME] | [NAME] | Video Games | 74 | 58.5 |  |  |  |  |  |  | Sep |  |  |  |  |  |  |  | 5 | #N/A | 1 | 1 | #N/A | False
2019-01-15 00:00:00 | Central | Timothy | [NAME] | Home Theater | 46 | 500 |  |  |  |  |  |  | Okt |  |  |  |  |  |  |  | 3 | #N/A | 1 | 2 | 1 | False
2019-02-01 00:00:00 | Central | [NAME] | [NAME] | Home Theater | 87 | 500 |  |  |  |  |  |  | Nov |  |  |  |  |  |  |  | 3 | #N/A | #[NAME]! | 2 | 2 | False
2019-02-18 00:00:00 | East | [NAME] | [NAME] | Home Theater | 4 | 500 |  |  |  |  |  |  | Dis |  |  |  |  |  |  |  | 3 | #N/A | 1 | 2 | 2 | False
2019-03-07 00:00:00 | West | Timothy | Stephen | Home Theater | 7 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | #N/A | 1 | 2 | #N/A | False
2019-03-24 00:00:00 | Central | Hermann | [NAME] | Video Games | 50 | 58.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | #N/A | 1 | 2 | #N/A | False
2019-04-10 00:00:00 | Central | [NAME] | [NAME] | Television | 66 | 1198 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | #N/A | 1 | 2 | 4 | False
2019-04-27 00:00:00 | East | [NAME] | [NAME] | Cell Phone | 96 | 225 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | #N/A | #[NAME]! | 2 | 4 | False
2019-05-14 00:00:00 | Central | Timothy | [NAME] | Television | 53 | 1198 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | #N/A | 1 | 2 | #N/A | False
2019-05-31 00:00:00 | Central | Timothy | [NAME] | Home Theater | 80 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | #N/A | #[NAME]! | 2 | #N/A | False
2019-06-17 00:00:00 | Central | Hermann | [NAME] | Desk | 5 | 125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | #N/A | 1 | 2 | 6 | False
2019-07-04 00:00:00 | East | [NAME] | [NAME] | Video Games | 62 | 58.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | #N/A | 1 | 2 | 7 | False
2019-07-21 00:00:00 | Central | Hermann | Sigal | Video Games | 55 | 58.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | #N/A | 1 | 2 | 7 | False
2019-08-07 00:00:00 | Central | Hermann | [NAME] | Video Games | 42 | 58.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | #N/A | 1 | 2 | #N/A | False
2019-08-24 00:00:00 | West | Timothy | Stephen | Desk | 3 | 125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | #N/A | 1 | 2 | #N/A | False
2019-09-10 00:00:00 | Central | Timothy | [NAME] | Television | 7 | 1198 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | #N/A | 1 | 2 | 9 | False
2019-09-27 00:00:00 | West | Timothy | Stephen | Cell Phone | 76 | 225 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | #N/A | #[NAME]! | 2 | 9 | False
2019-10-14 00:00:00 | West | [NAME] | [NAME] | Home Theater | 57 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | #N/A | 1 | 2 | #N/A | False
2019-10-31 00:00:00 | Central | [NAME] | [NAME] | Television | 14 | 1198 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | #N/A | 1 | 2 | #N/A | False
2019-11-17 00:00:00 | Central | Hermann | [NAME] | Home Theater | 11 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | #N/A | 1 | 2 | 11 | False
2019-12-04 00:00:00 | Central | Hermann | [NAME] | Home Theater | 94 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | #N/A | #[NAME]! | 2 | #N/A | False
2019-12-21 00:00:00 | Central | [NAME] | [NAME] | Home Theater | 28 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | #N/A | 1 | 2 | #N/A | False