Excel - Is 26x26 Letter Grid, No Repeats Impossible?: Episode 1701

2,054 views · Published 2 May 2013 · 5:17 · Indexed 30 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Creating a 26x26 Grid of Letters with No Repeats | MrExcel Podcast.

Welcome to another episode of the MrExcel podcast! In this episode, we will be tackling a seemingly impossible challenge - creating a 26x26 grid of letters with no repeats across the rows and columns. This may sound easy, but as we discovered in previous episodes, it is not as simple as it seems.

In yesterday's episode, we did some math and concluded that even with 407 septillion rows in Excel, we would still run out of room before reaching the 26th letter. However, I was determined to find a solution and decided to write a macro that would fill in the next row with no repeats. And guess what? It worked!

In today's episode, we will be taking a closer look at the macro and how it solves the puzzle. We have a grid of letters and a simple COUNTIF formula to check for repeats. Then, we have a grid that shows the number of possible locations for each letter. We realized that the key to solving this puzzle is to start with the letters that have the fewest possible locations and work our way up.

With the help of the macro, we were able to solve the 26x26 grid with no repeats across the rows and columns. And the best part? We can do it repeatedly in just 30 seconds! This makes the previous method of using AutoFilters seem completely insane. We have generated multiple unique grids and it seems like we could continue to do so all day.

This challenge was originally sent in by Kris, who wanted 26 grids with no repeats in all three dimensions. While we initially thought it was impossible, we have now proven that it is possible to have a 26x26 grid with no repeats across the rows and columns. Thank you for joining us this week and stay tuned for more exciting challenges on the MrExcel podcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Solving a 26x26 Grid with No Repeats
(00:15) Solving for No Repeats Across Rows
(00:25) Attempting to Write a Macro
(00:35) Using a Grid to Track Letter Appearances
(00:54) Solving for the Fewest Number of Choices
(01:56) Running the Macro
(02:18) Discovering a Faster Method
(03:12) Success in Solving the Grid
(03:22) Realization of a More Efficient Method
(03:47) Comparison to Previous Attempts
(04:25) Possibility of Generating Unique Grids
(04:46) Original Goal of 26x26x26 Grids
(05:03) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
26x26 Letters No Repeats
AutoFilter in Excel
COUNTIF function
Episode 1701
Excel grid of letters
Generating unique 26x26 grids
Learn Excel
Next Row macro
No repeats across rows and columns
Solving letter placement


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153523/

Finishing off the week-long series, Bill looks at the probability that this grid may not become a reality. The Grid, a Random selection of 676 Letters placed into a 26 x 26 Grid, without Repeats in Each Row and without Repeats in Each Column. Follow along with Episode #1701 to find out if creating this Grid in Microsoft Excel is possible. The macro can be downloaded from https://www.mrexcel.com/excel-tips/dealing-with-a-puzzle/


"Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. http://www.mrexcel.com/store/index.php?l=product_detail&p=254 

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

More from this channel