With Texas A&M playing #1 Clemson in Week 2, #1 Alabama in Week 7, and #1 LSU in Week 14, Texas A&M's schedule will show that they will play 3 #1 teams ranked by the AP Poll this season. After looking through every single AP Poll with the help of Wikipedia, I can confirm that Texas A&M will be the first team to play against 3 #1 teams ranked by the AP Poll in a single season. During my research, I compiled a list of teams that played 2 #1 teams in one season:
| Team (Record) | First #1 (Score) | Second #1 (Score) |
|---|---|---|
| 2019 Arkansas (2-9) | Alabama (L 7-48) | LSU (L 20-56) |
| 2013 Auburn (12-2) | Alabama (W 34-28) | Florida State (BCS Title, L 31-34) |
| 2011 Alabama (12-1) | LSU (L 6-9 OT) | LSU (BCS Title, W 21-0) |
| 2009 Tennessee (7-6) | Florida (L 13-23) | Alabama (L 10-12) |
| 2000 Baylor (2-9) | Nebraska (L 0-59) | Oklahoma (L 7-56) |
| 2000 Texas Tech (7-6) | Nebraska (L 3-56) | Oklahoma (L 13-27) |
| 1992 Arizona (6-5-1) | Miami (L 7-8) | Washington (W 16-3) |
| 1990 Michigan State (8-3-1) | Notre Dame (L 19-20) | Michigan (W 28-27) |
| 1984 Oklahoma (9-2-1) | Texas (T 15-15) | Nebraska (W 17-7) |
| 1984 Michigan (6-6) | Miami FL (W 22-14) | BYU (Holiday Bowl, L 17-24) |
| 1980 Georgia Tech (1-9-1) | Notre Dame (T 3-3) | Georgia (L 20-38) |
| 1979 LSU (7-5) | USC (L 12-17) | Alabama (L 0-3) |
| 1978 Nebraska (9-3) | Alabama (L 3-20) | Oklahoma (W 17-14) |
| 1978 Missouri (8-4) | Alabama (L 20-38) | Oklahoma (L 23-45) |
| 1974 Northwestern (3-8) | Notre Dame (L 3-49) | Ohio State (L 7-55) |
| 1972 UCLA (8-3) | Nebraska (W 20-17) | USC (L 7-24) |
| 1970 Texas A&M (2-9) | Ohio State (L 13-56) | Texas (L 14-52) |
| 1967 California (5-5) | Notre Dame (L 8-41) | USC (L 12-31) |
| 1965 Indiana (2-8) | Texas (L 12-27) | Michigan State (L 13-27) |
| 1964 Iowa (3-6) | Ohio State (L 19-21) | Notre Dame (L 0-28) |
| 1962 UCLA (4-6) | Ohio State (W 9-7) | USC (L 3-14) |
| 1962 Wisconsin (8-2) | Northwestern (W 37-6) | USC (Rose Bowl, L 37-42) |
| 1960 Kansas (5-4-1) (7-2-1)* | Iowa (L 7-21) | Missouri (W* 23-7) |
| 1960 Purdue (4-4-1) | Iowa (L 14-21) | Minnesota (W 23-14) |
| 1955 Maryland (10-1) | UCLA (W 7-0) | Oklahoma (Orange Bowl, L 6-20) |
| 1953 Oklahoma (9-1-1) | Notre Dame (L 21-28) | Maryland (Orange Bowl, W 7-0) |
| 1948 Indiana (2-7) | Notre Dame (L 6-42) | Michigan (L 0-54) |
| 1947 Northwestern (3-6) | Michigan (L 21-49) | Notre Dame (L 19-26) |
| 1938 Carnegie Tech (7-2) | Pittsburgh (W 20-10) | TCU (Sugar Bowl, L 7-15) |
*- Win Forfeited
In addition, Texas A&M joins Northwestern, Indiana, UCLA, and Oklahoma as the 5th team to play in 2 seasons where at least 2 of their opponent
... keep reading on reddit ➡After some hours of fiddling I'm turning to you reddit.
So in column A I have a list of words within a cell. I'm looking to find one word (ie banana) in the list within one cell (A1). If the word is there AND if the number 1 is in B1 then it'll formulate a 1 in C1.
Sometimes banana isn't in A1's list but B1 has the number 1 (needs to result as 0) and sometimes banana is in A1's list but B1 has a 0 (needs to also result as 0)
Also, in a different formula, if I need to find two words in cell A1 (banana or apple)
Note: I'm only using 1 and 0s
I hope I make sense Thank you for helping this excel formula newbie
Hello fellow Boisionis (and Jon <3):
The titular question came to me, stuck as I currently am on a 10hr Amtrak and quite bored.
Theoretical Maximum
I am not adept enough at combing through spreadsheets to find the definitive record holder. What I can offer is the current theoretical maximum, which I believe is 17 18.
The candidates would have to:
-
Be an indoor team in the NFC North or South (or West during the STL + indoor Cardinals era). (Running tally: 4 indoor, 2 outdoor);
-
Have a divisional rotation against another 2-dome NFC division and against the AFC South; such that
-
Each of those 4 away games is against the dome team (12-2);
-
One of the remaining intra-conference games should be at another dome (e.g. Dallas). (13-2) The last game would be at home in order to get our 8 home games (14-2).
-
Secure a 3-6 playoff seed, play either at home or away indoors (17-2). (credit to u/Dk1724 for pointing this out)
-
Superbowl hosted by a dome city (18-2).
Table of current frontrunners:
| Number | Team | Year | Indoor Games | Notes |
|---|---|---|---|---|
| 14 | St. Louis Rams | 1999 | 8 home, @ DET, ATL, NO; 2 home playoff games; Superbowl | |
| 14 | St. Louis Rams | 2001 | 8 home, @ DET, ATL, NO; 2 home playoff games; Superbowl | |
| 13 | Indianapolis Colts | 2009 | 8 home, @ ARI, STL, HOU; 2 home playoff games | credit: u/Artrios |
| 13 | St. Louis Rams | 2013 | 8 home, @ ATL, DAL, HOU, IND, and ARI | |
| 13 | Detroit Lions | 2016 | 8 home, @ IND, HOU, MIN, DAL, and NO. | credit: u/Artrios |
Notes on Stadiums:
| Years | Team | Notes | Credit |
|---|---|---|---|
| 1968-1996 | Houston Oilers | Played indoors in the Astrodome | u/Random_Days |
| 1971-2008 | Dallas Cowboys | Texas Stadium was technically not an indoor stadium | u/Random_Days |
| 1976-1999 | Seattle Seahawks | Played indoors in the Kingdome | u/Random_Days |
| 2005 | New Orleans Saints | Home games vs. MIA, CHI, TB, CAR were hosted outdoors | |
| 2014-2015 | Minnesota Vikings | Played outdoors waiting for USBank stadium | /u/Artrios |
'Dance Monkey' by Tones And I has now spent 9 weeks at #1 in the UK, longer than any other song this year. It is also the joint 4th longest reigning #1 of the decade.
Top 10:
- Tones And I - Dance Monkey (=)
- Lewis Capaldi - Before You Go (+17)
- Stormzy ft. Ed Sheeran & Burna Boy - Own It (NEW)
- Dua Lipa - Don't Start Now (-2)
- Billie Eilish - Everything I Wanted (-2)
- Lewis Capaldi - Bruises (=)
- Arizona Zervas - ROXANNE (+3)
- Maroon 5 - Memories (-3)
- Ed Sheeran ft. Camila Cabello & Cardi B - South Of The Border (-2)
- KSI ft. Rick Ross, Lil Baby & S-X - Down Like That (+12)
Debuts / new peaks in the Top 40:
-
DigDat ft. D-Block Europe - New Dior (NEW)
-
Jax Jones ft. Ella Henderson - This Is Real (+2)
-
Endor - Pump It Up (+8)
-
Coldplay - Orphans (+17)
-
Harry Styles - Watermelon Sugar (+7)
-
PARTYNEXTDOOR ft. Drake - Loyal (NEW)
-
Mariah Carey - All I Want For Christmas Is You (+25)
-
ZieZie ft. Aitch - French Kisses (NEW)
-
Idina Menzel & AURORA - Into the Unknown (NEW)
-
Bastille - Can't Fight This Feeling (+55)
one of the few wonderous things in my life these past 3 weeks. my original housing number was ~4250, they gave me a new one, and lo and behold, it's 69. 2 digits. yay for me!
i'm looking for a single apartment either in stuvi or baystate. do i have a shot at a single apartment in stuvi after internal selection? how are baystate apartments compared to baystate dorms?
This is only for subreddits dedicated to characters. With that in mind armpit subreddits and subreddits dedicated to certain games will not be in included.
Eirika: r/ChurchofEirika
Lucina: r/Lucina
Ike: r/TheRadiantHero
Karel: r/SwordmasterKarel
Camilla: r/RosesThorns
Florina: r/FluffyFlorina
Minerva: r/RedDragoon
Azama: r/praisehotoke
Cordelia: r/CordeliaCouncil
F!Robin: r/Twintailed_Tactician
Nino: r/domybest
Ophelia: r/Ophelia
Flora: r/maidofice
Oboro: r/FashionFighter
Felicia: r/WeGotTrouble
Beruka: r/FinishingTheMission
Ryoma: r/LobsterLord
Cherche: r/TheChurchofCherche
Lyn: r/lynforthewin
Larcei: r/LarceiPostEmblem
Mareeta: r/Mareeta
Sharena: r/TeamSharena
Selkie: r/Selkie
Fredrick: r/PickAGodAndPray
Owain: r/AchingBlood
Tharja: r/DoYouLikeDarkness
Micaiah: r/dawnpriestess
F!Morgan: r/BestDaughter
Eir: r/ChurchOfEir
Peri: r/PlayfulSlayer
Lorenz: r/Lorenzpostemblem
Lyon: r/ChurchOfLyon
Mae: r/ImStillHyperLetsGo
Genny: r/Imreadytoroll
Seliph: r/SweetieSeliph
Dorthea: r/ChurchOfDorothea
Tiki: r/TheSleepyTiki
M!Corrin: r/CorrinsTreehouse
F!Corrin: r/CorrinConclave
Bors: r/Bors
Niles: r/Crueltobekind
Ogma: r/Ogma
Mia: r/Miapostemblem
Myrrh: r/GreatDragon
Olivia: r/Stopstaring
Sue: r/DoeOfSacae
Anna: r/AnnaEmblem
Bors: r/Bors
Kellam: r/KellamTheGreat
Naliah: r/WolfQueenNaliah
Clair: r/LadyClairSociety
Fjorm: r/FjormElivagar
Fay: r/DevotedHeart
Fae: r/TheFluffyFae
Bernadetta: r/Bernadetta
Marth: r/TheHeroKing
Pelleas: r/PalaceofPelleas
Soren: r/TempleofSoren
Celica: r/ShrineofCelica
Delthea: r/DeltheaPostEmblem
Petra: r/HouseofPetra
>“I’m all about the law of attraction,” Bazemore said. “And I always said, ‘You need to get to Portland … you need to get to Portland … you need to get to Portland,'” Bazemore said.
>He said he provided Atlanta with a list of teams to where he would like to be traded. Portland was number one on that list.
>“And now,” Bazemore said, “here I am.”
Also...
>Bazemore says he used to have this re-occurring dream, one where confetti is falling and he is celebrating with teammates on the court.
>“I think about it a lot,” Bazemore said of the dream. “And I always saw it with me in a Portland jersey.”
>When he played Portland, he noticed how close the Blazers players seemed to be, and he picked up on chatter around the league, hearing how “amazing” it was to play for coach Terry Stotts and assistants Nate Tibbetts and David Vanterpool (this offseason, Vanterpool left for Minnesota). Then in the playoffs, he made a point to watch every game as the Blazers advanced to the Western Conference finals, making note of how his shooting, play making and defense could complement the roster.
If you have the app and aren't subscribed, this is a good story to use one your free articles on. In addition to this stuff above it's a pretty great story about what he's gone through, mental health issues, his relationship with his wife/child/family and where he is in his life. He really opens up.
I wanted to find out who are highly efficient playmakers and scorers, hence the somewhat arbitrary statline. 82 players have at least one season with this statline. Here is the top 11:
- Lebron James - 14
- Larry Bird - 10
- Kobe Bryant - 9
- Allen Iverson - 9
- Michael Jordan - 9
- Stephon Marbury - 7
- Gary Payton - 7
- Dwyane Wade - 7
- Clyde Drexler - 6
- Tracy McGrady - 6
- Russell Westbrook - 6
For comparison, CP3 only has 2 such seasons, due to his point average falling below 20 every other season.
)