Microsoft Excel Tutorial: Solving a Text Comparison Problem: 3 AI Bots versus 3 Humans.
To download the workbook from today: https://www.mrexcel.com/youtube/GPLLrcq3D3A/
The battle is on! In Episode 2672, we’re pitting three AI bots (Deep Seek, Copilot, and Beta Copilot with Python) against three (and a half) human Excel gurus (Rico, XLLambda, and Geert). Who will come up with the best solution for an Excel text comparison problem?
This challenge comes from Brian, who wanted to compare two text strings and extract the differences. Seems simple, right? Well, not quite! My initial formula had some issues, so I turned to AI for help. But the AI solutions… let’s just say, they were interesting. Some worked, some didn’t, and some made things even worse!
So, I turned to three Excel experts—and WOW, did they deliver! Rico crafted a brilliant formula, XLLambda pulled off an advanced Lambda function, and Geert worked his Power Query magic. Their solutions were faster, smarter, and more reliable than anything the AI bots came up with.
In this video, you’ll see:
The original problem and my not-so-great solution
How Deep Seek, Copilot, and Copilot with Python tackled the challenge (with mixed results)
Rico’s clever recursive Excel formula, XLLambda’s dual Lambda approach, and Geert’s Power Query approach
A final verdict: Who won—AI or human experts?
All formulas & Power Query code are in the workbook—try them out yourself! Download the workbook from:
Timestamps included so you can jump to each solution. Don’t forget to like, comment, and subscribe for more Excel challenges!
#Excel #AIvsHumans #Copilot #PowerQuery #ExcelFormula #ExcelChallenge
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
Table of Contents
(0:00) Problem Statement:
This video answers these search terms:
Excel AI vs Human
Compare text strings in Excel
Excel formula to find differences in text
Copilot vs Deep Seek vs Python in Excel
Power Query text comparison Excel
Excel AI formula challenge
Recursive Lambda function Excel
Best way to compare text in Excel
Excel AI vs human experts
Advanced Excel formulas for text analysis