Spreadsheet: 525170d1498574934-formula-to-transfer-data-from-one-range-of-cells-to-another-based-on-conditions-working-2
Sheet: Sheet1 (2)

GAME SCORE HISTORY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STATISTICS
GAMES |  | TEAMS |  |  |  |  |  |  | SCORES |  |  |  |  | TOTALS |  |  | MATCH-UP 1 |  |  |  |  |  | MATCH-UP 2 |  |  |  |  |  | MATCH-UP 3 |  |  |  |  |  | MATCH-UP 4 |  |  |  |  |  | BASIC
Game # | Year | Seed A | Team 1 | Conference 1 | vs. | Seed B | Team 2 | Conference 2 | Seed 1/16 Score | Seed 8/9 Score | OT | Margin of Victory | Column1 | Year | Upset | Helper | Seed | Underdog | Seed | Favorite | Score |  | Seed | Underdog | Seed | Favorite | Score |  | Seed | Underdog | Seed | Favorite | Score |  | Seed | Underdog | Seed | Favorite | Score |  | Total Tourneys
1 | 1985 | 1 | St. John's |  | vs. | 9 | Arkansas |  | 68 | 65 |  |  |  | 1985 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Games/Yr | 4
2 | 1985 | 1 | Georgetown |  | vs. | 8 | Temple |  | 75 | 69 |  |  |  | 1986
3 | 1985 | 1 | Oklahoma |  | vs. | 9 | Illinois State |  | 63 | 46 |  |  |  | 1987
4 | 1985 | 1 | Michigan |  | vs. | 8 | Villanova |  | 51 | 49 |  |  |  | 1988 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APPEARANCES BY SEED
5 | 1986 | 16 | Kentucky |  | vs. | 8 | Western Kentucky |  | 71 | 64 |  |  | 1 | 1989 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount | Total % of Appearances | Total % of Non-Appearances | [NAME]
6 | 1986 | 1 | St. John's |  | vs. | 8 | Auburn |  | 65 | 81 |  |  | 1 | 1990
7 | 1986 | 1 | Duke |  | vs. | 8 | Old Dominion |  | 89 | 90 |  |  | 1 | 1991 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st Seed
8 | 1986 | 1 | Kansas |  | vs. | 9 | Temple |  | 65 | 70 |  |  | 1 | 1992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16th Seed
9 | 1987 | 1 | UNLV |  | vs. | 9 | Kansas State |  | 80 | 61 |  |  |  | 1993 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8th Seed
10 | 1987 | 1 | Indiana |  | vs. | 8 | Auburn |  | 107 | 90 |  |  |  | 1994 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9th Seed
11 | 1987 | 1 | Georgetown |  | vs. | 9 | Ohio State |  | 82 | 79 |  |  |  | 1995
12 | 1987 | 1 | North Carolina |  | vs. | 9 | Michigan |  | 109 | 97 |  |  |  | 1996
13 | 1988 | 1 | Purdue |  | vs. | 9 | Memphis State |  | 100 | 73 |  |  |  | 1997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATCH-UPS
14 | 1988 | 1 | Temple |  | vs. | 8 | Georgetown |  | 74 | 53 |  |  |  | 1998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount | Total % of Meeting | Total % of Non-Meeting | [NAME]
15 | 1988 | 1 | Arizona |  | vs. | 8 | [NAME] |  | 84 | 55 |  |  |  | 1999
16 | 1988 | 1 | Oklahoma |  | vs. | 8 | Auburn |  | 107 | 87 |  |  |  | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 vs 8
17 | 1989 | 1 | Illinois |  | vs. | 9 | [NAME] |  | 72 | 60 |  |  |  | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 vs 9
18 | 1989 | 1 | Oklahoma |  | vs. | 9 | Louisiana Tech |  | 124 | 81 |  |  |  | 2002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 vs 8
19 | 1989 | 1 | Georgetown |  | vs. | 9 | Notre Dame |  | 81 | 74 |  |  |  | 2003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 vs 9
20 | 1989 | 1 | Arizona |  | vs. | 9 | Clemson |  | 94 | 68 |  |  |  | 2004
21 | 1990 | 1 | Michigan State |  | vs. | 9 | UC Santa Barbara |  | 62 | 58 |  |  |  | 2005
22 | 1990 | 1 | UNLV |  | vs. | 8 | Ohio State |  | 76 | 65 |  |  |  | 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UPSETS BY SEED
23 | 1990 | 1 | Uconn |  | vs. | 9 | California |  | 74 | 54 |  |  |  | 2007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount | Total % of Upsets by Seed | Total % of Non-Upsets by Seed
24 | 1990 | 1 | Oklahoma |  | vs. | 8 | North Carolina |  | 77 | 79 |  |  |  | 2008
25 | 1991 | 1 | UNLV |  | vs. | 8 | Georgetown |  | 62 | 54 |  |  |  | 2009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16th Seed
26 | 1991 | 1 | Ohio State |  | vs. | 8 | Georgia Tech |  | 65 | 61 |  |  |  | 2010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8th Seed
27 | 1991 | 1 | North Carolina |  | vs. | 9 | Villanova |  | 84 | 69 |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9th Seed
28 | 1991 | 1 | Arkansas |  | vs. | 8 | Arizona State |  | 97 | 90 |  |  |  | 2012
29 | 1992 | 1 | Kansas |  | vs. | 9 | UTEP |  | 60 | 66 |  |  |  | 2013
30 | 1992 | 1 | Ohio State |  | vs. | 9 | Uconn |  | 78 | 55 |  |  |  | 2014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GENERAL UPSET INFORMATION
31 | 1992 | 1 | Duke |  | vs. | 9 | Iowa |  | 75 | 62 |  |  |  | 2015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total % of Upsets | Total % of non Upsets | Total % of Years w/Upsets
32 | 1992 | 1 | UCLA |  | vs. | 8 | Louisville |  | 85 | 69 |  |  |  | 2016
33 | 1993 | 1 | Kentucky |  | vs. | 8 | Utah |  | 83 | 62 |  |  |  | 2017 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Upsets
34 | 1993 | 1 | Michigan |  | vs. | 9 | UCLA |  | 86 | 84 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Yrs w/Upsets
35 | 1993 | 1 | North Carolina |  | vs. | 8 | Rhode Island |  | 112 | 67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Most Upsets/Yr
36 | 1993 | 1 | Indiana |  | vs. | 9 | Xavier |  | 73 | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
37 | 1994 | 1 | Missouri |  | vs. | 9 | Wisconsin |  | 109 | 96
38 | 1994 | 1 | Arkansas |  | vs. | 9 | Georgetown |  | 85 | 73
39 | 1994 | 1 | North Carolina |  | vs. | 9 | Boston College |  | 72 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UPSET TYPE INFORMATION
40 | 1994 | 1 | Purdue |  | vs. | 9 | Alabama |  | 83 | 73 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Total Games | % of Total Tourney Years
41 | 1995 | 1 | Kansas |  | vs. | 8 | Western Kentucky |  | 75 | 70
42 | 1995 | 1 | Kentucky |  | vs. | 9 | Tulane |  | 82 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Single Game Upsets
43 | 1995 | 1 | Wake Forest |  | vs. | 9 | St. Louis |  | 64 | 59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Double Game Upsets
44 | 1995 | 1 | UCLA |  | vs. | 8 | Missouri |  | 75 | 74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Triple Game Upsets
45 | 1996 | 1 | Umass |  | vs. | 9 | Stanford |  | 79 | 74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Quadruple Game Upsets
46 | 1996 | 1 | Uconn |  | vs. | 9 | Eastern Michigan |  | 95 | 81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Upset
47 | 1996 | 1 | Kentucky |  | vs. | 9 | [NAME] |  | 84 | 60
48 | 1996 | 1 | Purdue |  | vs. | 8 | Georgia |  | 69 | 76
49 | 1997 | 1 | North Carolina |  | vs. | 9 | Colorado |  | 73 | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROBABILITIES |  |  | TIME BETWEEN UPSETS
50 | 1997 | 1 | Kansas |  | vs. | 8 | Purdue |  | 75 | 61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean |  |  | Start | End | Entry
51 | 1997 | 1 | Minnesota |  | vs. | 9 | Temple |  | 76 | 57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard Deviation |  |  | 1985 |  | 1
52 | 1997 | 1 | Kentucky |  | vs. | 8 | Iowa |  | 75 | 69 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X Value | -1
53 | 1998 | 1 | North Carolina |  | vs. | 8 | Charlotte |  | 93 | 83 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upset Probability |  |  | Avg. Yrs Between Upsets
54 | 1998 | 1 | Arizona |  | vs. | 9 | Illinois State |  | 82 | 49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upset Probability %
55 | 1998 | 1 | Kansas |  | vs. | 8 | Rhode Island |  | 80 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Projected Upsets
56 | 1998 | 1 | Duke |  | vs. | 8 | Oklahoma State |  | 79 | 73 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Upsets |  |  | Avg. [NAME]
57 | 1999 | 1 | Auburn |  | vs. | 9 | Oklahoma State |  | 81 | 74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Difference
58 | 1999 | 1 | Uconn |  | vs. | 9 | New Mexico |  | 78 | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Single Upset
59 | 1999 | 1 | Michigan State |  | vs. | 9 | Ole Miss |  | 74 | 66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chance of Upset (1 out of _ Games) |  |  |  | Double Upset
60 | 1999 | 1 | Duke |  | vs. | 9 | Tulsa |  | 97 | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Triple Upset
61 | 2000 | 1 | Stanford |  | vs. | 8 | North Carolina |  | 60 | 53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quadruple Upset
62 | 2000 | 1 | Duke |  | vs. | 8 | Kansas State |  | 69 | 64
63 | 2000 | 1 | Arizona |  | vs. | 8 | Wisconsin |  | 59 | 66
64 | 2000 | 1 | Michigan State |  | vs. | 8 | Utah |  | 73 | 61
65 | 2001 | 1 | Duke |  | vs. | 9 | Missouri |  | 94 | 81
66 | 2001 | 1 | Stanford |  | vs. | 9 | St. Joseph's |  | 90 | 83
67 | 2001 | 1 | Michigan State |  | vs. | 9 | Fresno State |  | 81 | 65
68 | 2001 | 1 | Illinois |  | vs. | 9 | Charlotte |  | 79 | 61
69 | 2002 | 1 | Duke |  | vs. | 8 | Notre Dame |  | 84 | 77
70 | 2002 | 1 | Cincinatti |  | vs. | 8 | UCLA |  | 105 | 101 | YY
71 | 2002 | 1 | Maryland |  | vs. | 8 | Wisconsin |  | 87 | 57
72 | 2002 | 1 | Kansas |  | vs. | 8 | Stanford |  | 86 | 63
73 | 2003 | 1 | Kentucky |  | vs. | 9 | Utah |  | 74 | 54
74 | 2003 | 1 | Arizona |  | vs. | 9 | Gonzaga |  | 96 | 95 | YY
75 | 2003 | 1 | Texas |  | vs. | 9 | Purdue |  | 77 | 67
76 | 2003 | 1 | Oklahoma |  | vs. | 8 | California |  | 74 | 65
77 | 2004 | 1 | Kentucky |  | vs. | 9 | UAB |  | 75 | 76
78 | 2004 | 1 | St. Joseph's |  | vs. | 8 | Texas Tech |  | 70 | 65
79 | 2004 | 1 | Duke |  | vs. | 8 | [NAME] |  | 90 | 62
80 | 2004 | 1 | Stanford |  | vs. | 8 | Alabama |  | 67 | 70
81 | 2005 | 1 | North Carolina |  | vs. | 9 | Iowa State |  | 92 | 65
82 | 2005 | 1 | Duke |  | vs. | 9 | Mississippi State |  | 63 | 55
83 | 2005 | 1 | Illinois |  | vs. | 9 | Nevada |  | 71 | 59
84 | 2005 | 1 | Washington |  | vs. | 8 | Pacific |  | 97 | 79
85 | 2006 | 1 | Uconn |  | vs. | 8 | Kentucky |  | 67 | 64
86 | 2006 | 1 | Villanova |  | vs. | 8 | Arizona |  | 82 | 78
87 | 2006 | 1 | Duke |  | vs. | 8 | [NAME] |  | 74 | 61
88 | 2006 | 1 | Memphis |  | vs. | 9 | Bucknell |  | 72 | 56
89 | 2007 | 1 | Florida |  | vs. | 9 | Purdue |  | 74 | 67
90 | 2007 | 1 | Kansas |  | vs. | 8 | Kentucky |  | 88 | 76
91 | 2007 | 1 | North Carolina |  | vs. | 9 | Michigan State |  | 81 | 67
92 | 2007 | 1 | Ohio State |  | vs. | 9 | Xavier |  | 78 | 71 | Y
93 | 2008 | 1 | North Carolina |  | vs. | 9 | Arkansas |  | 108 | 77
94 | 2008 | 1 | Kansas |  | vs. | 8 | UNLV |  | 75 | 56
95 | 2008 | 1 | Memphis |  | vs. | 8 | Mississippi State |  | 77 | 74
96 | 2008 | 1 | UCLA |  | vs. | 9 | Texas A&M |  | 51 | 49
97 | 2009 | 1 | Pittsburgh |  | vs. | 8 | Oklahoma State |  | 84 | 76
98 | 2009 | 1 | North Carolina |  | vs. | 8 | LSU |  | 84 | 70
99 | 2009 | 1 | Louisville |  | vs. | 9 | Siena |  | 79 | 72
100 | 2009 | 1 | Uconn |  | vs. | 9 | Texas A&M |  | 92 | 66
101 | 2010 | 1 | Kansas |  | vs. | 9 | Northern Iowa |  | 67 | 69
102 | 2010 | 1 | Syracuse |  | vs. | 8 | Gonzaga |  | 87 | 65
103 | 2010 | 1 | Kentucky |  | vs. | 9 | Wake Forest |  | 90 | 60
104 | 2010 | 1 | Duke |  | vs. | 8 | California |  | 68 | 53
105 | 2011 | 1 | Ohio State |  | vs. | 8 | [NAME] |  | 98 | 66
106 | 2011 | 1 | Duke |  | vs. | 8 | Michigan |  | 73 | 71
107 | 2011 | 1 | Pittsburgh |  | vs. | 8 | Butler |  | 70 | 71
108 | 2011 | 1 | Kansas |  | vs. | 9 | Illinois |  | 73 | 59
109 | 2012 | 1 | Kentucky |  | vs. | 8 | Iowa State |  | 87 | 71
110 | 2012 | 1 | Michigan State |  | vs. | 9 | St. Louis |  | 65 | 61
111 | 2012 | 1 | Syracuse |  | vs. | 8 | Kansas State |  | 75 | 59
112 | 2012 | 1 | North Carolina |  | vs. | 8 | Creighton |  | 87 | 73
113 | 2013 | 1 | Louisville |  | vs. | 8 | Colorado State |  | 82 | 56
114 | 2013 | 1 | Gonzaga |  | vs. | 9 | Wichita State |  | 70 | 76
115 | 2013 | 1 | Kansas |  | vs. | 8 | North Carolina |  | 70 | 58
116 | 2013 | 1 | Indiana |  | vs. | 9 | Temple |  | 58 | 52
117 | 2014 | 1 | Florida |  | vs. | 9 | Pittsburgh |  | 61 | 45
118 | 2014 | 1 | Virginia |  | vs. | 8 | Memphis |  | 78 | 60
119 | 2014 | 1 | Arizona |  | vs. | 8 | Gonzaga |  | 84 | 61
120 | 2014 | 1 | Wichita State |  | vs. | 8 | Kentucky |  | 76 | 78
121 | 2015 | 1 | Kentucky |  | vs. | 8 | Cincinatti |  | 64 | 51
122 | 2015 | 1 | Wisconsin |  | vs. | 8 | Oregon |  | 72 | 65
123 | 2015 | 1 | Villanova |  | vs. | 8 | NC State |  | 68 | 71
124 | 2015 | 1 | Duke |  | vs. | 8 | San Diego State |  | 68 | 49
125 | 2016 | 1 | Kansas |  | vs. | 9 | Uconn |  | 73 | 61
126 | 2016 | 1 | Oregon |  | vs. | 8 | St. Joseph's |  | 69 | 64
127 | 2016 | 1 | North Carolina |  | vs. | 9 | Providence |  | 85 | 66
128 | 2016 | 1 | Virginia |  | vs. | 9 | Butler |  | 77 | 69
129 | 2017 | 1 | Villanova |  | vs. | 8 | Wisconsin |  | 62 | 65
130 | 2017 | 1 | Gonzaga |  | vs. | 8 | Northwestern |  | 79 | 73
131 | 2017 | 1 | Kansas |  | vs. | 9 | Michigan State |  | 90 | 70
132 | 2017 | 1 | North Carolina |  | vs. | 8 | Arkansas |  | 72 | 65