| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1st Task -- | Remove duplicate data | ||||||||||||||||||||||||
2 | 2nd Task-- | Sort by Region | ||||||||||||||||||||||||
3 | 3rd Task-- | Remove errors | ||||||||||||||||||||||||
4 | 4th Task-- | Highlight the Higest Sales | ||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||
6 | Date | Day | Order ID | Customer | Region | Sales Rep | Postal Code | Product | Price | Qty | Total | |||||||||||||||
7 | 3/14/2016 | Monday | CA-2017-120999 | Steve Nguyen | NorthEast | Steven | 77041 | FZS Item | 359.26 | 33.00 | 11855.70 | |||||||||||||||
8 | 12/7/2015 | Monday | US-2017-119662 | Duane Noonan | MidWest | Chin | 94122 | CSJ Item | 731.82 | 37.00 | 27077.31 | |||||||||||||||
9 | 5/16/2016 | Monday | CA-2016-158568 | Roger Barcio | NorthEast | Chin | 97206 | KEI Item | 3491.87 | 39.00 | 136182.97 | |||||||||||||||
10 | 10/5/2015 | Monday | CA-2015-129476 | Gary Zandusky | West | Jon | 55901 | XOU Item | 5848.91 | 36.00 | 210560.85 | |||||||||||||||
11 | 2/16/2015 | Monday | US-2014-152030 | Dave Kipp | NorthEast | Luke | 98103 | MQW Item | 92.28 | 26.00 | 2399.18 | |||||||||||||||
12 | 4/4/2016 | Monday | US-2014-134614 | Greg Guthrie | West | Rhonda | 37620 | PEN Item | 1701.14 | 26.00 | 44229.74 | |||||||||||||||
13 | 5/2/2016 | Monday | CA-2015-124919 | Helen Andreada | NorthEast | Steven | 91104 | III Item | 5843.45 | 20.00 | 116869.02 | |||||||||||||||
14 | 3/30/2015 | Monday | CA-2014-118962 | Eric Murdock | SouthEast | Troung | 19134 | ZMY Item | 0.00 | 45.00 | 0.00 | |||||||||||||||
15 | 2/15/2016 | Monday | CA-2017-105074 | Mark Packer | North | Chin | 10035 | XNB Item | 3464.64 | 20.00 | 69292.74 | |||||||||||||||
16 | 8/31/2015 | Monday | CA-2017-135860 | Maria Bertelson | North | Rhonda | 44312 | OAP Item | 2666.14 | 48.00 | 127974.65 | |||||||||||||||
17 | 11/9/2015 | Monday | CA-2015-101007 | Bruce Stewart | West | Chin | 80219 | LOP Item | 0.00 | 25.00 | 0.00 | |||||||||||||||
18 | 3/21/2016 | Monday | CA-2016-130162 | Heather Kirkland | West | Jon | 37064 | EWM Item | 1805.73 | 37.00 | 66811.99 | |||||||||||||||
19 | 12/14/2015 | Monday | US-2015-145436 | Michael Stewart | SouthEast | Sheliadawn | 75220 | CRF Item | 5399.02 | 38.00 | 205162.65 | |||||||||||||||
20 | 5/30/2016 | Monday | CA-2014-131926 | David Smith | West | Jeri | 48227 | KVL Item | 627.28 | 31.00 | 19445.74 | |||||||||||||||
21 | 6/1/2015 | Monday | CA-2015-144253 | Jas O'Carroll | NorthEast | Troung | 90004 | BJI Item | 105.40 | 50.00 | 5270.10 | |||||||||||||||
22 | 4/20/2015 | Monday | CA-2016-142902 | Kelly Lampkin | SouthEast | Steven | 80906 | UPA Item | 7054.78 | 40.00 | 282191.01 | |||||||||||||||
23 | 12/1/2014 | Monday | CA-2014-122336 | Frank Atkinson | North | Jeri | 90805 | KGM Item | 4699.11 | 28.00 | 131575.14 | |||||||||||||||
24 | 1/12/2015 | Monday | US-2015-120712 | Grace Kelly | NorthEast | Sheliadawn | 92345 | HMW Item | 5011.17 | 43.00 | 215480.38 | |||||||||||||||
25 | 8/3/2015 | Monday | CA-2016-129714 | John Lucas | West | Rhonda | 19134 | FSD Item | 3806.21 | 28.00 | 106573.75 | |||||||||||||||
26 | 7/21/2014 | Monday | CA-2014-115973 | Guy Thornton | West | Jeri | 78550 | UYR Item | 3188.92 | 23.00 | 73345.13 | |||||||||||||||
27 | 3/23/2015 | Monday | CA-2017-102946 | Russell Applegate | SouthEast | Sheliadawn | 77095 | NEE Item | 4351.80 | 33.00 | 143609.55 | |||||||||||||||
28 | 8/25/2014 | Monday | CA-2017-117933 | Mike Vittorini | MidWest | Steven | 10009 | QPM Item | 2645.06 | 36.00 | 95222.30 | |||||||||||||||
29 | 3/7/2016 | Monday | CA-2017-142636 | Bart Pistole | NorthEast | Troung | 61604 | CNH Item | 0.00 | 38.00 | 0.00 | |||||||||||||||
30 | 10/6/2014 | Monday | CA-2017-122105 | Victor Preis | NorthEast | Jon | 89115 | YIP Item | 4494.45 | 24.00 | 107866.73 | |||||||||||||||
31 | 6/22/2015 | Monday | CA-2016-127369 | Philip Brown | SouthEast | Jeri | 90004 | JHF Item | 15.06 | 20.00 | 301.24 | |||||||||||||||
32 | 6/23/2014 | Monday | CA-2017-157252 | Michael Paige | North | Steven | 1841 | XIM Item | 2510.19 | 43.00 | 107938.33 | |||||||||||||||
33 | 8/18/2014 | Monday | CA-2017-154214 | Harold Pawlan | MidWest | Jon | 76106 | WWB Item | 1936.76 | 24.00 | 46482.30 | |||||||||||||||
34 | 1/11/2016 | Monday | CA-2016-100790 | Sanjit Chand | NorthEast | Jeri | 94521 | POX Item | 0.00 | 22.00 | 0.00 | |||||||||||||||
35 | 1/26/2015 | Monday | US-2016-105578 | John Grady | NorthEast | Jeri | 10024 | EQL Item | 1385.90 | 26.00 | 36033.31 | |||||||||||||||
36 | 7/27/2015 | Monday | CA-2017-163405 | Carl Weiss | MidWest | Sheliadawn | 77340 | TBQ Item | 3970.29 | 47.00 | 186603.78 | |||||||||||||||
37 | 8/10/2015 | Monday | US-2016-139486 | Rose O'Brian | NorthEast | Chin | 38109 | WLY Item | 819.24 | 39.00 | 31950.24 | |||||||||||||||
38 | 3/16/2015 | Monday | CA-2017-113558 | Sanjit Chand | North | Steven | 92627 | TYZ Item | 2542.44 | 43.00 | 109324.90 | |||||||||||||||
39 | 5/4/2015 | Monday | CA-2015-130736 | Erin Smith | NorthEast | Rhonda | 85705 | SWQ Item | 4295.72 | 48.00 | 206194.43 | |||||||||||||||
40 | 11/2/2015 | Monday | CA-2016-127250 | Dean Katz | West | Sheliadawn | 60653 | IYT Item | 1390.59 | 47.00 | 65357.64 | |||||||||||||||
41 | 5/18/2015 | Monday | CA-2014-131450 | Cynthia Arntzen | SouthEast | Jeri | 33614 | OGB Item | 450.47 | 35.00 | 15766.48 | |||||||||||||||
42 | 3/1/2016 | Tuesday | CA-2016-152254 | Claire Gute | NorthEast | Rhonda | 42420 | MKO Item | 4545.00 | 44.00 | 199980.00 | |||||||||||||||
43 | 2/3/2015 | Tuesday | US-2015-118983 | Harold Pawlan | North | Steven | 76106 | HPF Item | 87.25 | 49.00 | 4275.05 | |||||||||||||||
44 | 5/3/2016 | Tuesday | US-2017-156909 | Sandra Flanagan | NorthEast | Jeri | 19140 | ICX Item | 0.00 | 33.00 | 0.00 | |||||||||||||||
45 | 12/2/2014 | Tuesday | CA-2016-121755 | Eric Hoffmann | NorthEast | Rhonda | 90049 | MHX Item | 2075.59 | 30.00 | 62267.70 | |||||||||||||||
46 | 12/29/2015 | Tuesday | CA-2016-117590 | Matt Abelman | SouthEast | Troung | 77095 | EIS Item | 0.00 | 39.00 | 0.00 | |||||||||||||||
47 | 12/16/2014 | Tuesday | CA-2015-117415 | Gene Hale | North | Chin | 75080 | WKL Item | 8597.46 | 44.00 | 378288.06 | |||||||||||||||
48 | 10/13/2015 | Tuesday | CA-2016-118255 | Erin Smith | MidWest | Chin | 32935 | BPZ Item | 3148.53 | 22.00 | 69267.56 | |||||||||||||||
49 | 12/23/2014 | Tuesday | CA-2014-146703 | Odella Nelson | NorthEast | Steven | 55122 | DKM Item | 5385.81 | 49.00 | 263904.69 | |||||||||||||||
50 | 8/4/2015 | Tuesday | CA-2015-115742 | Lena Hernandez | SouthEast | Rhonda | 19901 | XMY Item | 2395.25 | 44.00 | 105390.86 | |||||||||||||||
51 | 9/15/2015 | Tuesday | CA-2016-119823 | Paul Stevenson | SouthEast | Jon | 60610 | IQG Item | 116.92 | 48.00 | 5612.12 | |||||||||||||||
52 | 7/21/2015 | Tuesday | US-2015-134026 | Henry MacAllister | NorthEast | Luke | 10009 | ZMF Item | 3251.36 | 26.00 | 84535.43 | |||||||||||||||
53 | 4/7/2015 | Tuesday | US-2014-147606 | Joel Eaton | SouthEast | Troung | 38109 | UBW Item | 1186.64 | 50.00 | 59332.05 | |||||||||||||||
54 | 4/21/2015 | Tuesday | CA-2016-127208 | Ken Brennan | NorthEast | Sheliadawn | 77041 | QHO Item | 1641.61 | 46.00 | 75514.23 | |||||||||||||||
55 | 2/17/2015 | Tuesday | CA-2017-157833 | Karl Braun | NorthEast | Rhonda | 55407 | NZX Item | 725.55 | 48.00 | 34826.52 | |||||||||||||||
56 | 10/7/2014 | Tuesday | US-2015-156867 | Katherine Ducich | SouthEast | Steven | 94122 | DRK Item | 2266.80 | 20.00 | 45335.93 | |||||||||||||||
57 | 3/8/2016 | Tuesday | US-2015-136476 | Clay Ludtke | MidWest | Chin | 50322 | FKD Item | 2924.24 | 39.00 | 114045.22 | |||||||||||||||
58 | 6/17/2014 | Tuesday | CA-2016-103730 | Ryan Crowe | NorthEast | Rhonda | 43229 | DIO Item | 4246.57 | 43.00 | 182602.67 | |||||||||||||||
59 | 9/1/2015 | Tuesday | CA-2016-114489 | Sally Hughsby | West | Chin | 94122 | HAI Item | 2640.13 | 28.00 | 73923.70 | |||||||||||||||
60 | 3/17/2015 | Tuesday | CA-2014-123260 | Joel Eaton | NorthEast | Steven | 43055 | WPE Item | 5394.15 | 43.00 | 231948.24 | |||||||||||||||
61 | 4/5/2016 | Tuesday | CA-2016-157000 | Jim Kriz | MidWest | Jon | 10009 | NBK Item | 0 | 21.00 | 0.00 | |||||||||||||||
62 | 12/9/2014 | Tuesday | CA-2015-146262 | Logan Currie | SouthEast | Chin | 75220 | UXD Item | 2647.43 | 30.00 | 79423.00 | |||||||||||||||
63 | 11/17/2015 | Tuesday | US-2014-156216 | Victoria Wilson | NorthEast | Jeri | 44256 | NCN Item | 1522.32 | 49.00 | 74593.61 | |||||||||||||||
64 | 4/26/2016 | Tuesday | CA-2017-132976 | Alan Hwang | NorthEast | Luke | 94513 | XZF Item | 1950.30 | 40.00 | 78012.18 | |||||||||||||||
65 | 5/10/2016 | Tuesday | US-2015-161991 | Paul Gonzalez | NorthEast | Sheliadawn | 7960 | GLG Item | 3446.42 | 40.00 | 137856.97 | |||||||||||||||
66 | 9/9/2014 | Tuesday | CA-2014-164973 | Ken Brennan | SouthEast | Jon | 48180 | KHA Item | 1191.24 | 43.00 | 51223.52 | |||||||||||||||
67 | 5/31/2016 | Tuesday | US-2017-134481 | Heather Kirkland | West | Troung | 28205 | YHA Item | 114.45 | 29.00 | 3319.14 | |||||||||||||||
68 | 9/23/2014 | Tuesday | US-2015-168935 | Michael Kennedy | North | Sheliadawn | 6040 | BPJ Item | 730.54 | 46.00 | 33604.75 | |||||||||||||||
69 | 10/14/2014 | Tuesday | CA-2017-101798 | Arthur Gainer | NorthEast | Jon | 85705 | EZU Item | 607.65 | 37.00 | 22483.00 | |||||||||||||||
70 | 9/8/2015 | Tuesday | CA-2014-155208 | Nathan Gelder | North | Jeri | 45231 | ILH Item | 4854.34 | 23.00 | 111649.74 | |||||||||||||||
71 | 1/5/2016 | Tuesday | CA-2017-110478 | Anna Gayman | SouthEast | Luke | 77036 | AIM Item | 3641.63 | 27.00 | 98324.13 | |||||||||||||||
72 | 8/18/2015 | Tuesday | CA-2017-152275 | Kimberly Carter | West | Chin | 98105 | KYW Item | 3119.56 | 36.00 | 112304.15 | |||||||||||||||
73 | 5/17/2016 | Tuesday | US-2016-123750 | Caroline Jumper | MidWest | Rhonda | 92646 | ITT Item | 2317.30 | 49.00 | 113547.90 | |||||||||||||||
74 | 9/2/2014 | Tuesday | US-2015-101399 | Cynthia Voltz | NorthEast | Luke | 10024 | LVD Item | 241.66 | 31.00 | 7491.38 | |||||||||||||||
75 | 9/30/2014 | Tuesday | CA-2014-144666 | Raymond Buch | NorthEast | Troung | 13021 | GAK Item | 345.52 | 50.00 | 17275.79 | |||||||||||||||
76 | 3/31/2015 | Tuesday | CA-2014-154627 | Joni Sundaresam | SouthEast | Steven | 60068 | ACF Item | 3479.96 | 26.00 | 90478.96 | |||||||||||||||
77 | 7/8/2014 | Tuesday | CA-2014-133753 | David Smith | MidWest | Luke | 79109 | XVI Item | 4250.16 | 46.00 | 195507.57 | |||||||||||||||
78 | 6/7/2016 | Tuesday | CA-2017-135307 | Michelle Tran | West | Sheliadawn | 90045 | JGS Item | 3107.28 | 37.00 | 114969.32 | |||||||||||||||
79 | 1/19/2016 | Tuesday | CA-2015-134894 | Dean Braden | MidWest | Chin | 77041 | VYV Item | 3545.62 | 41.00 | 145370.54 | |||||||||||||||
80 | 7/29/2014 | Tuesday | CA-2017-162929 | Mike Gockenbach | SouthEast | Troung | 19134 | GPQ Item | 6549.87 | 40.00 | 261994.85 | |||||||||||||||
81 | 10/27/2015 | Tuesday | CA-2016-113243 | Mark Packer | North | Sheliadawn | 10009 | HQT Item | 4756.44 | 29.00 | 137936.86 | |||||||||||||||
82 | 5/19/2015 | Tuesday | CA-2014-149958 | Frank Preis | NorthEast | Chin | 90008 | LEO Item | 3132.68 | 42.00 | 131572.70 | |||||||||||||||
83 | 7/22/2014 | Tuesday | US-2014-105767 | Ellis Ballard | NorthEast | Sheliadawn | 98105 | JFF Item | 0 | 40.00 | 0.00 | |||||||||||||||
84 | 5/19/2015 | Tuesday | CA-2016-121223 | Sarah Foster | NorthEast | Troung | 98270 | WCX Item | 1182.05 | 32.00 | 37825.48 | |||||||||||||||
85 | 7/22/2014 | Tuesday | CA-2017-138611 | Trudy Glocke | NorthEast | Jon | 90805 | UZP Item | 526.08 | 21.00 | 11047.67 | |||||||||||||||
86 | 5/19/2015 | Tuesday | US-2014-111171 | Charles Crestani | MidWest | Steven | 90004 | WIP Item | 3075.82 | 35.00 | 107653.70 | |||||||||||||||
87 | 7/22/2014 | Tuesday | CA-2015-138009 | Dianna Vittorini | NorthEast | Jon | 80219 | QJV Item | 1835.90 | 20.00 | 36717.94 | |||||||||||||||
88 | 5/19/2015 | Tuesday | CA-2017-153787 | Zuschuss Carroll | West | Troung | 97301 | YGD Item | 2226.95 | 38.00 | 84623.93 | |||||||||||||||
89 | 7/22/2014 | Tuesday | CA-2017-133431 | Melanie Seite | MidWest | Sheliadawn | 78041 | LCU Item | 3976.60 | 35.00 | 139180.89 | |||||||||||||||
90 | 5/19/2015 | Tuesday | CA-2017-144694 | Theone Pippenger | West | Rhonda | 19134 | BUZ Item | 4355.79 | 28.00 | 121962.20 | |||||||||||||||
91 | 7/22/2014 | Tuesday | CA-2015-168004 | Harold Pawlan | MidWest | Rhonda | 76106 | FPF Item | 3381.07 | 44.00 | 148767.29 | |||||||||||||||
92 | 5/19/2015 | Tuesday | CA-2016-115917 | Andrew Roberts | West | Jeri | 19134 | GVD Item | 1854.61 | 32.00 | 59347.43 | |||||||||||||||
93 | 7/22/2014 | Tuesday | CA-2016-147067 | Nona Balk | SouthEast | Luke | 75217 | ENW Item | 3438.09 | 29.00 | 99704.59 | |||||||||||||||
94 | 5/19/2015 | Tuesday | CA-2017-106103 | Clytie Kelty | SouthEast | Rhonda | 43123 | UVO Item | 3345.55 | 32.00 | 107057.68 | |||||||||||||||
95 | 7/22/2014 | Tuesday | US-2017-127719 | Nat Gilpin | West | Rhonda | 10011 | UNH Item | 2727.48 | 36.00 | 98189.28 | |||||||||||||||
96 | 5/19/2015 | Tuesday | CA-2016-103947 | Christina Anderson | NorthEast | Rhonda | 60610 | UDS Item | 3354.58 | 49.00 | 164374.30 | |||||||||||||||
97 | 7/22/2014 | Tuesday | CA-2016-160745 | Sylvia Foulston | West | Steven | 48126 | WMW Item | 4341.22 | 48.00 | 208378.78 | |||||||||||||||
98 | 5/19/2015 | Tuesday | CA-2017-140844 | Annie Thurman | West | Rhonda | 98115 | CJK Item | 4675.34 | 41.00 | 191688.76 | |||||||||||||||
99 | 7/22/2014 | Tuesday | CA-2016-137239 | Logan Currie | West | Rhonda | 94122 | WWU Item | 3043.75 | 39.00 | 118706.34 | |||||||||||||||
100 | 5/19/2015 | Tuesday | CA-2015-146563 | Brian Dahlen | NorthEast | Rhonda | 33180 | IZV Item | 6050.41 | 30.00 | 181512.26 |