So today I decided to dive into the football matchup between Rayo Vallecano and Real Sociedad. Wanted a clear picture of their history head-to-head. Started simple – grabbed my laptop, cracked open a browser, and went straight to a football stats site I usually trust for Spanish league stuff.
First thing? Searched “Rayo Vallecano vs Real Sociedad results”. Got flooded with recent news. Ugh. Had to dig deeper. Tacked on “historical results” to the search. That worked better. Scrolled past ads and recent match reports, looking for tables full of numbers – that’s the good stuff.
Found a promising page listing results season by season. Excellent. Started copying everything. Open office dates, scores, who played home or away. Simple copy-paste into a blank spreadsheet. Looked messy at first. Needed organizing.
Slapped headers onto the spreadsheet columns: Season, Date, Competition, Home Team, Away Team, Score. Pasted each row of data underneath. Took a bit of time, manually checking each entry as I went. Found a few gaps, seasons where they didn’t play? Double-checked those – yeah, sometimes Rayo was down in Segunda Division while La Real stayed up.
After filling the spreadsheet, wanted some quick facts. How many wins each? Drews? Goal difference?
- Filtered the Home Wins: Counted Rayo’s wins at Vallecas.
- Filtered the Away Wins: Counted La Real’s wins in Madrid.
- Drews: Easy, just filter the ties.
- Total Goals: Wrote a quick SUM formula adding Rayo’s goals, then another for Sociedad’s.
Discovered patterns. Rayo wins less overall. Wins mostly come at home. Sociedad definitely has the better head-to-head record over the long run. Some seasons are tight fights, others… not so much.
Looked specifically for big scorelines – any 4-0s or 5-1 thrashings? Yep, found a couple brutal ones for both sides way back.
Final Step: Cleaned up the spreadsheet, double-checked all my counts and formulas against the source page one last time. Made sure the dates made sense, no duplicates. Now I’ve got a full breakdown – every official meeting between these two teams, ready to share. Easy process, just takes some patience and clicking.