The Chess Game of the Century in a Single Google Sheets formula
In 1956, a 13-year old Bobby Fischer announced his chess genius to the world, winning one of the finest games in chess history - a game Chess Review called “The Game of the Century“.
In a game full of beauty and surprise, Fischer overcame his much older, more experienced opponent, the International Master Donald Byrne.
Learn how I used the MAKEARRAY, LET, CHAR and other functions to create a single formula that plays through this Game of the Century.
📚 Additional resources:
Template to follow along: https://docs.google.com/spreadsheets/...
Chess Formula written tutorial: https://www.benlcollins.com/spreadshe...
Turning checkboxes into buttons: https://blog.atylerrobertson.com/read...
📖 Chapters:
0:00 - Introduction
1:22 - Backstory
3:47 - CHAR function to show chess pieces in Google Sheets
5:20 - LET function to name pieces
7:21 - MAKEARRAY function to generate 8 by 8 board
9:39 - IFS function to arrange pieces
13:37 - Combine functions to display full board
16:24 - Make the pieces move with IF function
24:17 - Automate the moves with NOW function or checkboxes
✉️ Google Sheets Tips Newsletter, my free weekly newsletter:
https://www.benlcollins.com/google-sh...
🎓 Join 68,000+ professionals in my courses: https://courses.benlcollins.com/
#googlesheets #googlesheetstutorial #spreadsheet
Watch video The Chess Game of the Century in a Single Google Sheets formula online, duration hours minute second in high quality that is uploaded to the channel Ben Collins 25 January 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,344 times and liked it 54 visitors.
