Distributor ID Distributor Name Country Product Code

23345 Devin Abbott France SUPA105

23278 Aphrodite Brennan Malawi SUPA105
23303 Guinevere Key Colombia SUPA105
23353 Zahir Fields Canada SUPA105
23289 Deacon Craig Mongolia SUPA105
23378 Brynne Mcgowan Finland SUPA105
23283 Lani Sweet Vanuatu SUPA105
23324 Noble Warner Burkina Faso SUPA104
23264 Levi Douglas Tanzania, United Republic of DETA800
23291 Jelani Odonnell Albania DETA800
23305 Jared Sandoval Botswana DETA800
23350 Hiroko Acevedo Burundi DETA800
23300 Rhona Clarke Zimbabwe SUPA104
23348 Tad Mack Iceland SUPA104
23290 Rama Goodwin Tunisia DETA800
23328 Keaton Wolfe French Southern Territories SUPA105
23294 Samuel Ayala Brazil DETA800
23371 Doris Williams Trinidad and Tobago SUPA103
23288 Ingrid Bush Montserrat SUPA104
23347 Nell Maddox Azerbaijan DETA800
23361 Benedict Byrd Mauritania SUPA103
23275 Ethan Gregory Tuvalu DETA800
23297 Ursula Mcconnell Hungary DETA800
23327 Fletcher Jimenez Chad DETA200
23325 Isadora Mcclure Indonesia DETA100
23292 Liberty Mcbride Fiji SUPA105
23335 Noble Gilbert United States DETA800
23314 Maxine Gentry Panama SUPA104
23329 Melinda Cobb Uruguay PURA250
23332 Yael Carter Malaysia PURA250
23317 Kay Buckley Malta PURA250
23271 Athena Fitzpatrick Reunion SUPA103
23287 Joy Vazquez Korea PURA250
23349 Amery Frazier Georgia DETA200
23309 Buckminster Hopkins Sierra Leone PURA200
23338 George Best Western Sahara PURA250
23301 Maxwell Parker Falkland Islands (Malvinas) SUPA103
23320 Lance Little Croatia DETA100
23365 Gwendolyn Walton Cuba SUPA102
23302 Isaac Wolf Panama PURA500
23266 Celeste Pugh Gabon PURA200
23307 Oprah Ellis Dominican Republic DETA100
23368 Emerson Beard Niue SUPA102
23286 Renee Padilla Yemen DETA800
23373 Maite Henson Bangladesh DETA200
23380 Ivory Chang Tonga PURA500
23284 Clark Weaver Palau PURA250
23306 Ima Cummings Philippines DETA200
23281 Adria Kaufman Bouvet Island SUPA102
23351 Nyssa Quinn Cocos (Keeling) Islands PURA200
23282 Amir Alexander Liberia DETA100
23376 Imogene Bradshaw Niger SUPA103
23354 Gwendolyn Mccarty Madagascar SUPA103
23337 Bell Prince Guinea SUPA103
23326 Katelyn Joseph Slovenia SUPA102
23316 Robert Juarez Svalbard and Jan Mayen PURA200
23362 Jerry Alvarado Korea, Republic of PURA100
23296 India Gilbert Denmark SUPA105
23352 Iliana Porter Poland DETA100
23304 Deanna Santana Solomon Islands PURA200
23369 Ivor Mclaughlin United States Minor Outlying Islands PURA500
23268 Latifah Wall Guadeloupe DETA100
23315 Anika Tillman Burkina Faso PURA250
23342 Paul Duke Puerto Rico PURA200
23333 Sawyer Stokes Malta PURA250
23263 Xerxes Smith Panama DETA200
23270 Wanda Garza Kyrgyzstan SUPA103
23272 Anjolie Hicks Turks and Caicos Islands DETA200
23274 Asher Weber Macedonia PURA100
23364 Mercedes Humphrey Turkey DETA800
23276 Hayes Rollins Nepal PURA500
23343 Josiah Yates Bangladesh SUPA104
23344 Winifred Cantu Kazakhstan DETA200
23299 Germaine Kidd Niger PURA200
23310 Kenyon Joyce Canada SUPA104
23358 Joel Rivers Australia SUPA104
23323 Colby Knapp Pakistan PURA100
23267 Vance Campos Syrian Arab Republic PURA100
23340 Lael Gould El Salvador SUPA102
23269 Jane Hernandez Macedonia PURA100
23308 Dara Cunningham Saint Helena PURA100
23356 Colette Sargent Norfolk Island PURA200
23318 Shea Cortez India DETA200
23357 Cyrus Whitley Denmark DETA100
23377 Eleanor Hopper Madagascar PURA500
23311 Forrest Macdonald New Caledonia SUPA105
23379 Desirae Perkins Chile PURA200
23360 Barrett Mckinney Syrian Arab Republic SUPA103
23339 Basil Vang Moldova DETA100
23341 Noel Key Gambia PURA100
23374 Ebony Mercer Cape Verde PURA200
23273 Isaac Cooper Netherlands Antilles SUPA104
23280 James Spencer Burkina Faso SUPA103
23370 Clark Orr Indonesia PURA100
23372 Phillip Perkins Nigeria PURA500
23265 Uriel Benton South Africa SUPA104
23346 Aretha Patton Bouvet Island SUPA104
23312 Thomas Barnes Mayotte PURA200
23355 Victoria Solis Palau PURA250
23322 Arsenio Knowles Malaysia PURA100
23298 Ryder Conner Virgin Islands, British PURA250
23367 Roary Dixon Saudi Arabia PURA250
23334 Silas Battle Niue PURA100
23285 Leonard Cardenas Madagascar SUPA102
23375 Brittany Burris Palau SUPA103
23336 Petra Mckenzie Morocco SUPA102
23279 Angela Wise Moldova PURA100
Sales Channel Date Sold Month Sold Quantity Unit Price Revenue
Online 8/29/2012 8 208 $14.50 $ 3,016
Direct 8/24/2012 8 197 $14.50 $ 2,857
Retail 8/17/2012 8 176 $14.50 $ 2,552
Direct 6/10/2012 6 168 $14.50 $ 2,436
Retail 8/2/2012 8 166 $14.50 $ 2,407
Online 6/18/2012 6 157 $14.50 $ 2,277
Online 6/24/2012 6 142 $14.50 $ 2,059
Retail 8/13/2012 8 193 $9.99 $ 1,928
Online 8/18/2012 8 205 $9.00 $ 1,845
Retail 8/18/2012 8 199 $9.00 $ 1,791
Online 8/26/2012 8 188 $9.00 $ 1,692
Online 6/25/2012 6 188 $9.00 $ 1,692
Online 1/7/2012 1 167 $9.99 $ 1,668
Retail 8/25/2012 8 163 $9.99 $ 1,628
Online 8/11/2012 8 170 $9.00 $ 1,530
Retail 1/15/2012 1 102 $14.50 $ 1,479
Retail 6/22/2012 6 160 $9.00 $ 1,440
Online 8/15/2012 8 204 $6.99 $ 1,426
Direct 6/14/2012 6 141 $9.99 $ 1,409
Online 6/28/2012 6 147 $9.00 $ 1,323
Online 1/7/2012 1 184 $6.99 $ 1,286
Retail 1/4/2012 1 141 $9.00 $ 1,269
Online 8/12/2012 8 135 $9.00 $ 1,215
Retail 1/31/2012 1 176 $6.50 $ 1,144
Retail 6/22/2012 6 184 $6.00 $ 1,104
Online 1/3/2012 1 73 $14.50 $ 1,059
Online 8/13/2012 8 116 $9.00 $ 1,044
Retail 8/10/2012 8 95 $9.99 $ 949
Retail 1/23/2012 1 203 $4.50 $ 914
Direct 2/11/2012 2 203 $4.50 $ 914
Direct 2/17/2012 2 196 $4.50 $ 882
Retail 2/27/2012 2 125 $6.99 $ 874
Retail 6/17/2012 6 189 $4.50 $ 851
Retail 7/22/2012 7 126 $6.50 $ 819
Online 6/23/2012 6 201 $3.99 $ 802
Retail 8/12/2012 8 178 $4.50 $ 801
Retail 7/19/2012 7 108 $6.99 $ 755
Direct 6/15/2012 6 125 $6.00 $ 750
Retail 7/9/2012 7 165 $4.50 $ 743
Online 7/27/2012 7 105 $6.50 $ 683
Online 8/11/2012 8 170 $3.99 $ 678
Retail 7/4/2012 7 113 $6.00 $ 678
Retail 8/25/2012 8 150 $4.50 $ 675
Online 8/8/2012 8 69 $9.00 $ 621
Online 7/24/2012 7 95 $6.50 $ 618
Retail 7/22/2012 7 95 $6.50 $ 618
Retail 6/17/2012 6 135 $4.50 $ 608
Online 6/8/2012 6 93 $6.50 $ 605
Retail 7/13/2012 7 134 $4.50 $ 603
Online 8/3/2012 8 151 $3.99 $ 602
Retail 8/21/2012 8 100 $6.00 $ 600
Direct 7/23/2012 7 85 $6.99 $ 594
Online 8/3/2012 8 84 $6.99 $ 587
Retail 7/7/2012 7 82 $6.99 $ 573
Retail 8/21/2012 8 126 $4.50 $ 567
Retail 6/1/2012 6 137 $3.99 $ 547
Online 8/18/2012 8 179 $3.00 $ 537
Retail 6/8/2012 6 37 $14.50 $ 537
Online 7/7/2012 7 89 $6.00 $ 534
Retail 6/1/2012 6 131 $3.99 $ 523
Retail 7/2/2012 7 77 $6.50 $ 501
Online 7/12/2012 7 82 $6.00 $ 492
Retail 7/12/2012 7 109 $4.50 $ 491
Online 6/28/2012 6 122 $3.99 $ 487
Online 8/5/2012 8 106 $4.50 $ 477
Online 7/6/2012 7 73 $6.50 $ 475
Retail 6/7/2012 6 67 $6.99 $ 468
Direct 7/31/2012 7 71 $6.50 $ 462
Retail 8/22/2012 8 153 $3.00 $ 459
Online 7/3/2012 7 47 $9.00 $ 423
Online 8/1/2012 8 65 $6.50 $ 423
Online 8/23/2012 8 42 $9.99 $ 420
Online 12/22/2012 12 64 $6.50 $ 416
Retail 6/27/2012 6 104 $3.99 $ 415
Online 6/17/2012 6 41 $9.99 $ 410
Retail 6/11/2012 6 41 $9.99 $ 410
Online 12/29/2012 12 135 $3.00 $ 405
Online 7/11/2012 7 129 $3.00 $ 387
Online 7/5/2012 7 85 $4.50 $ 383
Online 6/3/2012 6 116 $3.00 $ 348
Retail 7/9/2012 7 112 $3.00 $ 336
Online 6/21/2012 6 80 $3.99 $ 319
Online 7/9/2012 7 48 $6.50 $ 312
Retail 7/17/2012 7 50 $6.00 $ 300
Online 6/15/2012 6 43 $6.50 $ 280
Retail 6/12/2012 6 18 $14.50 $ 261
Online 12/27/2012 12 65 $3.99 $ 259
Online 6/13/2012 6 37 $6.99 $ 259
Online 7/11/2012 7 41 $6.00 $ 246
Retail 4/27/2012 4 77 $3.00 $ 231
Online 12/14/2012 12 57 $3.99 $ 227
Online 12/13/2012 12 22 $9.99 $ 220
Online 4/3/2012 4 30 $6.99 $ 210
Retail 4/29/2012 4 63 $3.00 $ 189
Online 12/12/2012 12 22 $6.50 $ 143
Retail 12/5/2012 12 14 $9.99 $ 140
Online 7/29/2012 7 13 $9.99 $ 130
Online 7/6/2012 7 28 $3.99 $ 112
Online 4/27/2012 4 16 $4.50 $ 72
Retail 4/10/2012 4 20 $3.00 $ 60
Direct 7/28/2012 7 12 $4.50 $ 54
Retail 4/24/2012 4 10 $4.50 $ 45
Online 12/17/2012 12 14 $3.00 $ 42
Retail 7/24/2012 7 9 $4.50 $ 41
Retail 4/30/2012 4 5 $6.99 $ 35
Retail 7/1/2012 7 7 $4.50 $ 32
Online 4/21/2012 4 10 $3.00 $ 30
Problem 1a

