Spreadsheet: 136993d1326904072-excel-2007-filter-a-tabel-using-another-dorpdown-list-cell-as-criteria-temp
Sheet: Sheet1

4
ID | Bus_unit | Country | Order_id | Company | Catagory | Product | Quantity | Frieght | Order_Date | Ship_Date | Unit_Price | Stock | Discount
1 | North America | America | 2786 | Company B | Meats | [NAME] | 151 | 943 | 1997-08-21 00:00:00 | 1999-04-20 00:00:00 | 97 | 69 | 0.1
2 | North America | America | 3956 | Company B | Dairy | [NAME] | 499 | 59 | 1999-08-10 00:00:00 | 1999-09-05 00:00:00 | 97 | 4 | 0.1
3 | North America | America | 4183 | Company c | Dairy | [NAME] | 475 | 77 | 1997-09-07 00:00:00 | 1999-03-08 00:00:00 | 96 | 52 | 0.1
4 | North America | America | 4619 | Company B | Beverages | [NAME] | 122 | 752 | 1999-06-28 00:00:00 | 1999-12-25 00:00:00 | 90 | 40 | 0.1
5 | North America | America | 5631 | Company c | Beverages | [NAME] | 139 | 523 | 1997-04-22 00:00:00 | 1998-07-28 00:00:00 | 37 | 58 | 0.1
6 | North America | America | 6672 | Company A | Beverages | Anna | 743 | 102 | 1998-12-31 00:00:00 | 1999-07-23 00:00:00 | 17 | 30 | 0.1
7 | North America | America | 9543 | Company c | Meats | [NAME] | 276 | 797 | 1999-04-03 00:00:00 | 1999-07-05 00:00:00 | 53 | 87 | 0.1
8 | North America | America | 9658 | Company A | Meats | Victoria | 340 | 86 | 1999-04-28 00:00:00 | 1999-09-02 00:00:00 | 34 | 73 | 0.1
9 | North America | America | 9930 | Company A | Dairy | Chloe | 651 | 77 | 1997-09-03 00:00:00 | 1997-11-14 00:00:00 | 51 | 63 | 0.1
10 | South America | Argentina | 222 | Company n | Dairy | [NAME] | 767 | 910 | 1997-02-16 00:00:00 | 1997-03-18 00:00:00 | 79 | 41 | 0.1
11 | South America | Argentina | 2665 | Company m | Dairy | [NAME] | 54 | 894 | 1997-03-13 00:00:00 | 1997-04-12 00:00:00 | 27 | 25 | 0.1
12 | South America | Argentina | 4031 | Company o | Dairy | [NAME] | 280 | 759 | 1998-05-31 00:00:00 | 1998-08-10 00:00:00 | 24 | 6 | 0.1
13 | South America | Argentina | 5773 | Company o | Meats | [NAME] | 716 | 304 | 1999-05-01 00:00:00 | 1999-09-10 00:00:00 | 75 | 69 | 0.1
14 | South America | Argentina | 7497 | Company n | Meats | [NAME] | 875 | 308 | 1997-05-23 00:00:00 | 1997-06-22 00:00:00 | 58 | 6 | 0.1
15 | South America | Argentina | 8922 | Company n | Beverages | Tyler | 324 | 822 | 1997-06-18 00:00:00 | 1997-07-18 00:00:00 | 33 | 51 | 0.1
16 | South America | Argentina | 9005 | Company m | Beverages | [NAME] | 238 | 838 | 1998-02-04 00:00:00 | 1999-08-12 00:00:00 | 80 | 4 | 0.1
17 | South America | Argentina | 9282 | Company m | Meats | Emily | 763 | 849 | 1997-08-03 00:00:00 | 1997-09-02 00:00:00 | 54 | 95 | 0.1
18 | South America | Argentina | 9357 | Company o | Beverages | [NAME] | 612 | 524 | 1998-08-20 00:00:00 | 1999-11-07 00:00:00 | 28 | 60 | 0.1
19 | South America | Brazil | 666 | Company k | Beverages | Emma | 816 | 465 | 1999-04-04 00:00:00 | 1999-06-29 00:00:00 | 77 | 91 | 0.1
20 | South America | Brazil | 1643 | Company l | Meats | [NAME] | 358 | 703 | 1997-06-29 00:00:00 | 1997-07-29 00:00:00 | 43 | 85 | 0.1
21 | South America | Brazil | 2158 | Company j | Meats | [NAME] | 960 | 348 | 1997-01-23 00:00:00 | 1997-02-22 00:00:00 | 82 | 91 | 0.1
22 | South America | Brazil | 2924 | Company j | Beverages | [NAME] | 264 | 670 | 1997-07-10 00:00:00 | 1997-08-09 00:00:00 | 34 | 61 | 0.1
23 | South America | Brazil | 4481 | Company l | Beverages | Christian | 153 | 547 | 1999-05-09 00:00:00 | 1999-12-08 00:00:00 | 16 | 52 | 0.1
24 | South America | Brazil | 5666 | Company j | Dairy | [NAME] | 522 | 381 | 1999-09-13 00:00:00 | 1999-12-29 00:00:00 | 48 | 37 | 0.1
25 | South America | Brazil | 6825 | Company k | Meats | [NAME] | 604 | 1 | 1997-09-24 00:00:00 | 1997-10-24 00:00:00 | 51 | 58 | 0.1
26 | South America | Brazil | 9857 | Company l | Dairy | Nathan | 272 | 567 | 1999-04-05 00:00:00 | 1999-06-03 00:00:00 | 88 | 52 | 0.1
27 | South America | Brazil | 9981 | Company k | Dairy | Justin | 899 | 632 | 1999-12-12 00:00:00 | 1999-12-25 00:00:00 | 82 | 2 | 0.1
28 | North America | Canada | 2898 | Company i | Meats | [NAME] | 971 | 777 | 1998-09-10 00:00:00 | 1999-09-01 00:00:00 | 31 | 25 | 0.1
29 | North America | Canada | 3451 | Company h | Meats | Logan | 240 | 105 | 1998-03-09 00:00:00 | 1999-01-23 00:00:00 | 65 | 28 | 0.1
30 | North America | Canada | 3996 | Company i | Beverages | [NAME] | 447 | 72 | 1998-09-13 00:00:00 | 1999-12-01 00:00:00 | 53 | 34 | 0.1
31 | North America | Canada | 4697 | Company h | Dairy | Alyssa | 756 | 835 | 1998-08-18 00:00:00 | 1999-03-08 00:00:00 | 83 | 13 | 0.1
32 | North America | Canada | 5320 | Company h | Beverages | Grace | 457 | 887 | 1999-08-04 00:00:00 | 1999-11-06 00:00:00 | 72 | 75 | 0.1
33 | North America | Canada | 5646 | Company g | Beverages | [NAME] | 906 | 172 | 1999-08-13 00:00:00 | 1999-08-23 00:00:00 | 21 | 86 | 0.1
34 | North America | Canada | 5958 | Company i | Dairy | [NAME] | 591 | 67 | 1999-06-26 00:00:00 | 1999-12-25 00:00:00 | 73 | 4 | 0.1
35 | North America | Canada | 8053 | Company g | Meats | Caleb | 87 | 462 | 1999-11-20 00:00:00 | 1999-12-03 00:00:00 | 84 | 64 | 0.1
36 | North America | Canada | 9109 | Company g | Dairy | [NAME] | 916 | 92 | 1998-09-22 00:00:00 | 1999-03-08 00:00:00 | 43 | 67 | 0.1
37 | Asia | China | 564 | Company v | Meats | Jordan | 529 | 888 | 1999-07-18 00:00:00 | 1999-09-01 00:00:00 | 27 | 48 | 0.1
38 | Asia | China | 3154 | Company v | Dairy | Elijah | 688 | 195 | 1998-06-18 00:00:00 | 1999-03-26 00:00:00 | 69 | 93 | 0.1
39 | Asia | China | 3390 | Company w | Meats | Cameron | 116 | 492 | 1998-10-04 00:00:00 | 1998-11-07 00:00:00 | 18 | 78 | 0.1
40 | Asia | China | 4216 | Company w | Dairy | [NAME] | 542 | 698 | 1999-10-20 00:00:00 | 1999-10-27 00:00:00 | 53 | 33 | 0.1
41 | Asia | China | 7159 | Company v | Beverages | [NAME] | 744 | 451 | 1997-12-17 00:00:00 | 1998-06-27 00:00:00 | 96 | 54 | 0.1
42 | Asia | China | 8179 | Company x | Beverages | [NAME] | 424 | 55 | 1999-11-20 00:00:00 | 1999-11-20 00:00:00 | 24 | 61 | 0.1
43 | Asia | China | 8295 | Company w | Beverages | [NAME] | 428 | 959 | 1998-05-26 00:00:00 | 1999-04-11 00:00:00 | 31 | 86 | 0.1
44 | Asia | China | 9027 | Company x | Meats | [NAME] | 69 | 251 | 1998-05-27 00:00:00 | 1998-06-04 00:00:00 | 12 | 97 | 0.1
45 | Asia | China | 9322 | Company x | Dairy | [NAME] | 383 | 935 | 1998-04-28 00:00:00 | 1998-06-09 00:00:00 | 60 | 76 | 0.1
46 | Europe | England | 1068 | Company GR | Beverages | [NAME] | 969 | 106 | 1997-12-03 00:00:00 | 1998-02-08 00:00:00 | 44 | 49 | 0.1
47 | Europe | England | 1896 | Company TG | Dairy | Connor | 569 | 53 | 1997-12-20 00:00:00 | 1999-03-19 00:00:00 | 67 | 37 | 0.1
48 | Europe | England | 3908 | Company GR | Meats | [NAME] | 337 | 295 | 1997-03-24 00:00:00 | 1998-03-26 00:00:00 | 53 | 39 | 0.1
49 | Europe | England | 4085 | Company TG | Beverages | [NAME] | 21 | 752 | 1998-03-08 00:00:00 | 1998-11-07 00:00:00 | 84 | 55 | 0.1
50 | Europe | England | 5729 | Company TG | Meats | Ella | 65 | 830 | 1997-04-20 00:00:00 | 1998-10-09 00:00:00 | 29 | 65 | 0.1
51 | Europe | England | 7122 | Company GR | Dairy | Makayla | 638 | 801 | 1999-10-05 00:00:00 | 1999-10-30 00:00:00 | 79 | 93 | 0.1
52 | Europe | England | 7149 | Company ET | Dairy | Faith | 225 | 975 | 1997-10-08 00:00:00 | 1998-12-02 00:00:00 | 44 | 52 | 0.1
53 | Europe | England | 7467 | Company ET | Meats | Kaylee | 176 | 470 | 1999-04-26 00:00:00 | 1999-08-09 00:00:00 | 16 | 80 | 0.1
54 | Europe | England | 8264 | Company ET | Beverages | [NAME] | 963 | 219 | 1997-04-16 00:00:00 | 1999-03-12 00:00:00 | 83 | 37 | 0.1
55 | South America | Equador | 135 | Company p | Meats | [NAME] | 897 | 232 | 1998-07-16 00:00:00 | 1999-12-14 00:00:00 | 44 | 3 | 0.1
56 | South America | Equador | 2018 | Company p | Dairy | Katelyn | 179 | 194 | 1998-10-09 00:00:00 | 1999-09-30 00:00:00 | 41 | 67 | 0.1
57 | South America | Equador | 2766 | Company q | Dairy | [NAME] | 942 | 809 | 1999-05-31 00:00:00 | 1999-11-24 00:00:00 | 21 | 74 | 0.1
58 | South America | Equador | 3517 | Company r | Beverages | Kimberly | 53 | 628 | 1998-06-05 00:00:00 | 1999-09-22 00:00:00 | 33 | 69 | 0.1
59 | South America | Equador | 4258 | Company q | Meats | Trinity | 483 | 338 | 1997-10-10 00:00:00 | 1998-05-19 00:00:00 | 33 | 58 | 0.1
60 | South America | Equador | 5307 | Company r | Dairy | [NAME] | 228 | 79 | 1997-10-12 00:00:00 | 1998-06-21 00:00:00 | 85 | 59 | 0.1
61 | South America | Equador | 7356 | Company q | Beverages | [NAME] | 406 | 456 | 1999-12-05 00:00:00 | 1999-12-09 00:00:00 | 26 | 35 | 0.1
62 | South America | Equador | 8320 | Company r | Meats | [NAME] | 267 | 281 | 1997-09-04 00:00:00 | 1999-07-26 00:00:00 | 28 | 60 | 0.1
63 | South America | Equador | 8949 | Company p | Beverages | [NAME] | 751 | 766 | 1997-06-04 00:00:00 | 1999-06-05 00:00:00 | 63 | 76 | 0.1
64 | Europe | France | 1916 | Company YS | Beverages | Ian | 535 | 930 | 1999-09-17 00:00:00 | 1999-10-18 00:00:00 | 65 | 47 | 0.1
65 | Europe | France | 3347 | Company YS | Meats | [NAME] | 474 | 922 | 1999-05-28 00:00:00 | 1999-05-30 00:00:00 | 30 | 64 | 0.1
66 | Europe | France | 4462 | Company YS | Dairy | Lucas | 189 | 637 | 1999-11-04 00:00:00 | 1999-11-09 00:00:00 | 69 | 14 | 0.1
67 | Europe | France | 6042 | Company JW | Beverages | Adrian | 947 | 874 | 1998-03-18 00:00:00 | 1999-07-04 00:00:00 | 45 | 76 | 0.1
68 | Europe | France | 6943 | Company JW | Meats | [NAME] | 282 | 311 | 1999-04-18 00:00:00 | 1999-05-19 00:00:00 | 16 | 77 | 0.1
69 | Europe | France | 8285 | Company JW | Dairy | Cole | 460 | 522 | 1998-11-21 00:00:00 | 1999-05-29 00:00:00 | 89 | 26 | 0.1
70 | Europe | France | 8892 | Company PO | Beverages | Timothy | 826 | 754 | 1997-04-04 00:00:00 | 1998-08-27 00:00:00 | 55 | 13 | 0.1
71 | Europe | France | 9294 | Company PO | Meats | [NAME] | 823 | 76 | 1999-11-21 00:00:00 | 1999-12-09 00:00:00 | 76 | 37 | 0.1
72 | Europe | France | 9568 | Company PO | Dairy | Jayden | 145 | 258 | 1997-05-15 00:00:00 | 1999-01-03 00:00:00 | 67 | 42 | 0.1
73 | Asia | India | 298 | Company s | Dairy | Aiden | 357 | 912 | 1997-03-10 00:00:00 | 1999-11-13 00:00:00 | 34 | 33 | 0.1
74 | Asia | India | 510 | Company t | Meats | Julian | 898 | 277 | 1999-04-04 00:00:00 | 1999-05-26 00:00:00 | 24 | 4 | 0.1
75 | Asia | India | 3500 | Company t | Dairy | [NAME] | 599 | 771 | 1999-07-25 00:00:00 | 1999-09-24 00:00:00 | 40 | 19 | 0.1
76 | Asia | India | 3527 | Company s | Beverages | [NAME] | 977 | 756 | 1997-06-18 00:00:00 | 1998-02-01 00:00:00 | 74 | 48 | 0.1
77 | Asia | India | 3946 | Company u | Meats | [NAME] | 516 | 684 | 1999-04-25 00:00:00 | 1999-11-16 00:00:00 | 45 | 20 | 0.1
78 | Asia | India | 4915 | Company u | Beverages | Chase | 512 | 965 | 1999-04-15 00:00:00 | 1999-05-20 00:00:00 | 18 | 37 | 0.1
79 | Asia | India | 5958 | Company u | Dairy | [NAME] | 11 | 593 | 1999-08-15 00:00:00 | 1999-10-28 00:00:00 | 23 | 58 | 0.1
80 | Asia | India | 7622 | Company s | Meats | Diego | 301 | 870 | 1999-09-03 00:00:00 | 1999-09-16 00:00:00 | 61 | 26 | 0.1
81 | Asia | India | 9875 | Company t | Beverages | Maya | 982 | 819 | 1997-02-17 00:00:00 | 1997-10-28 00:00:00 | 34 | 14 | 0.1
82 | Asia | Japan | 1464 | Company AC | Meats | Ariana | 941 | 955 | 1998-01-27 00:00:00 | 1999-10-18 00:00:00 | 81 | 45 | 0.1
83 | Asia | Japan | 1504 | Company AC | Dairy | [NAME] | 408 | 799 | 1998-11-26 00:00:00 | 1999-06-03 00:00:00 | 55 | 16 | 0.1
84 | Asia | Japan | 1565 | Company AC | Beverages | Isabel | 390 | 586 | 1998-09-29 00:00:00 | 1999-03-06 00:00:00 | 99 | 50 | 0.1
85 | Asia | Japan | 4368 | Company y | Dairy | Sofia | 825 | 698 | 1998-10-22 00:00:00 | 1998-10-25 00:00:00 | 55 | 40 | 0.1
86 | Asia | Japan | 4950 | Company y | Beverages | [NAME] | 548 | 626 | 1999-01-02 00:00:00 | 1999-01-23 00:00:00 | 33 | 20 | 0.1
87 | Asia | Japan | 6937 | Company z | Dairy | Bailey | 968 | 139 | 1998-03-11 00:00:00 | 1999-11-05 00:00:00 | 85 | 90 | 0.1
88 | Asia | Japan | 9166 | Company z | Meats | Miguel | 10 | 72 | 1997-04-17 00:00:00 | 1997-09-22 00:00:00 | 39 | 26 | 0.1
89 | Asia | Japan | 9356 | Company z | Beverages | Avery | 976 | 370 | 1997-11-13 00:00:00 | 1999-04-20 00:00:00 | 22 | 83 | 0.1
90 | Asia | Japan | 9908 | Company y | Meats | [NAME] | 912 | 642 | 1998-02-25 00:00:00 | 1999-10-01 00:00:00 | 19 | 18 | 0.1
91 | North America | Mexico | 2295 | Company e | Dairy | [NAME] | 665 | 458 | 1997-08-06 00:00:00 | 1999-03-30 00:00:00 | 80 | 30 | 0.1
92 | North America | Mexico | 2882 | Company d | Dairy | [NAME] | 640 | 366 | 1998-08-29 00:00:00 | 1999-07-22 00:00:00 | 24 | 25 | 0.1
93 | North America | Mexico | 2962 | Company f | Meats | [NAME] | 809 | 326 | 1999-08-08 00:00:00 | 1999-12-06 00:00:00 | 58 | 50 | 0.1
94 | North America | Mexico | 3536 | Company d | Beverages | Alejandro | 958 | 152 | 1997-06-21 00:00:00 | 1999-01-14 00:00:00 | 65 | 74 | 0.1
95 | North America | Mexico | 3649 | Company e | Meats | [NAME] | 885 | 875 | 1997-03-03 00:00:00 | 1998-08-30 00:00:00 | 75 | 42 | 0.1
96 | North America | Mexico | 4089 | Company f | Dairy | Jaden | 904 | 354 | 1999-09-15 00:00:00 | 1999-09-26 00:00:00 | 90 | 83 | 0.1
97 | North America | Mexico | 5539 | Company f | Beverages | [NAME] | 422 | 893 | 1997-02-20 00:00:00 | 1998-12-13 00:00:00 | 83 | 91 | 0.1
98 | North America | Mexico | 9157 | Company e | Beverages | [NAME] | 286 | 461 | 1999-12-15 00:00:00 | 1999-12-15 00:00:00 | 74 | 9 | 0.1
99 | North America | Mexico | 9448 | Company d | Meats | Gabriella | 283 | 172 | 1997-12-20 00:00:00 | 1999-10-14 00:00:00 | 87 | 50 | 0.1
100 | Europe | Spain | 1934 | Company JU | Dairy | Lillian | 989 | 562 | 1999-03-22 00:00:00 | 1999-10-24 00:00:00 | 67 | 99 | 0.1
101 | Europe | Spain | 2270 | Company MH | Beverages | Riley | 168 | 696 | 1999-12-02 00:00:00 | 1999-12-12 00:00:00 | 35 | 42 | 0.1
102 | Europe | Spain | 2794 | Company MH | Dairy | Sierra | 483 | 483 | 1997-04-30 00:00:00 | 1998-07-10 00:00:00 | 28 | 92 | 0.1
103 | Europe | Spain | 2997 | Company MH | Meats | Danielle | 256 | 828 | 1998-05-12 00:00:00 | 1999-02-25 00:00:00 | 33 | 22 | 0.1
104 | Europe | Spain | 3093 | Company KL | Dairy | Leah | 70 | 43 | 1997-03-31 00:00:00 | 1999-01-05 00:00:00 | 43 | 0 | 0.1
105 | Europe | Spain | 3141 | Company JU | Meats | [NAME] | 584 | 689 | 1999-09-13 00:00:00 | 1999-10-27 00:00:00 | 16 | 90 | 0.1
106 | Europe | Spain | 3649 | Company JU | Beverages | Autumn | 92 | 63 | 1998-04-30 00:00:00 | 1999-01-27 00:00:00 | 53 | 20 | 0.1
107 | Europe | Spain | 7802 | Company KL | Meats | Erin | 873 | 57 | 1999-05-27 00:00:00 | 1999-12-22 00:00:00 | 76 | 34 | 0.1
108 | Europe | Spain | 8666 | Company KL | Beverages | [NAME] | 358 | 557 | 1998-01-22 00:00:00 | 1999-10-04 00:00:00 | 27 | 40 | 0.1