Spreadsheet: 869252d1715866025-aggregate-function-not-working-correctly-using-excel-2010-most-and-least
Sheet: Sheet1

 |  |  |  | County | State | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual |  |  | County | State | Helper
 |  |  |  | [NAME] | IA | 0 | 0 | 3 | 18 | 37 | 50 | 34 | 21 | 12 | 3 | 0 | 1 | 179 |  |  | Dodge | MN | 1
 |  |  |  | Chickasaw | IA | 0 | 0 | 5 | 22 | 34 | 53 | 35 | 19 | 9 | 3 | 0 | 1 | 181 |  |  | Fillmore | MN | 1
 |  |  |  | [NAME] | IA | 0 | 0 | 6 | 22 | 44 | 51 | 32 | 15 | 11 | 1 | 0 | 1 | 183 |  |  | Houston | MN | 1
 |  |  |  | [NAME] | WI | 0 | 0 | 4 | 11 | 30 | 28 | 56 | 35 | 23 | 1 | 0 | 1 | 189 |  |  | Mower | MN | 1
 |  |  |  | Richland | WI | 0 | 0 | 3 | 12 | 34 | 43 | 47 | 37 | 17 | 2 | 0 | 1 | 196 |  |  | Olmsted | MN | 1
 |  |  |  | Crawford | WI | 0 | 1 | 5 | 19 | 37 | 47 | 41 | 31 | 15 | 4 | 0 | 1 | 201 |  |  | Wabasha | MN | 2
 |  |  |  | Mitchell | IA | 0 | 0 | 6 | 22 | 44 | 58 | 46 | 18 | 9 | 3 | 0 | 1 | 207 |  |  | Winona | MN | 2
 |  |  |  | Allamakee | IA | 0 | 0 | 3 | 25 | 42 | 52 | 34 | 31 | 22 | 1 | 0 | 3 | 213 |  |  | Allamakee | IA | 1
 |  |  |  | Houston | MN | 0 | 0 | 4 | 14 | 41 | 61 | 46 | 37 | 11 | 2 | 0 | 1 | 217 |  |  | Chickasaw | IA | 1
 |  |  |  | Dodge | MN | 0 | 0 | 3 | 7 | 47 | 56 | 52 | 36 | 17 | 2 | 0 | 1 | 221 |  |  | [NAME] | IA | 1
 |  |  |  | Winneshiek | IA | 0 | 0 | 6 | 22 | 46 | 55 | 40 | 34 | 17 | 3 | 0 | 1 | 224 |  |  | Fayette | IA | 1
 |  |  |  | Adams | WI | 0 | 0 | 6 | 18 | 33 | 48 | 60 | 34 | 28 | 4 | 0 | 1 | 232 |  |  | [NAME] | IA | 1
 |  |  |  | Juneau | WI | 0 | 0 | 5 | 21 | 30 | 56 | 53 | 41 | 30 | 2 | 0 | 1 | 239 |  |  | [NAME] | IA | 1
 |  |  |  | Fayette | IA | 0 | 0 | 9 | 29 | 50 | 66 | 48 | 25 | 13 | 0 | 0 | 1 | 241 |  |  | Mitchell | IA | 1
 |  |  |  | [NAME] | IA | 0 | 0 | 10 | 27 | 49 | 59 | 53 | 25 | 23 | 1 | 2 | 3 | 252 |  |  | Winneshiek | IA | 1
 |  |  |  | La Crosse | WI | 0 | 0 | 5 | 21 | 43 | 65 | 71 | 31 | 14 | 4 | 0 | 2 | 256 |  |  | Adams | WI | 1
 |  |  |  | Wabasha | MN | 0 | 0 | 3 | 11 | 65 | 59 | 59 | 39 | 18 | 1 | 0 | 2 | 257 |  |  | Buffalo | WI | 1
 |  |  |  | Monroe | WI | 0 | 0 | 5 | 22 | 38 | 60 | 73 | 39 | 18 | 1 | 0 | 1 | 257 |  |  | [NAME] | WI | 1
 |  |  |  | Vernon | WI | 0 | 0 | 6 | 18 | 47 | 68 | 68 | 37 | 17 | 1 | 0 | 2 | 264 |  |  | Crawford | WI | 1
 |  |  |  | Mower | MN | 0 | 0 | 2 | 23 | 52 | 73 | 59 | 35 | 18 | 4 | 0 | 1 | 267 |  |  | Grant | WI | 1
 |  |  |  | [NAME] | WI | 0 | 0 | 1 | 16 | 43 | 53 | 81 | 44 | 37 | 1 | 0 | 3 | 279 |  |  | [NAME] | WI | 1
 |  |  |  | [NAME] | WI | 0 | 0 | 2 | 22 | 44 | 73 | 66 | 51 | 26 | 5 | 0 | 1 | 290 |  |  | Juneau | WI | 1
 |  |  |  | Fillmore | MN | 0 | 0 | 3 | 24 | 62 | 85 | 63 | 43 | 16 | 2 | 0 | 2 | 300 |  |  | La Crosse | WI | 1
 |  |  |  | Grant | WI | 1 | 0 | 12 | 31 | 62 | 84 | 55 | 33 | 22 | 2 | 2 | 2 | 306 |  |  | Monroe | WI | 1
 |  |  |  | Winona | MN | 0 | 0 | 2 | 19 | 75 | 72 | 70 | 48 | 20 | 2 | 0 | 2 | 310 |  |  | Richland | WI | 1
 |  |  |  | Buffalo | WI | 0 | 0 | 4 | 19 | 69 | 70 | 71 | 52 | 21 | 3 | 0 | 1 | 310 |  |  | [NAME] | WI | 1
 |  |  |  | Olmsted | MN | 0 | 0 | 2 | 15 | 72 | 71 | 74 | 52 | 20 | 3 | 0 | 2 | 311 |  |  | Trempealeau | WI | 1
 |  |  |  | Trempealeau | WI | 0 | 0 | 2 | 24 | 60 | 90 | 75 | 50 | 25 | 5 | 0 | 1 | 332 |  |  | Vernon | WI | 1
 |  |  |  | Current Table |  |  |  |  |  |  | Desired Results
 |  |  |  | Counties with Most Warnings |  |  |  |  |  |  | Counties with Most Warnings
 |  |  |  | Rank | Most | County | State |  |  |  | Rank | Most | County | State
 |  |  |  | 1 | 332 |  |  |  |  |  | 1 | 332 | Trempealeau | WI
 |  |  |  | 2 | 311 |  |  |  |  |  | 2 | 311 | Olmsted | MN
 |  |  |  | 3 | 310 |  |  |  |  |  | 3 | 310 | Winona | MN
 |  |  |  | 4 | 310 |  |  |  |  |  | 4 | 310 | Buffalo | WI
 |  |  |  | 5 | 306 |  |  |  |  |  | 5 | 306 | Grant | WI
 |  |  |  | 6 | 300 |  |  |  |  |  | 6 | 300 | Fillmore | MN
 |  |  |  | 7 | 290 |  |  |  |  |  | 7 | 290 | [NAME] | WI
 |  |  |  | 8 | 279 |  |  |  |  |  | 8 | 279 | [NAME] | WI
 |  |  |  | 9 | 267 |  |  |  |  |  | 9 | 267 | Mower | MN
 |  |  |  | 10 | 264 |  |  |  |  |  | 10 | 264 | Vernon | WI
 |  |  |  | Current Table |  |  |  |  |  |  | Desired Results
 |  |  |  | Counties with Least Warnings |  |  |  |  |  |  | Counties with Least Warnings
 |  |  |  | Rank | Most | County | State |  |  |  | Rank | Least | County | State
 |  |  |  | 1 | 179 |  |  |  |  |  | 1 | 179 | [NAME] | IA
 |  |  |  | 2 | 181 |  |  |  |  |  | 2 | 181 | Chickasaw | IA
 |  |  |  | 3 | 183 |  |  |  |  |  | 3 | 183 | [NAME] | IA
 |  |  |  | 4 | 189 |  |  |  |  |  | 4 | 189 | [NAME] | WI
 |  |  |  | 5 | 196 |  |  |  |  |  | 5 | 196 | Richland | WI
 |  |  |  | 6 | 201 |  |  |  |  |  | 6 | 201 | Crawford | WI
 |  |  |  | 7 | 207 |  |  |  |  |  | 7 | 207 | Mitchell | IA
 |  |  |  | 8 | 213 |  |  |  |  |  | 8 | 213 | Allamakee | IA
 |  |  |  | 9 | 217 |  |  |  |  |  | 9 | 217 | Houston | MN
 |  |  |  | 10 | 221 |  |  |  |  |  | 10 | 221 | Dodge | MN