Spreadsheet: 97074d1296273413-winning-losing-streak-without-dates-in-order-basketballstats
Sheet:  Pivots Advanced Filters

Team | Date | Score | A/H/N | Win/Loss |  |  |  |  |  |  |  |  |  |  | Team | Date | Score | A/H/N | Win/Loss
Idaho State University | 2007-02-21 00:00:00 | 64-49 | Home | W |  |  |  |  |  |  |  |  |  |  | Idaho State University
Montana State University | 2007-02-21 00:00:00 | 64-49 | Away | W |  |  | Count of Win/Loss |  |  | Win/Loss
Eastern Washington University | 2007-11-09 00:00:00 | 41-68 | Away | L |  |  | Team | Years | Date | L | W | Grand Total
Washington State University | 2007-11-09 00:00:00 | 41-68 | Home | W |  |  | California State University-Sacramento | 2007 | Nov | 5 | 2 | 7 |  |  | Team | Date | Score | A/H/N | Win/Loss
Idaho State University | 2007-11-09 00:00:00 | 43-58 | Away | L |  |  |  |  | Dec | 3 | 1 | 4 |  |  | Idaho State University | 2007-02-21 00:00:00 | 64-49 | Home | W
University of Iowa | 2007-11-09 00:00:00 | 43-58 | Home | W |  |  |  | 2008 | Jan | 7 | 3 | 10 |  |  | Idaho State University | 2007-11-09 00:00:00 | 43-58 | Away | L
California State University-Sacramento | 2007-11-09 00:00:00 | 63-94 | Away | L |  |  |  |  | Feb | 6 | 3 | 9 |  |  | Idaho State University | 2007-11-14 00:00:00 | 69-90 | Away | L
Kansas State University | 2007-11-09 00:00:00 | 63-94 | Home | W |  |  |  |  | Mar | 2 |  | 2 |  |  | Idaho State University | 2007-11-17 00:00:00 | 61-66 | Away | L
California State University-Sacramento | 2007-11-12 00:00:00 | 104-71 | Home | W |  |  |  |  | Nov | 2 |  | 2 |  |  | Idaho State University | 2007-11-23 00:00:00 | 41-56 | Away | L
Simpson College | 2007-11-12 00:00:00 | 104-71 | Away | W |  |  | California State University-Sacramento Total |  |  | 25 | 9 | 34 |  |  | Idaho State University | 2007-11-24 00:00:00 | 52-76 | Away | L
Eastern Washington University | 2007-11-12 00:00:00 | 57-92 | Away | L |  |  | Eastern Washington University | 2007 | Nov | 6 | 2 | 8 |  |  | Idaho State University | 2007-12-01 00:00:00 | 71-69 | Away | W
University of New Mexico | 2007-11-12 00:00:00 | 57-92 | Home | W |  |  |  |  | Dec | 2 | 3 | 5 |  |  | Idaho State University | 2007-12-05 00:00:00 | 61-93 | Home | L
California State University-Sacramento | 2007-11-14 00:00:00 | 53-57 | Home | W |  |  |  | 2008 | Jan | 6 | 4 | 10 |  |  | Idaho State University | 2007-12-15 00:00:00 | 49-89 | Away | L
Southern Utah University | 2007-11-14 00:00:00 | 53-57 | Away | W |  |  |  |  | Feb | 3 | 5 | 8 |  |  | Idaho State University | 2007-12-23 00:00:00 | 45-75 | Home | L
Idaho State University | 2007-11-14 00:00:00 | 69-90 | Away | L |  |  |  |  | Mar | 1 |  | 1 |  |  | Idaho State University | 2007-12-27 00:00:00 | 51-68 | Away | L
[NAME] | 2007-11-14 00:00:00 | 69-90 | Home | W |  |  |  |  | Nov | 1 | 1 | 2 |  |  | Idaho State University | 2007-12-29 00:00:00 | 71-66 | Home | W
Eastern Washington University | 2007-11-15 00:00:00 | 59-51 | Home | W |  |  | Eastern Washington University Total |  |  | 19 | 15 | 34 |  |  | Idaho State University | 2007-12-31 00:00:00 | 50-82 | Away | L
University of California-Riverside | 2007-11-15 00:00:00 | 59-51 | Away | W |  |  | Idaho State University | 2007 | Feb |  | 1 | 1 |  |  | Idaho State University | 2008-01-03 00:00:00 | 76-65 | Away | W
Idaho State University | 2007-11-17 00:00:00 | 61-66 | Away | L |  |  |  |  | Nov | 5 |  | 5 |  |  | Idaho State University | 2008-01-10 00:00:00 | 56-58 | Home | W
California State University-Long Beach | 2007-11-17 00:00:00 | 61-66 | Home | W |  |  |  |  | Dec | 5 | 2 | 7 |  |  | Idaho State University | 2008-01-10 00:00:00 | 58-56 | Home | W
California State University-Sacramento | 2007-11-17 00:00:00 | 63-93 | Away | L |  |  |  | 2008 | Jan | 3 | 7 | 10 |  |  | Idaho State University | 2008-01-13 00:00:00 | 61-71 | Home | L
University of San Francisco | 2007-11-17 00:00:00 | 63-93 | Home | W |  |  |  |  | Feb | 4 | 4 | 8 |  |  | Idaho State University | 2008-01-17 00:00:00 | 56-54 | Away | W
Eastern Washington University | 2007-11-18 00:00:00 | 68-82 | Away | L |  |  |  |  | Mar | 2 | 1 | 3 |  |  | Idaho State University | 2008-01-19 00:00:00 | 53-74 | Away | L
University of Washington | 2007-11-18 00:00:00 | 68-82 | Home | W |  |  |  |  | Nov | 1 |  | 1 |  |  | Idaho State University | 2008-01-25 00:00:00 | 63-86 | Home | W
California State University-Sacramento | 2007-11-21 00:00:00 | 62-75 | Away | L |  |  | Idaho State University Total |  |  | 20 | 15 | 35 |  |  | Idaho State University | 2008-01-25 00:00:00 | 86-63 | Home | W
Pacific University-California | 2007-11-21 00:00:00 | 62-75 | Home | W |  |  | Grand Total |  |  | 64 | 39 | 103 |  |  | Idaho State University | 2008-01-27 00:00:00 | 69-67 | Home | W
Eastern Washington University | 2007-11-22 00:00:00 | 52-69 | Neither | L |  |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-01-31 00:00:00 | 57-59 | Away | L
Virginia Institute of Technology | 2007-11-22 00:00:00 | 52-69 | Neither | W |  |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-02-02 00:00:00 | 63-59 | Home | W
Idaho State University | 2007-11-23 00:00:00 | 41-56 | Away | L |  |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-02-07 00:00:00 | 66-76 | Home | L
Oregon State University | 2007-11-23 00:00:00 | 41-56 | Home | W |  |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-02-14 00:00:00 | 58-81 | Away | L
Eastern Washington University | 2007-11-23 00:00:00 | 53-61 | Neither | L | This data is now in a TABLE/LIST and ready to let Excel show its power |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-02-16 00:00:00 | 53-63 | Away | L
University of Michigan | 2007-11-23 00:00:00 | 53-61 | Neither | W | Above is a Pivot Table filtered to only show your 3 teams |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-02-16 00:00:00 | 63-53 | Away | W
Idaho State University | 2007-11-24 00:00:00 | 52-76 | Away | L | Grouped by Year and Month and Columns of Loss and Wins |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-02-24 00:00:00 | 63-72 | Home | L
University of Portland | 2007-11-24 00:00:00 | 52-76 | Home | W |  | I think you could do by [NAME] but I'd have to think about that |  |  |  |  |  |  |  |  | Idaho State University | 2008-02-28 00:00:00 | 51-52 | Away | W
Eastern Washington University | 2007-11-24 00:00:00 | 64-62 | Neither | W |  |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-02-28 00:00:00 | 52-51 | Away | W
University of Alaska-Anchorage | 2007-11-24 00:00:00 | 64-62 | Neither | W | To the right is an Advanced Filter of the data on the left to allow win streaks to be calculated. |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-03-01 00:00:00 | 53-76 | Away | L
California State University-Sacramento | 2007-11-25 00:00:00 | 65-77 | Home | L |  |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-03-08 00:00:00 | (#4)67-(#5)65 | Neither | W
Santa Clara University | 2007-11-25 00:00:00 | 65-77 | Away | W |  |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-03-11 00:00:00 | (#4)61-(#1)72 | Neither | L
California State University-Sacramento | 2007-11-27 00:00:00 | 58-84 | Away | L |  |  |  |  |  |  |  |  |  |  | Idaho State University | 2008-11-17 00:00:00 | 64-67 | Away | L
Stanford University | 2007-11-27 00:00:00 | 58-84 | Home | W
Eastern Washington University | 2007-11-29 00:00:00 | 57-66 | Home | L
Santa Clara University | 2007-11-29 00:00:00 | 57-66 | Away | W
Idaho State University | 2007-12-01 00:00:00 | 71-69 | Away | W
University of Idaho | 2007-12-01 00:00:00 | 71-69 | Home | W
Eastern Washington University | 2007-12-03 00:00:00 | 65-54 | Away | W
University of Missouri-Kansas City | 2007-12-03 00:00:00 | 65-54 | Home | W
California State University-Sacramento | 2007-12-04 00:00:00 | 72-54 | Home | W
[NAME] University | 2007-12-04 00:00:00 | 72-54 | Away | W
Eastern Washington University | 2007-12-05 00:00:00 | 47-85 | Away | L
University of Kansas | 2007-12-05 00:00:00 | 47-85 | Home | W
Idaho State University | 2007-12-05 00:00:00 | 61-93 | Home | L
Boise State University | 2007-12-05 00:00:00 | 61-93 | Away | W
Eastern Washington University | 2007-12-09 00:00:00 | 49-58 | Away | L
University of Idaho | 2007-12-09 00:00:00 | 49-58 | Home | W
California State University-Sacramento | 2007-12-11 00:00:00 | 66-93 | Away | L
University of Oregon | 2007-12-11 00:00:00 | 66-93 | Home | W
Idaho State University | 2007-12-15 00:00:00 | 49-89 | Away | L
University of California-Los Angeles | 2007-12-15 00:00:00 | 49-89 | Home | W
California State University-Sacramento | 2007-12-15 00:00:00 | 51-82 | Away | L
Marquette University | 2007-12-15 00:00:00 | 51-82 | Home | W
Eastern Washington University | 2007-12-17 00:00:00 | 84-75 | Home | W
University of Portland | 2007-12-17 00:00:00 | 84-75 | Away | W
Eastern Washington University | 2007-12-22 00:00:00 | 58-57 | Home | W
Portland State University | 2007-12-22 00:00:00 | 58-57 | Away | W
Idaho State University | 2007-12-23 00:00:00 | 45-75 | Home | L
Washington State University | 2007-12-23 00:00:00 | 45-75 | Away | W
Idaho State University | 2007-12-27 00:00:00 | 51-68 | Away | L
University of Utah | 2007-12-27 00:00:00 | 51-68 | Home | W
California State University-Sacramento | 2007-12-28 00:00:00 | 60-74 | Away | L
University of Northern Colorado | 2007-12-28 00:00:00 | 60-74 | Home | W
Idaho State University | 2007-12-29 00:00:00 | 71-66 | Home | W
Northwest Nazarene College | 2007-12-29 00:00:00 | 71-66 | Away | W
Idaho State University | 2007-12-31 00:00:00 | 50-82 | Away | L
University of Washington | 2007-12-31 00:00:00 | 50-82 | Home | W
California State University-Sacramento | 2008-01-03 00:00:00 | 58-83 | Away | L
Portland State University | 2008-01-03 00:00:00 | 58-83 | Home | W
Eastern Washington University | 2008-01-03 00:00:00 | 75-79 | Home | L
Northern Arizona University | 2008-01-03 00:00:00 | 75-79 | Away | W
Idaho State University | 2008-01-03 00:00:00 | 76-65 | Away | W
University of Northern Colorado | 2008-01-03 00:00:00 | 76-65 | Home | W
California State University-Sacramento | 2008-01-05 00:00:00 | 52-76 | Away | L
Eastern Washington University | 2008-01-05 00:00:00 | 52-76 | Home | W
Eastern Washington University | 2008-01-05 00:00:00 | 76-52 | Home | W
California State University-Sacramento | 2008-01-05 00:00:00 | 76-52 | Away | W
Eastern Washington University | 2008-01-10 00:00:00 | 56-58 | Away | L
Idaho State University | 2008-01-10 00:00:00 | 56-58 | Home | W
Idaho State University | 2008-01-10 00:00:00 | 58-56 | Home | W
Eastern Washington University | 2008-01-10 00:00:00 | 58-56 | Away | W
California State University-Sacramento | 2008-01-10 00:00:00 | 78-77 | Home | W
Montana State University | 2008-01-10 00:00:00 | 78-77 | Away | W
Eastern Washington University | 2008-01-12 00:00:00 | 64-74 | Away | L
Weber State University | 2008-01-12 00:00:00 | 64-74 | Home | W
California State University-Sacramento | 2008-01-12 00:00:00 | 69-76 | Home | L
University of Montana | 2008-01-12 00:00:00 | 69-76 | Away | W
Idaho State University | 2008-01-13 00:00:00 | 61-71 | Home | L
Portland State University | 2008-01-13 00:00:00 | 61-71 | Away | W
California State University-Sacramento | 2008-01-15 00:00:00 | 61-73 | Home | L
California State University-Bakersfield | 2008-01-15 00:00:00 | 61-73 | Away | W
Idaho State University | 2008-01-17 00:00:00 | 56-54 | Away | W
University of Montana | 2008-01-17 00:00:00 | 56-54 | Home | W
Eastern Washington University | 2008-01-17 00:00:00 | 91-85 | Home | W
University of Northern Colorado | 2008-01-17 00:00:00 | 91-85 | Away | W
Idaho State University | 2008-01-19 00:00:00 | 53-74 | Away | L
Montana State University | 2008-01-19 00:00:00 | 53-74 | Home | W
California State University-Sacramento | 2008-01-19 00:00:00 | 69-80 | Home | L
Northern Arizona University | 2008-01-19 00:00:00 | 69-80 | Away | W
California State University-Sacramento | 2008-01-23 00:00:00 | 56-69 | Away | L
Weber State University | 2008-01-23 00:00:00 | 56-69 | Home | W
Eastern Washington University | 2008-01-24 00:00:00 | 61-80 | Away | L
University of Montana | 2008-01-24 00:00:00 | 61-80 | Home | W
California State University-Sacramento | 2008-01-25 00:00:00 | 63-86 | Away | L
Idaho State University | 2008-01-25 00:00:00 | 63-86 | Home | W
Idaho State University | 2008-01-25 00:00:00 | 86-63 | Home | W
California State University-Sacramento | 2008-01-25 00:00:00 | 86-63 | Away | W
Eastern Washington University | 2008-01-26 00:00:00 | 69-74 | Away | L
Montana State University | 2008-01-26 00:00:00 | 69-74 | Home | W
Idaho State University | 2008-01-27 00:00:00 | 69-67 | Home | W
Northern Arizona University | 2008-01-27 00:00:00 | 69-67 | Away | W
Idaho State University | 2008-01-31 00:00:00 | 57-59 | Away | L
Weber State University | 2008-01-31 00:00:00 | 57-59 | Home | W
Eastern Washington University | 2008-01-31 00:00:00 | 57-64 | Home | L
Montana State University | 2008-01-31 00:00:00 | 57-64 | Away | W
Idaho State University | 2008-02-02 00:00:00 | 63-59 | Home | W
Weber State University | 2008-02-02 00:00:00 | 63-59 | Away | W
California State University-Sacramento | 2008-02-02 00:00:00 | 74-70 | Home | W
University of Northern Colorado | 2008-02-02 00:00:00 | 74-70 | Away | W
Eastern Washington University | 2008-02-03 00:00:00 | 57-59 | Home | L
University of Montana | 2008-02-03 00:00:00 | 57-59 | Away | W
California State University-Sacramento | 2008-02-07 00:00:00 | 57-59 | Home | L
Eastern Washington University | 2008-02-07 00:00:00 | 57-59 | Away | W
Eastern Washington University | 2008-02-07 00:00:00 | 59-57 | Away | W
California State University-Sacramento | 2008-02-07 00:00:00 | 59-57 | Home | W
Idaho State University | 2008-02-07 00:00:00 | 66-76 | Home | L
University of Northern Colorado | 2008-02-07 00:00:00 | 66-76 | Away | W
California State University-Sacramento | 2008-02-09 00:00:00 | 56-79 | Home | L
Portland State University | 2008-02-09 00:00:00 | 56-79 | Away | W
Eastern Washington University | 2008-02-10 00:00:00 | 64-68 | Away | L
Northern Arizona University | 2008-02-10 00:00:00 | 64-68 | Home | W
California State University-Sacramento | 2008-02-14 00:00:00 | 57-90 | Away | L
University of Montana | 2008-02-14 00:00:00 | 57-90 | Home | W
Idaho State University | 2008-02-14 00:00:00 | 58-81 | Away | L
Portland State University | 2008-02-14 00:00:00 | 58-81 | Home | W
Eastern Washington University | 2008-02-14 00:00:00 | 69-57 | Home | W
Weber State University | 2008-02-14 00:00:00 | 69-57 | Away | W
Idaho State University | 2008-02-16 00:00:00 | 53-63 | Away | L
Eastern Washington University | 2008-02-16 00:00:00 | 53-63 | Home | W
Eastern Washington University | 2008-02-16 00:00:00 | 63-53 | Home | W
Idaho State University | 2008-02-16 00:00:00 | 63-53 | Away | W
California State University-Sacramento | 2008-02-17 00:00:00 | 82-87 | Away | L
Montana State University | 2008-02-17 00:00:00 | 82-87 | Home | W
California State University-Sacramento | 2008-02-21 00:00:00 | 59-73 | Away | L
Northern Arizona University | 2008-02-21 00:00:00 | 59-73 | Home | W
Eastern Washington University | 2008-02-23 00:00:00 | 66-79 | Away | L
University of Northern Colorado | 2008-02-23 00:00:00 | 66-79 | Home | W
Idaho State University | 2008-02-24 00:00:00 | 63-72 | Home | L
University of Montana | 2008-02-24 00:00:00 | 63-72 | Away | W
California State University-Sacramento | 2008-02-28 00:00:00 | 51-52 | Home | L
Idaho State University | 2008-02-28 00:00:00 | 51-52 | Away | W
Idaho State University | 2008-02-28 00:00:00 | 52-51 | Away | W
California State University-Sacramento | 2008-02-28 00:00:00 | 52-51 | Home | W
Idaho State University | 2008-03-01 00:00:00 | 53-76 | Away | L
Northern Arizona University | 2008-03-01 00:00:00 | 53-76 | Home | W
California State University-Sacramento | 2008-03-01 00:00:00 | 77-83 | Away | L
University of California-Davis | 2008-03-01 00:00:00 | 77-83 | Home | W
California State University-Sacramento | 2008-03-03 00:00:00 | 69-89 | Home | L
Weber State University | 2008-03-03 00:00:00 | 69-89 | Away | W
Eastern Washington University | 2008-03-04 00:00:00 | 74-76 | Away | L
Portland State University | 2008-03-04 00:00:00 | 74-76 | Home | W
Idaho State University | 2008-03-08 00:00:00 | (#4)67-(#5)65 | Neither | W
University of Montana | 2008-03-08 00:00:00 | (#4)67-(#5)65 | Neither | W
Idaho State University | 2008-03-11 00:00:00 | (#4)61-(#1)72 | Neither | L
Portland State University | 2008-03-11 00:00:00 | (#4)61-(#1)72 | Neither | W
Eastern Washington University | 2008-11-14 00:00:00 | 50-66 | Away | L
University of Illinois | 2008-11-14 00:00:00 | 50-66 | Home | W
California State University-Sacramento | 2008-11-14 00:00:00 | 65-77 | Away | L
California State University-Fresno | 2008-11-14 00:00:00 | 65-77 | Home | W
Idaho State University | 2008-11-17 00:00:00 | 64-67 | Away | L
University of Hawaii-Manoa | 2008-11-17 00:00:00 | 64-67 | Home | W
California State University-Sacramento | 2008-11-18 00:00:00 | 49-61 | Away | L
University of California-Riverside | 2008-11-18 00:00:00 | 49-61 | Home | W
Eastern Washington University | 2008-11-19 00:00:00 | 74-69 | Away | W
University of California-Irvine | 2008-11-19 00:00:00 | 74-69 | Home | W