Spreadsheet: 97074d1296273413-winning-losing-streak-without-dates-in-order-basketballstats
Sheet: Used to Convert Data

Team | Date | Score | Win/Loss | Win/Loss | Home/Away/Neither | A/H/N | Score
Idaho State University | 2007-02-21 00:00:00 | 64-49 Home | W | W | Home | Home | 64-49
Montana State University | 2007-02-21 00:00:00 | 64-49 Home |  | W |  | Away | 64-49 |  | I used this sheet to convert you Sheet 1 data to a Table
Eastern Washington University | 2007-11-09 00:00:00 | 41-68 Away | L | L | Away | Away | 41-68 |  | I had to Auto Filter by score and copy the 3 teams you track to this page
Washington State University | 2007-11-09 00:00:00 | 41-68 Away |  | W |  | Home | 41-68 |  | Then I needed to carefully copy the opponents
Idaho State University | 2007-11-09 00:00:00 | 43-58 Away | L | L | Away | Away | 43-58 |  | Then I sorted by date and calculated Win or Loss and Home/Away
University of Iowa | 2007-11-09 00:00:00 | 43-58 Away |  | W |  | Home | 43-58 |  | I also trimmed out the score.
California State University-Sacramento | 2007-11-09 00:00:00 | 63-94 Away | L | L | Away | Away | 63-94
Kansas State University | 2007-11-09 00:00:00 | 63-94 Away |  | W |  | Home | 63-94 |  | I can see you wanted to put in a Conference, Region and Section
California State University-Sacramento | 2007-11-12 00:00:00 | 104-71 Home | W | W | Home | Home | 104-71 |  | But that wasn't tied together for me
Simpson College | 2007-11-12 00:00:00 | 104-71 Home |  | W |  | Away | 104-71
Eastern Washington University | 2007-11-12 00:00:00 | 57-92 Away | L | L | Away | Away | 57-92 |  | This allowed me to copy and [NAME] (Values Only) to sheet 3
University of New Mexico | 2007-11-12 00:00:00 | 57-92 Away |  | W |  | Home | 57-92
California State University-Sacramento | 2007-11-14 00:00:00 | 53-57 Home | W | W | Home | Home | 53-57
Southern Utah University | 2007-11-14 00:00:00 | 53-57 Home |  | W |  | Away | 53-57
Idaho State University | 2007-11-14 00:00:00 | 69-90 Away | L | L | Away | Away | 69-90
[NAME] | 2007-11-14 00:00:00 | 69-90 Away |  | W |  | Home | 69-90
Eastern Washington University | 2007-11-15 00:00:00 | 59-51 Home | W | W | Home | Home | 59-51
University of California-Riverside | 2007-11-15 00:00:00 | 59-51 Home |  | W |  | Away | 59-51
Idaho State University | 2007-11-17 00:00:00 | 61-66 Away | L | L | Away | Away | 61-66
California State University-Long Beach | 2007-11-17 00:00:00 | 61-66 Away |  | W |  | Home | 61-66
California State University-Sacramento | 2007-11-17 00:00:00 | 63-93 Away | L | L | Away | Away | 63-93
University of San Francisco | 2007-11-17 00:00:00 | 63-93 Away |  | W |  | Home | 63-93
Eastern Washington University | 2007-11-18 00:00:00 | 68-82 Away | L | L | Away | Away | 68-82
University of Washington | 2007-11-18 00:00:00 | 68-82 Away |  | W |  | Home | 68-82
California State University-Sacramento | 2007-11-21 00:00:00 | 62-75 Away | L | L | Away | Away | 62-75
Pacific University-California | 2007-11-21 00:00:00 | 62-75 Away |  | W |  | Home | 62-75
Eastern Washington University | 2007-11-22 00:00:00 | 52-69 (Carrs/Safeway Great Alaska Shootout) | L | L | out) | Neither | 52-69
Virginia Institute of Technology | 2007-11-22 00:00:00 | 52-69 (Carrs/Safeway Great Alaska Shootout) |  | W |  | Neither | 52-69
Idaho State University | 2007-11-23 00:00:00 | 41-56 Away | L | L | Away | Away | 41-56
Oregon State University | 2007-11-23 00:00:00 | 41-56 Away |  | W |  | Home | 41-56
Eastern Washington University | 2007-11-23 00:00:00 | 53-61 (Carrs/Safeway Great Alaska Shootout) | L | L | out) | Neither | 53-61
University of Michigan | 2007-11-23 00:00:00 | 53-61 (Carrs/Safeway Great Alaska Shootout) |  | W |  | Neither | 53-61
Idaho State University | 2007-11-24 00:00:00 | 52-76 Away | L | L | Away | Away | 52-76
University of Portland | 2007-11-24 00:00:00 | 52-76 Away |  | W |  | Home | 52-76
Eastern Washington University | 2007-11-24 00:00:00 | 64-62 (Carrs/Safeway Great Alaska Shootout) | W | W | out) | Neither | 64-62
University of Alaska-Anchorage | 2007-11-24 00:00:00 | 64-62 (Carrs/Safeway Great Alaska Shootout) |  | W |  | Neither | 64-62
California State University-Sacramento | 2007-11-25 00:00:00 | 65-77 Home | L | L | Home | Home | 65-77
Santa Clara University | 2007-11-25 00:00:00 | 65-77 Home |  | W |  | Away | 65-77
California State University-Sacramento | 2007-11-27 00:00:00 | 58-84 Away | L | L | Away | Away | 58-84
Stanford University | 2007-11-27 00:00:00 | 58-84 Away |  | W |  | Home | 58-84
Eastern Washington University | 2007-11-29 00:00:00 | 57-66 Home | L | L | Home | Home | 57-66
Santa Clara University | 2007-11-29 00:00:00 | 57-66 Home |  | W |  | Away | 57-66
Idaho State University | 2007-12-01 00:00:00 | 71-69 Away | W | W | Away | Away | 71-69
University of Idaho | 2007-12-01 00:00:00 | 71-69 Away |  | W |  | Home | 71-69
Eastern Washington University | 2007-12-03 00:00:00 | 65-54 Away | W | W | Away | Away | 65-54
University of Missouri-Kansas City | 2007-12-03 00:00:00 | 65-54 Away |  | W |  | Home | 65-54
California State University-Sacramento | 2007-12-04 00:00:00 | 72-54 Home | W | W | Home | Home | 72-54
[NAME] University | 2007-12-04 00:00:00 | 72-54 Home |  | W |  | Away | 72-54
Eastern Washington University | 2007-12-05 00:00:00 | 47-85 Away | L | L | Away | Away | 47-85
University of Kansas | 2007-12-05 00:00:00 | 47-85 Away |  | W |  | Home | 47-85
Idaho State University | 2007-12-05 00:00:00 | 61-93 Home | L | L | Home | Home | 61-93
Boise State University | 2007-12-05 00:00:00 | 61-93 Home |  | W |  | Away | 61-93
Eastern Washington University | 2007-12-09 00:00:00 | 49-58 Away | L | L | Away | Away | 49-58
University of Idaho | 2007-12-09 00:00:00 | 49-58 Away |  | W |  | Home | 49-58
California State University-Sacramento | 2007-12-11 00:00:00 | 66-93 Away | L | L | Away | Away | 66-93
University of Oregon | 2007-12-11 00:00:00 | 66-93 Away |  | W |  | Home | 66-93
Idaho State University | 2007-12-15 00:00:00 | 49-89 Away | L | L | Away | Away | 49-89
University of California-Los Angeles | 2007-12-15 00:00:00 | 49-89 Away |  | W |  | Home | 49-89
California State University-Sacramento | 2007-12-15 00:00:00 | 51-82 Away | L | L | Away | Away | 51-82
Marquette University | 2007-12-15 00:00:00 | 51-82 Away |  | W |  | Home | 51-82
Eastern Washington University | 2007-12-17 00:00:00 | 84-75 Home | W | W | Home | Home | 84-75
University of Portland | 2007-12-17 00:00:00 | 84-75 Home |  | W |  | Away | 84-75
Eastern Washington University | 2007-12-22 00:00:00 | 58-57 Home | W | W | Home | Home | 58-57
Portland State University | 2007-12-22 00:00:00 | 58-57 Home |  | W |  | Away | 58-57
Idaho State University | 2007-12-23 00:00:00 | 45-75 Home | L | L | Home | Home | 45-75
Washington State University | 2007-12-23 00:00:00 | 45-75 Home |  | W |  | Away | 45-75
Idaho State University | 2007-12-27 00:00:00 | 51-68 Away | L | L | Away | Away | 51-68
University of Utah | 2007-12-27 00:00:00 | 51-68 Away |  | W |  | Home | 51-68
California State University-Sacramento | 2007-12-28 00:00:00 | 60-74 Away | L | L | Away | Away | 60-74
University of Northern Colorado | 2007-12-28 00:00:00 | 60-74 Away |  | W |  | Home | 60-74
Idaho State University | 2007-12-29 00:00:00 | 71-66 Home | W | W | Home | Home | 71-66
Northwest Nazarene College | 2007-12-29 00:00:00 | 71-66 Home |  | W |  | Away | 71-66
Idaho State University | 2007-12-31 00:00:00 | 50-82 Away | L | L | Away | Away | 50-82
University of Washington | 2007-12-31 00:00:00 | 50-82 Away |  | W |  | Home | 50-82
California State University-Sacramento | 2008-01-03 00:00:00 | 58-83 Away | L | L | Away | Away | 58-83
Portland State University | 2008-01-03 00:00:00 | 58-83 Away |  | W |  | Home | 58-83
Eastern Washington University | 2008-01-03 00:00:00 | 75-79 Home | L | L | Home | Home | 75-79
Northern Arizona University | 2008-01-03 00:00:00 | 75-79 Home |  | W |  | Away | 75-79
Idaho State University | 2008-01-03 00:00:00 | 76-65 Away | W | W | Away | Away | 76-65
University of Northern Colorado | 2008-01-03 00:00:00 | 76-65 Away |  | W |  | Home | 76-65
California State University-Sacramento | 2008-01-05 00:00:00 | 52-76 Away | L | L | Away | Away | 52-76
Eastern Washington University | 2008-01-05 00:00:00 | 52-76 Away |  | W |  | Home | 52-76
Eastern Washington University | 2008-01-05 00:00:00 | 76-52 Home | W | W | Home | Home | 76-52
California State University-Sacramento | 2008-01-05 00:00:00 | 76-52 Home |  | W |  | Away | 76-52
Eastern Washington University | 2008-01-10 00:00:00 | 56-58 Away | L | L | Away | Away | 56-58
Idaho State University | 2008-01-10 00:00:00 | 56-58 Away |  | W |  | Home | 56-58
Idaho State University | 2008-01-10 00:00:00 | 58-56 Home | W | W | Home | Home | 58-56
Eastern Washington University | 2008-01-10 00:00:00 | 58-56 Home |  | W |  | Away | 58-56
California State University-Sacramento | 2008-01-10 00:00:00 | 78-77 Home | W | W | Home | Home | 78-77
Montana State University | 2008-01-10 00:00:00 | 78-77 Home |  | W |  | Away | 78-77
Eastern Washington University | 2008-01-12 00:00:00 | 64-74 Away | L | L | Away | Away | 64-74
Weber State University | 2008-01-12 00:00:00 | 64-74 Away |  | W |  | Home | 64-74
California State University-Sacramento | 2008-01-12 00:00:00 | 69-76 Home | L | L | Home | Home | 69-76
University of Montana | 2008-01-12 00:00:00 | 69-76 Home |  | W |  | Away | 69-76
Idaho State University | 2008-01-13 00:00:00 | 61-71 Home | L | L | Home | Home | 61-71
Portland State University | 2008-01-13 00:00:00 | 61-71 Home |  | W |  | Away | 61-71
California State University-Sacramento | 2008-01-15 00:00:00 | 61-73 Home | L | L | Home | Home | 61-73
California State University-Bakersfield | 2008-01-15 00:00:00 | 61-73 Home |  | W |  | Away | 61-73
Idaho State University | 2008-01-17 00:00:00 | 56-54 Away | W | W | Away | Away | 56-54
University of Montana | 2008-01-17 00:00:00 | 56-54 Away |  | W |  | Home | 56-54
Eastern Washington University | 2008-01-17 00:00:00 | 91-85 (1OT) Home | W | W | Home | Home | 91-85
University of Northern Colorado | 2008-01-17 00:00:00 | 91-85 (1OT) Home |  | W |  | Away | 91-85
Idaho State University | 2008-01-19 00:00:00 | 53-74 Away | L | L | Away | Away | 53-74
Montana State University | 2008-01-19 00:00:00 | 53-74 Away |  | W |  | Home | 53-74
California State University-Sacramento | 2008-01-19 00:00:00 | 69-80 Home | L | L | Home | Home | 69-80
Northern Arizona University | 2008-01-19 00:00:00 | 69-80 Home |  | W |  | Away | 69-80
California State University-Sacramento | 2008-01-23 00:00:00 | 56-69 Away | L | L | Away | Away | 56-69
Weber State University | 2008-01-23 00:00:00 | 56-69 Away |  | W |  | Home | 56-69
Eastern Washington University | 2008-01-24 00:00:00 | 61-80 Away | L | L | Away | Away | 61-80
University of Montana | 2008-01-24 00:00:00 | 61-80 Away |  | W |  | Home | 61-80
California State University-Sacramento | 2008-01-25 00:00:00 | 63-86 Away | L | L | Away | Away | 63-86
Idaho State University | 2008-01-25 00:00:00 | 63-86 Away |  | W |  | Home | 63-86
Idaho State University | 2008-01-25 00:00:00 | 86-63 Home | W | W | Home | Home | 86-63
California State University-Sacramento | 2008-01-25 00:00:00 | 86-63 Home |  | W |  | Away | 86-63
Eastern Washington University | 2008-01-26 00:00:00 | 69-74 Away | L | L | Away | Away | 69-74
Montana State University | 2008-01-26 00:00:00 | 69-74 Away |  | W |  | Home | 69-74
Idaho State University | 2008-01-27 00:00:00 | 69-67 Home | W | W | Home | Home | 69-67
Northern Arizona University | 2008-01-27 00:00:00 | 69-67 Home |  | W |  | Away | 69-67
Idaho State University | 2008-01-31 00:00:00 | 57-59 Away | L | L | Away | Away | 57-59
Weber State University | 2008-01-31 00:00:00 | 57-59 Away |  | W |  | Home | 57-59
Eastern Washington University | 2008-01-31 00:00:00 | 57-64 Home | L | L | Home | Home | 57-64
Montana State University | 2008-01-31 00:00:00 | 57-64 Home |  | W |  | Away | 57-64
Idaho State University | 2008-02-02 00:00:00 | 63-59 Home | W | W | Home | Home | 63-59
Weber State University | 2008-02-02 00:00:00 | 63-59 Home |  | W |  | Away | 63-59
California State University-Sacramento | 2008-02-02 00:00:00 | 74-70 Home | W | W | Home | Home | 74-70
University of Northern Colorado | 2008-02-02 00:00:00 | 74-70 Home |  | W |  | Away | 74-70
Eastern Washington University | 2008-02-03 00:00:00 | 57-59 Home | L | L | Home | Home | 57-59
University of Montana | 2008-02-03 00:00:00 | 57-59 Home |  | W |  | Away | 57-59
California State University-Sacramento | 2008-02-07 00:00:00 | 57-59 Home | L | L | Home | Home | 57-59
Eastern Washington University | 2008-02-07 00:00:00 | 57-59 Home |  | W |  | Away | 57-59
Eastern Washington University | 2008-02-07 00:00:00 | 59-57 Away | W | W | Away | Away | 59-57
California State University-Sacramento | 2008-02-07 00:00:00 | 59-57 Away |  | W |  | Home | 59-57
Idaho State University | 2008-02-07 00:00:00 | 66-76 Home | L | L | Home | Home | 66-76
University of Northern Colorado | 2008-02-07 00:00:00 | 66-76 Home |  | W |  | Away | 66-76
California State University-Sacramento | 2008-02-09 00:00:00 | 56-79 Home | L | L | Home | Home | 56-79
Portland State University | 2008-02-09 00:00:00 | 56-79 Home |  | W |  | Away | 56-79
Eastern Washington University | 2008-02-10 00:00:00 | 64-68 Away | L | L | Away | Away | 64-68
Northern Arizona University | 2008-02-10 00:00:00 | 64-68 Away |  | W |  | Home | 64-68
California State University-Sacramento | 2008-02-14 00:00:00 | 57-90 Away | L | L | Away | Away | 57-90
University of Montana | 2008-02-14 00:00:00 | 57-90 Away |  | W |  | Home | 57-90
Idaho State University | 2008-02-14 00:00:00 | 58-81 Away | L | L | Away | Away | 58-81
Portland State University | 2008-02-14 00:00:00 | 58-81 Away |  | W |  | Home | 58-81
Eastern Washington University | 2008-02-14 00:00:00 | 69-57 Home | W | W | Home | Home | 69-57
Weber State University | 2008-02-14 00:00:00 | 69-57 Home |  | W |  | Away | 69-57
Idaho State University | 2008-02-16 00:00:00 | 53-63 Away | L | L | Away | Away | 53-63
Eastern Washington University | 2008-02-16 00:00:00 | 53-63 Away |  | W |  | Home | 53-63
Eastern Washington University | 2008-02-16 00:00:00 | 63-53 Home | W | W | Home | Home | 63-53
Idaho State University | 2008-02-16 00:00:00 | 63-53 Home |  | W |  | Away | 63-53
California State University-Sacramento | 2008-02-17 00:00:00 | 82-87 Away | L | L | Away | Away | 82-87
Montana State University | 2008-02-17 00:00:00 | 82-87 Away |  | W |  | Home | 82-87
California State University-Sacramento | 2008-02-21 00:00:00 | 59-73 Away | L | L | Away | Away | 59-73
Northern Arizona University | 2008-02-21 00:00:00 | 59-73 Away |  | W |  | Home | 59-73
Eastern Washington University | 2008-02-23 00:00:00 | 66-79 Away | L | L | Away | Away | 66-79
University of Northern Colorado | 2008-02-23 00:00:00 | 66-79 Away |  | W |  | Home | 66-79
Idaho State University | 2008-02-24 00:00:00 | 63-72 Home | L | L | Home | Home | 63-72
University of Montana | 2008-02-24 00:00:00 | 63-72 Home |  | W |  | Away | 63-72
California State University-Sacramento | 2008-02-28 00:00:00 | 51-52 Home | L | L | Home | Home | 51-52
Idaho State University | 2008-02-28 00:00:00 | 51-52 Home |  | W |  | Away | 51-52
Idaho State University | 2008-02-28 00:00:00 | 52-51 Away | W | W | Away | Away | 52-51
California State University-Sacramento | 2008-02-28 00:00:00 | 52-51 Away |  | W |  | Home | 52-51
Idaho State University | 2008-03-01 00:00:00 | 53-76 Away | L | L | Away | Away | 53-76
Northern Arizona University | 2008-03-01 00:00:00 | 53-76 Away |  | W |  | Home | 53-76
California State University-Sacramento | 2008-03-01 00:00:00 | 77-83 Away | L | L | Away | Away | 77-83
University of California-Davis | 2008-03-01 00:00:00 | 77-83 Away |  | W |  | Home | 77-83
California State University-Sacramento | 2008-03-03 00:00:00 | 69-89 Home | L | L | Home | Home | 69-89
Weber State University | 2008-03-03 00:00:00 | 69-89 Home |  | W |  | Away | 69-89
Eastern Washington University | 2008-03-04 00:00:00 | 74-76 Away | L | L | Away | Away | 74-76
Portland State University | 2008-03-04 00:00:00 | 74-76 Away |  | W |  | Home | 74-76
Idaho State University | 2008-03-08 00:00:00 | (#4)67-(#5)65 (Big Sky Quarterfinals) | W | W | als) | Neither | (#4)67-(#5)65
University of Montana | 2008-03-08 00:00:00 | (#4)67-(#5)65 (Big Sky Quarterfinals) |  | W |  | Neither | (#4)67-(#5)65
Idaho State University | 2008-03-11 00:00:00 | (#4)61-(#1)72 (Big Sky Semifinals) | L | L | als) | Neither | (#4)61-(#1)72
Portland State University | 2008-03-11 00:00:00 | (#4)61-(#1)72 (Big Sky Semifinals) |  | W |  | Neither | (#4)61-(#1)72
Eastern Washington University | 2008-11-14 00:00:00 | 50-66 Away | L | L | Away | Away | 50-66
University of Illinois | 2008-11-14 00:00:00 | 50-66 Away |  | W |  | Home | 50-66
California State University-Sacramento | 2008-11-14 00:00:00 | 65-77 Away | L | L | Away | Away | 65-77
California State University-Fresno | 2008-11-14 00:00:00 | 65-77 Away |  | W |  | Home | 65-77
Idaho State University | 2008-11-17 00:00:00 | 64-67 Away | L | L | Away | Away | 64-67
University of Hawaii-Manoa | 2008-11-17 00:00:00 | 64-67 Away |  | W |  | Home | 64-67
California State University-Sacramento | 2008-11-18 00:00:00 | 49-61 Away | L | L | Away | Away | 49-61
University of California-Riverside | 2008-11-18 00:00:00 | 49-61 Away |  | W |  | Home | 49-61
Eastern Washington University | 2008-11-19 00:00:00 | 74-69 Away | W | W | Away | Away | 74-69
University of California-Irvine | 2008-11-19 00:00:00 | 74-69 Away |  | W |  | Home | 74-69