Spreadsheet: 785483d1656439264-excel-skills-for-business-advanced-week-2-problem-wssa
Sheet: Raw_Data

 | Section 2 - Sorting and Arrays |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Question 4 | Question 5 | Question 6 |  |  | Question 7
 |  | High_F | Low_F | High_C | Low_C |  |  | Helper Index |  | Rank of Location: COUNTIF(S) | Location of Helper Index Value (MATCH function) | Final Location Sort Order (INDEX function) |  |  | 5 largest High (F) temperatures
 | San Antonio, Texas | 80 | 59 | 27 | 15
 | Virginia Beach, Virginia | 68 | 52 | 20 | 11 |  |  | 2
 | Portland, Oregon | 63 | 45 | 17 | 7 |  |  | 3
 | Boston, Massachusetts | 59 | 44 | 15 | 7 |  |  | 4
 | New Orleans, Louisiana | 78 | 61 | 26 | 16 |  |  | 5
 | Atlanta, Georgia | 72 | 53 | 22 | 12 |  |  | 6
 | Austin, Texas | 80 | 59 | 27 | 15 |  |  | 7 |  |  |  |  |  | Sum
 | Denver, Colorado | 64 | 36 | 18 | 2 |  |  | 8
 | Phoenix, Arizona | 87 | 63 | 31 | 17 |  |  | 9
 | Minneapolis, Minnesota | 55 | 37 | 13 | 3 |  |  | 10 |  |  |  |  |  |  | Question 8
 | San Francisco, California | 64 | 51 | 18 | 10 |  |  | 11 |  |  |  |  |  | Sum of [High_C * Low_C] for all locations with a Low_C less than 10
 | New York, New York | 62 | 48 | 17 | 9 |  |  | 12
 | Buffalo, New York | 56 | 40 | 14 | 5 |  |  | 13
 | Tampa, Florida | 82 | 65 | 28 | 18 |  |  | 14
 | Cleveland, Ohio | 60 | 43 | 15 | 6 |  |  | 15
 | Dallas, Texas | 77 | 57 | 25 | 14 |  |  | 16
 | Birmingham, Alabama | 74 | 53 | 23 | 12 |  |  | 17
 | Indianapolis, Indiana | 63 | 44 | 17 | 7 |  |  | 18
 | Miami, Florida | 84 | 70 | 29 | 21 |  |  | 19
 | Houston, Texas | 80 | 60 | 27 | 16 |  |  | 20
 | San Jose, California | 71 | 50 | 22 | 10 |  |  | 21
 | Pittsburgh, Pennsylvania | 61 | 42 | 16 | 6 |  |  | 22
 | Kansas City, Missouri | 66 | 48 | 19 | 9 |  |  | 23
 | St. Louis, Missouri | 66 | 48 | 19 | 9 |  |  | 24
 | Sacramento, California | 74 | 48 | 23 | 9 |  |  | 25
 | Providence, Rhode Island | 61 | 43 | 16 | 6 |  |  | 26
 | Columbus, Ohio | 63 | 44 | 17 | 7 |  |  | 27
 | Nashville, Tennessee | 70 | 49 | 21 | 9 |  |  | 28
 | Hartford, Connecticut | 61 | 40 | 16 | 5 |  |  | 29
 | Orlando, Florida | 83 | 63 | 28 | 17 |  |  | 30
 | Baltimore, Maryland | 65 | 45 | 18 | 7 |  |  | 31
 | Raleigh, North Carolina | 72 | 50 | 22 | 10 |  |  | 32
 | Louisville, Kentucky | 68 | 49 | 20 | 9 |  |  | 33
 | Salt Lake City, Utah | 64 | 42 | 18 | 5 |  |  | 34
 | Richmond, Virginia | 70 | 48 | 21 | 9 |  |  | 35
 | Washington, DC | 67 | 50 | 19 | 10 |  |  | 36
 | Charlotte, North Carolina | 71 | 49 | 22 | 9 |  |  | 37
 | Detroit, Michigan | 59 | 42 | 15 | 5 |  |  | 38
 | Rochester, New York | 57 | 39 | 14 | 4 |  |  | 39
 | Oklahoma City, Oklahoma | 72 | 51 | 22 | 10 |  |  | 40
 | Jacksonville, Florida | 79 | 58 | 26 | 14 |  |  | 41
 | Seattle, Washington | 61 | 46 | 16 | 8 |  |  | 42
 | Riverside, California | 81 | 53 | 27 | 11 |  |  | 43
 | Milwaukee, Wisconsin | 56 | 40 | 13 | 5 |  |  | 44
 | Memphis, Tennessee | 73 | 54 | 23 | 12 |  |  | 45
 | Los Angeles, California | 75 | 56 | 24 | 13 |  |  | 46
 | San Diego, California | 70 | 58 | 21 | 14 |  |  | 47
 | Las Vegas, Nevada | 80 | 59 | 27 | 15 |  |  | 48
 | Philadelphia, Pennsylvania | 65 | 47 | 18 | 8 |  |  | 49
 | Cincinnati, Ohio | 65 | 43 | 18 | 6 |  |  | 50
 | Chicago, Illinois | 59 | 41 | 15 | 5 |  |  | 51
 | Section 3 - Transpose and more arrays