Spreadsheet: 145413d1331573266-constructing-a-formula-to-do-what-advanced-filter-does-schedulestemplate
Sheet: Coaches

 | ACC |  | Big XII |  | Big East |  | Big Ten |  | Conference USA |  | Independent |  | MAC |  | Mountain West |  | Pac-12 |  | SEC |  | Sun Belt |  | WAC |  | ACC | 12
 | Boston College | [NAME] | Baylor | [NAME] | Cincinnati | [NAME] | Illinois | [NAME] | East Carolina | [NAME] | Army | [NAME] | Akron | [NAME] | Air Force | Troy Calhoun | Arizona | [NAME] | Alabama | [NAME] | Arkansas State | [NAME] | Idaho | Robb Akey | Big XII
 | Clemson | [NAME] | Iowa State | [NAME] | Connecticut | [NAME] | Indiana | [NAME] | Houston | [NAME] | BYU | Bronco Mendenhall | [NAME] | [NAME] | Boise State | [NAME] | Arizona State | [NAME] | Arkansas | [NAME] | Florida Atlantic | [NAME] | Louisiana Tech | [NAME] | Big East
 | Duke | [NAME] | Kansas | [NAME] | Louisville | [NAME] | Iowa | [NAME] | [NAME] | [NAME] | Navy | [NAME] | Bowling Green | [NAME] | Colorado State | [NAME] | California | [NAME] | Auburn | [NAME] | Florida International | [NAME] | New Mexico State | [NAME] | Big Ten
 | Florida State | Jimbo Fisher | Kansas State | [NAME] | Pittsburgh | Paul Chryst | Michigan | [NAME] | Memphis | [NAME] | Notre Dame | [NAME] | Buffalo | [NAME] | Fresno State | [NAME] | Colorado | [NAME] | Florida | [NAME] | Louisiana-Lafayette | [NAME] | San Jose State | [NAME] | Conference USA
 | Georgia Tech | [NAME] | Oklahoma | [NAME] | Rutgers | [NAME] | Michigan State | [NAME] | [NAME] | [NAME] |  |  | Central Michigan | [NAME] | Hawaii | [NAME] | Oregon | [NAME] | Georgia | [NAME] | Louisiana-Monroe | [NAME] | Texas State | [NAME] | Independent
 | Maryland | [NAME] | Oklahoma State | [NAME] | South Florida | [NAME] | Minnesota | [NAME] | SMU | June Jones |  |  | Eastern Michigan | [NAME] | Nevada | [NAME] | Oregon State | [NAME] | Kentucky | [NAME] | Middle Tennessee | [NAME] | Utah State | [NAME] | MAC
 | Miami | [NAME] | TCU | [NAME] | Syracuse | [NAME] | Nebraska | Bo Pelini | Southern Miss | [NAME] |  |  | [NAME] | [NAME] | New Mexico | [NAME] | Stanford | [NAME] | LSU | [NAME] | North Texas | [NAME] | UTSA | [NAME] | Mountain West
 | North Carolina | [NAME] | Texas | [NAME] |  |  | Northwestern | [NAME] | Tulane | Curtis [NAME] |  |  | UMass | [NAME] | San Diego State | [NAME] | UCLA | [NAME] | Ole Miss | [NAME] | South Alabama | [NAME] |  |  | Pac-12
 | NC State | [NAME] | Texas Tech | [NAME] |  |  | Ohio State | Urban Meyer | Tulsa | [NAME] |  |  | Miami (OH) | [NAME] | UNLV | [NAME] | USC | [NAME] | Mississippi State | [NAME] | Troy | [NAME] |  |  | SEC
 | Virginia | [NAME] | West Virginia | [NAME] |  |  | Penn State | [NAME] | UAB | [NAME] |  |  | Northern Illinois | [NAME] | Wyoming | [NAME] | Utah | [NAME] | Missouri | [NAME] | Western Kentucky | [NAME] |  |  | Sun Belt
 | [NAME] | [NAME] |  |  |  |  | Purdue | [NAME] | UCF | [NAME] |  |  | Ohio | [NAME] |  |  | Washington | [NAME] | Tennessee | [NAME] |  |  |  |  | WAC
 | Wake Forest | [NAME] |  |  |  |  | Wisconsin | [NAME] | UTEP | [NAME] |  |  | Temple | [NAME] |  |  | Washington State | [NAME] | Texas A&M | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Toledo | [NAME] |  |  |  |  | South Carolina | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Western Michigan | [NAME] |  |  |  |  | [NAME] | [NAME]