Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,176
- Office Version
- 365
- 2019
- Platform
- Windows
I have Superbowl data, what I would like to do is pull out all teams who had consecutive wins and the superbowl that it took place. Results Column D and E.
Thanks in advance!
Thanks in advance!
Book11 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | SuperBowl | Winner | |||||
2 | Super Bowl I | Green Bay Packers | Green Bay Packers | I, II | |||
3 | Super Bowl II | Green Bay Packers | Miami Dolphins | VII, VIII | |||
4 | Super Bowl III | New York Jets | Pittsburgh Steelers | IX, X, XIII, XIV | |||
5 | Super Bowl IV | Kansas City Chiefs | San Francisco 49ers | XXIII, XXIV | |||
6 | Super Bowl V | Baltimore Colts | Dallas Cowboys | XXVII, XXVIII | |||
7 | Super Bowl VI | Dallas Cowboys | Denver Broncos | XXXII, XXXIII | |||
8 | Super Bowl VII | Miami Dolphins | New England Patriots | XXXVIII, XXXIX | |||
9 | Super Bowl VIII | Miami Dolphins | |||||
10 | Super Bowl IX | Pittsburgh Steelers | |||||
11 | Super Bowl X | Pittsburgh Steelers | |||||
12 | Super Bowl XI | Oakland Raiders | |||||
13 | Super Bowl XII | Dallas Cowboys | |||||
14 | Super Bowl XIII | Pittsburgh Steelers | |||||
15 | Super Bowl XIV | Pittsburgh Steelers | |||||
16 | Super Bowl XV | Oakland Raiders | |||||
17 | Super Bowl XVI | San Francisco 49ers | |||||
18 | Super Bowl XVII | Washington Redskins | |||||
19 | Super Bowl XVIII | Los Angeles Raiders | |||||
20 | Super Bowl XIX | San Francisco 49ers | |||||
21 | Super Bowl XX | Chicago Bears | |||||
22 | Super Bowl XXI | New York Giants | |||||
23 | Super Bowl XXII | Washington Redskins | |||||
24 | Super Bowl XXIII | San Francisco 49ers | |||||
25 | Super Bowl XXIV | San Francisco 49ers | |||||
26 | Super Bowl XXV | New York Giants | |||||
27 | Super Bowl XXVI | Washington Redskins | |||||
28 | Super Bowl XXVII | Dallas Cowboys | |||||
29 | Super Bowl XXVIII | Dallas Cowboys | |||||
30 | Super Bowl XXIX | San Francisco 49ers | |||||
31 | Super Bowl XXX | Dallas Cowboys | |||||
32 | Super Bowl XXXI | Green Bay Packers | |||||
33 | Super Bowl XXXII | Denver Broncos | |||||
34 | Super Bowl XXXIII | Denver Broncos | |||||
35 | Super Bowl XXXIV | St. Louis Rams | |||||
36 | Super Bowl XXXV | Baltimore Ravens | |||||
37 | Super Bowl XXXVI | New England Patriots | |||||
38 | Super Bowl XXXVII | Tampa Bay Buccaneers | |||||
39 | Super Bowl XXXVIII | New England Patriots | |||||
40 | Super Bowl XXXIX | New England Patriots | |||||
41 | Super Bowl XL | Pittsburgh Steelers | |||||
42 | Super Bowl XLI | Indianapolis Colts | |||||
43 | Super Bowl XLII | New York Giants | |||||
44 | Super Bowl XLIII | Pittsburgh Steelers | |||||
45 | Super Bowl XLIV | New Orleans Saints | |||||
46 | Super Bowl XLV | Green Bay Packers | |||||
47 | Super Bowl XLVI | New York Giants | |||||
48 | Super Bowl XLVII | Baltimore Ravens | |||||
49 | Super Bowl XLVIII | Seattle Seahawks | |||||
50 | Super Bowl XLIX | New England Patriots | |||||
51 | Super Bowl L | Denver Broncos | |||||
52 | Super Bowl LI | New England Patriots | |||||
53 | Super Bowl LII | Philadelphia Eagles | |||||
54 | Super Bowl LIII | New England Patriots | |||||
55 | Super Bowl LIV | Kansas City Chiefs | |||||
56 | Super Bowl LV | Tampa Bay Buccaneers | |||||
Sheet1 |