After my previous video showing AROSE as the best first guess in Wordle, I started doing some more cool Excel formulas to test all Wordle words. This is a long video for the weekend, mostly of me geeking out about Continue reading “Excel Doing Billions Of Calculations To Study Wordle”
Category: Power Pivot
Excel STOCKHISTORY Never Falls On Weekend Or Holiday – 2468
TKH is using the new STOCKHISTORY function in Excel. He is looking for stock prices from 7, 14, 30, and 60 days ago. When you are asking for a single day, the STOCKHISTORY function returns a #VALUE error if the Continue reading “Excel STOCKHISTORY Never Falls On Weekend Or Holiday – 2468”
New Excel Formula Editor Debuts – 2466
Big news today for Win / Mac / Online versions of Excel. A new Advanced Formula Editor will make LAMBDA and LET far easier. Among the highlights:
New Advanced Formula Editor (Windows, Mac, Online)
Share Lambda through GitHub
Better Recursion Limits (16x Continue reading “New Excel Formula Editor Debuts – 2466”
How To Combine Multiple IF Formulas In Excel – 2465
You wrote some IF functions to assign a score based on numerical ranges. You want to combine those formulas into a single long Excel formula. This video will show you how to do it and how to avoid some pitfalls.
Along Continue reading “How To Combine Multiple IF Formulas In Excel – 2465”
Excel Will Not Let Me Enter This Formula – 2464
Your co-worker has an Excel formula and when you press Enter, you get “You’ve entered too many arguments for this function.” You can’t even get out of the formula.
Today, I show how the lowly Function Arguments Continue reading “Excel Will Not Let Me Enter This Formula – 2464”
Answering Wyn Hopkins Wordle Challenge
Wyn Hopkins built an Excel-based Wordle game. He saw my video on my Wordle Helper tool and challenged me to solve his game with my Excel file. The results are in.
Wyn’s video challenging me to play:
https://www.youtube.com/watch?v=D4uBZ8gdCTE
Wyn’s Continue reading “Answering Wyn Hopkins Wordle Challenge”
Wordle Best Starting Words is AROSE not ADIEU – Episode 2463
Everyone has their theories on the best starting word for the Wordle game. A lot of people suggest ADIEU. But when you look at the frequency of each letter in the 8000 possible words, a better start word has Continue reading “Wordle Best Starting Words is AROSE not ADIEU – Episode 2463”
WORDLE Helper In Excel – Solve Wordle Faster! – Episode 2462
I love the Wordle game. One game a day. Three minutes. As I played for the first week, I wondered if Excel could help. It can!
Note that this workbook requires a recent Excel version due to the FILTER formula. You Continue reading “WORDLE Helper In Excel – Solve Wordle Faster! – Episode 2462”
How To Effectively Use Sheet View While Collaborating In Excel 2461
Sheet view in Excel is useful if multiple people are editing the same workbook. Say that one person wants to filter to Open orders and the other wants to see closed orders. One wants the data sorted descending and the Continue reading “How To Effectively Use Sheet View While Collaborating In Excel 2461”
Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values
I know of nine ways in Excel to Paste Values.
One of these is about to be wiped out by Microsoft and the Excel team.
I think all nine of them are important!
Here are the nine ways that I know of to Continue reading “Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values”
The F4 Key To Repeat Is My Favorite Excel Shortcut – 2460
The F4 key in Excel has a dual life. Most people know F4 as the way to put dollar signs in a formula reference. But when you are not editing a formula, F4 will repeat the last command.
Some of you Continue reading “The F4 Key To Repeat Is My Favorite Excel Shortcut – 2460”
The Two Digit Year Setting Does Not Work If You Never Change It – 2458B
An update on video 2458. There is a setting about how Excel interprets a two-digit year. Microsoft changed this setting from 2029 to 2049. But Excel refuses to accept the 2049 setting. Unless you change the setting in Control Continue reading “The Two Digit Year Setting Does Not Work If You Never Change It – 2458B”