墨菲莫非練習－篩選功能 & FILTER 函數

	A	B	C	D	E	F	G	H	I	J
1	Customer Name	Country	Region	Market	Category	Product Name	Sales	Quantity	Shipping Cost	Order Priority
2	Aaron Bergman	United States	Central US	USCA	Technology	Samsung Convoy 3	$221	2	40.77	High
3	Justin Ritter	Australia	Oceania	Asia Pacific	Furniture	Novimex Executive Leather Armchair, Black	$3,709	9	923.63	Critical
4	Craig Reiter	Australia	Oceania	Asia Pacific	Technology	Nokia Smart Phone, with Caller ID	$5,175	9	915.49	Medium
5	Katherine Murray	Germany	Western Europe	Europe	Technology	Motorola Smart Phone, Cordless	$2,893	5	910.16	Medium
6	Rick Hansen	Senegal	Western Africa	Africa	Technology	Sharp Wireless Fax, High-Speed	$2,833	8	903.04	Critical
7	Jim Mitchum	Australia	Oceania	Asia Pacific	Technology	Samsung Smart Phone, with Caller ID	$2,863	5	897.35	Critical
8	Toby Swindell	New Zealand	Oceania	Asia Pacific	Furniture	Novimex Executive Leather Armchair, Adjustable	$1,822	4	894.77	Critical
9	Mick Brown	New Zealand	Oceania	Asia Pacific	Furniture	Chromcraft Conference Table, Fully Assembled	$5,245	6	878.38	High
10	Aaron Bergman	United States	Central US	USCA	Furniture	Sauder Facets Collection Library, Sky Alder Finish	$342	2	25.27	High
11	Aaron Bergman	United States	Western US	USCA	Furniture	Global Push Button Manager's Chair, Indigo	$49	1	11.13	High
12	Aaron Bergman	United States	Western US	USCA	Office Supplies	Newell 330	$18	3	4.29	High
13	Anthony Jacobs	Afghanistan	Southern Asia	Asia Pacific	Furniture	Bevis Conference Table, Fully Assembled	$4,626	5	835.57	High
14	Magdelene Morse	Saudi Arabia	Western Asia	Asia Pacific	Technology	Cisco Smart Phone, with Caller ID	$2,617	4	832.41	Critical
15	Vicky Freymann	Brazil	South America	LATAM	Furniture	Harbour Creations Executive Leather Armchair, Adjustable	$2,222	7	810.25	Critical
16	Peter Fuller	China	Eastern Asia	Asia Pacific	Office Supplies	KitchenAid Microwave, White	$3,702	12	804.54	Critical
17	Ben Peterman	France	Western Europe	Europe	Office Supplies	Breville Refrigerator, Red	$1,870	4	801.66	Critical
18	Aaron Bergman	United States	Central US	USCA	Office Supplies	Akro Stacking Bins	$13	2	1.97	Low
19	Patrick Jones	Italy	Southern Europe	Europe	Office Supplies	Hoover Stove, Red	$7,959	14	778.32	Low
20	Jim Sink	Australia	Oceania	Asia Pacific	Technology	Brother Fax Machine, High-Speed	$2,566	9	766.93	Critical
21	Ritsa Hightower	Tanzania	Eastern Africa	Africa	Office Supplies	KitchenAid Stove, White	$3,410	6	763.38	High
22	Ann Blume	Poland	Eastern Europe	Europe	Furniture	Hon Computer Table, with Bottom Storage	$1,978	4	759.47	Critical
23	Aaron Bergman	United States	Western US	USCA	Office Supplies	Carina 42"Hx23 3/4"W Media Storage Unit	$243	3	1.28	High
24	Jason Klamczynski	China	Eastern Asia	Asia Pacific	Furniture	SAFCO Executive Leather Armchair, Black	$2,754	6	752.47	Critical
25	Laurel Beltran	United Kingdom	Northern Europe	Europe	Office Supplies	KitchenAid Refrigerator, Black	$5,274	10	730.91	High
26	Naresj Patel	Mexico	Central America	LATAM	Technology	Motorola Smart Phone, Full Size	$1,714	4	728.968	Critical
27	Valerie Dominguez	El Salvador	Central America	LATAM	Furniture	Hon Computer Table, Fully Assembled	$2,107	8	728.389	Critical
28	Phillip Breyer	Taiwan	Eastern Asia	Asia Pacific	Furniture	Lesro Conference Table, with Bottom Storage	$1,715	2	725.57	Critical
29	Eugene Barchas	Germany	Western Europe	Europe	Office Supplies	Hoover Stove, Red	$3,070	6	725.34	Critical
30	Aaron Hawkins	United States	Eastern US	USCA	Office Supplies	Staples	$248	8	55.2	Critical
31	Benjamin Patterson	India	Southern Asia	Asia Pacific	Furniture	Office Star Executive Leather Armchair, Red	$1,879	4	704.08	Critical
32	Rick Reed	Dominican Republic	Caribbean	LATAM	Technology	Samsung Smart Phone, VoIP	$1,697	5	704.056	Critical
33	Bill Shonely	France	Western Europe	Europe	Technology	Okidata Inkjet, Wireless	$2,403	9	699.55	Critical
34	Aaron Hawkins	United States	Western US	USCA	Technology	Geemarc AmpliPOWER60	$668	9	45.74	Medium
35	Dave Poirier	Australia	Oceania	Asia Pacific	Office Supplies	Breville Stove, Red	$2,527	5	689.8	Critical
36	Aaron Hawkins	United States	Western US	USCA	Office Supplies	Fellowes Super Stor/Drawer Files	$323	2	26.7	Medium
37	Aaron Hawkins	Democratic Republic of the Congo	Central Africa	Africa	Technology	Apple Smart Phone, Full Size	$3,817	6	678.15	High
38	Aaron Hawkins	United States	Western US	USCA	Furniture	Iceberg Nesting Folding Chair, 19w x 6d x 43h	$279	6	11.69	Medium
39	Aaron Hawkins	United States	Eastern US	USCA	Technology	Verbatim 25 GB 6x Blu-ray Single Layer Recordable Disc, 10/Pack	$35	3	8.22	High
40	Patrick O'Donnell	United Kingdom	Northern Europe	Europe	Technology	Brother Fax Machine, Laser	$4,141	13	668.96	High
41	Dan Lawera	Australia	Oceania	Asia Pacific	Technology	Nokia Smart Phone, with Caller ID	$2,875	5	665.27	Medium
42	Joy Bell-	Indonesia	Southeastern Asia	Asia Pacific	Technology	Motorola Smart Phone, Full Size	$3,201	6	660.87	High
43	Barry Franz	India	Southern Asia	Asia Pacific	Technology	Motorola Smart Phone, with Caller ID	$4,519	7	658.69	High
44	Vivek Grady	India	Southern Asia	Asia Pacific	Furniture	Sauder Classic Bookcase, Traditional	$5,668	13	658.35	Medium
45	Greg Tran	United Kingdom	Northern Europe	Europe	Technology	Motorola Smart Phone, Cordless	$5,785	9	656.73	High
46	Zuschuss Carroll	Germany	Western Europe	Europe	Office Supplies	Cuisinart Stove, Silver	$3,019	7	655.91	Critical
47	Aaron Hawkins	United States	Southern US	USCA	Furniture	Eldon Image Series Desk Accessories, Ebony	$86	7	5.73	Medium
48	Ellis Ballard	France	Western Europe	Europe	Furniture	Office Star Executive Leather Armchair, Adjustable	$2,093	5	652.98	Critical
49	Arthur Prichep	China	Eastern Asia	Asia Pacific	Furniture	Novimex Executive Leather Armchair, Red	$2,761	6	644.75	High
50	Scott Williamson	India	Southern Asia	Asia Pacific	Technology	Konica Inkjet, White	$2,174	7	637.86	Critical
51	John Huston	Uruguay	South America	LATAM	Furniture	Harbour Creations Executive Leather Armchair, Black	$3,473	11	634.529	High
52	Aaron Hawkins	United States	Western US	USCA	Office Supplies	GBC VeloBind Cover Sets	$49	4	2.84	High
53	Trudy Glocke	Iran	Southern Asia	Asia Pacific	Technology	Canon Copy Machine, Color	$2,109	8	630.97	Critical
54	Aaron Hawkins	United States	Eastern US	USCA	Office Supplies	Avery 51	$19	3	1.3	High
55	Phillip Breyer	Taiwan	Eastern Asia	Asia Pacific	Furniture	Safco Classic Bookcase, Pine	$2,198	5	627.27	Critical
56	Deirdre Greer	Mozambique	Eastern Africa	Africa	Technology	Motorola Smart Phone, with Caller ID	$2,582	4	627.17	High
57	Sheri Gordon	India	Southern Asia	Asia Pacific	Technology	Hewlett Wireless Fax, Color	$1,527	4	625.77	Critical
58	Aaron Hawkins	United States	Eastern US	USCA	Office Supplies	ACCOHIDE 3-Ring Binder, Blue, 1"	$10	3	1.2	Critical
59	Guy Phonely	India	Southern Asia	Asia Pacific	Furniture	Chromcraft Conference Table, with Bottom Storage	$1,745	2	616.27	Critical
60	Mitch Webber	Australia	Oceania	Asia Pacific	Office Supplies	Breville Refrigerator, White	$4,192	9	614.34	High
61	Aaron Hawkins	United States	Western US	USCA	Office Supplies	EcoTones Memo Sheets	$8	2	1.15	Medium
62	Chuck Sachs	Bangladesh	Southern Asia	Asia Pacific	Furniture	Safco Classic Bookcase, Metal	$3,063	7	609.24	High
63	Aaron Hawkins	United States	Eastern US	USCA	Office Supplies	Avery Fluorescent Highlighter Four-Color Set	$19	7	1.13	Medium
64	Michael Stewart	Germany	Western Europe	Europe	Technology	Samsung Smart Phone, Cordless	$4,473	7	604.4	Medium
65	Kimberly Carter	Germany	Western Europe	Europe	Technology	Apple Audio Dock, with Caller ID	$1,502	9	600.21	Critical
66	Denny Blanton	China	Eastern Asia	Asia Pacific	Furniture	SAFCO Executive Leather Armchair, Black	$5,049	11	595.5	High
67	Aaron Smayling	United States	Southern US	USCA	Technology	Cisco CP-7937G Unified IP Conference Station Phone	$696	2	160.19	High
68	Dave Kipp	Spain	Southern Europe	Europe	Furniture	Safco Classic Bookcase, Metal	$2,188	5	593.91	High
69	Cari Sayre	India	Southern Asia	Asia Pacific	Furniture	Chromcraft Wood Table, Rectangular	$1,920	4	592.77	Critical
70	Evan Minnotte	Mexico	Central America	LATAM	Technology	Samsung Smart Phone, Cordless	$1,704	4	592.726	Critical
71	Dianna Wilson	Ukraine	Eastern Europe	Europe	Furniture	Chromcraft Round Table, Rectangular	$1,859	4	590.56	Critical
72	Alan Schoenberger	China	Eastern Asia	Asia Pacific	Furniture	Harbour Creations Executive Leather Armchair, Adjustable	$3,298	7	589.36	High
73	Shui Tom	Nicaragua	Central America	LATAM	Office Supplies	Hamilton Beach Microwave, Black	$2,443	13	589.293	Medium
74	Barry Weirich	Democratic Republic of the Congo	Central Africa	Africa	Furniture	Harbour Creations Executive Leather Armchair, Adjustable	$3,809	8	588.13	High
75	Laura Armstrong	Indonesia	Southeastern Asia	Asia Pacific	Furniture	Bevis Conference Table, with Bottom Storage	$3,427	7	586.57	High
76	Aimee Bixby	United Kingdom	Northern Europe	Europe	Technology	Nokia Smart Phone, Full Size	$3,442	6	585.25	High
77	John Huston	Australia	Oceania	Asia Pacific	Technology	Apple Smart Phone, Cordless	$2,863	5	581.88	Critical
78	Aaron Smayling	United States	Central US	USCA	Technology	Bady BDG101FRU Card Printer	$1,440	3	103.62	Medium
79	Bobby Elias	Germany	Western Europe	Europe	Technology	Brother Ink, Color	$1,487	10	580.98	Critical
80	Sam Zeldin	China	Eastern Asia	Asia Pacific	Technology	Sharp Wireless Fax, Digital	$3,200	9	576.71	Medium
81	Raymond Messe	India	Southern Asia	Asia Pacific	Furniture	Novimex Executive Leather Armchair, Red	$2,301	5	573.27	Critical
82	Harry Greene	France	Western Europe	Europe	Furniture	Hon Executive Leather Armchair, Adjustable	$5,729	14	572.95	High
83	Dave Poirier	Morocco	North Africa	Africa	Technology	Canon Wireless Fax, Laser	$5,301	14	568.45	Medium
84	Aaron Smayling	United States	Western US	USCA	Furniture	Atlantic Metals Mobile 4-Shelf Bookcases, Custom Colors	$478	2	43.01	Critical
85	Aaron Smayling	United States	Western US	USCA	Office Supplies	Avery Trapezoid Extra Heavy Duty 4" Binders	$88	7	23.88	High
86	Joy Bell-	Germany	Western Europe	Europe	Technology	Motorola Smart Phone, Full Size	$3,220	5	564.25	Low
87	Anne McFarland	Indonesia	Southeastern Asia	Asia Pacific	Office Supplies	Hamilton Beach Refrigerator, Black	$2,488	6	562.14	Critical
88	Alejandro Ballentine	Morocco	North Africa	Africa	Office Supplies	Hoover Stove, White	$2,266	4	556.45	Medium
89	Rachel Payne	Australia	Oceania	Asia Pacific	Technology	Brother Wireless Fax, Laser	$3,068	9	555.77	High
90	Berenike Kampe	Bangladesh	Southern Asia	Asia Pacific	Furniture	Ikea Classic Bookcase, Mobile	$3,728	9	553.31	Medium
91	Janet Martin	China	Eastern Asia	Asia Pacific	Technology	Canon Copy Machine, Color	$1,581	6	550.74	High
92	Guy Phonely	India	Southern Asia	Asia Pacific	Technology	Nokia Smart Phone, with Caller ID	$1,917	3	548.4	Critical
93	Aaron Smayling	United States	Western US	USCA	Furniture	Lesro Sheffield Collection Coffee Table, End Table, Center Table, Corner Table	$171	3	12.65	Medium
94	Nick Zandusky	France	Western Europe	Europe	Office Supplies	Hamilton Beach Stove, White	$2,432	5	546.9	Critical
95	Aaron Smayling	United States	Southern US	USCA	Office Supplies	Avery Recycled Flexi-View Covers for Binding Systems	$29	6	5.35	High
96	Steve Chapman	Philippines	Southeastern Asia	Asia Pacific	Furniture	Office Star Executive Leather Armchair, Red	$2,466	7	546.49	High
97	Noah Childs	Australia	Oceania	Asia Pacific	Furniture	Bevis Conference Table, with Bottom Storage	$1,848	2	545.89	High
98	Natalie Fritzler	Austria	Western Europe	Europe	Furniture	Ikea Classic Bookcase, Mobile	$2,900	7	541.59	High
99	Nick Zandusky	Australia	Oceania	Asia Pacific	Furniture	SAFCO Executive Leather Armchair, Black	$2,892	7	541.57	Medium
100	Paul MacIntyre	France	Western Europe	Europe	Technology	Panasonic Printer, Red	$2,017	9	540.77	Critical