Your team has been given a list of transactions that require additional follow up.
Identify the associated distributors below using vlookup:

Distributor ID Name
23265
23315

Problem 1b

Using the Sales Data Set tab, lets pull the sales channel for each Distributor ID

Distributor ID Sales Channel

23265
23378
23288
23347

Distributor ID Sales Channel Quantity Revenue

23353
23289
23378
23283
23324
23303

Problem 2a

Nest V-lookup with Iferror and pull the Name associated with the Distributor ID.

Distributor ID Country Name Revenue

23265
23315
30000
40000
23367
23326
35000
Total Revenue $ -

Your team has been given a list of transactions that require additional follow up.
Identify the associated distributors below using vlookup:

Distributor ID Name Revenue

23265
40000
23367

Total Revenue

Problem 2b

Use the Sales Data Set to pull the Unit Price for each Distributor ID.

Distributor ID Unit Price

23265
23315
30000
23377
23311
23371.5

Average Unit Price

Problem 1a

Your team has been given a list of transactions that require additional follow up.
Identify the associated distributors below using Index Match:

Distributor ID Name
23265
23315

Problem 1b

Using the Sales Data Set tab, lets pull the sales channel for each Distributor ID

Distributor ID Sales Channel

23265
23378
23288
23347

Distributor ID Sales Channel Quantity

23353
23289
23378
23283
23324
23303

Problem 2a

Nest Index-Match with Iferror and pull the Name associated with the Distributor ID.

Distributor ID Country Name

23265
23315
30000
40000
23367
23326
35000
Total Revenue

Your team has been given a list of transactions that require additional follow up.
Identify the associated distributors below using Index-Match:

Distributor ID Name Revenue

23265
40000
23367

Total Revenue

Problem 2b

Use the Sales Data Set to pull the Unit Price for each Distributor ID.

Distributor ID Unit Price

23265
23315
30000
23377
23311
23371.5

Average Unit Price

Revenue

Revenue