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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920