Get Excel to Write Formulas FOR YOU 🔥 (Formula by Example in Excel)
Вставка
- Опубліковано 20 чер 2024
- Get Excel to write formulas for you from given examples.
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍
Excel Formula by Example can write formulas from given examples. That's right! Give Excel the answer and Excel will write your formula.
This feature is currently in Excel Online only.
Connect with us!
LinkedIn ► / alanmurray-computergaga
Instagram ► / computergaga1
Twitter ► / computergaga1
TikTok ► / computergaga
#excel365 #excel #exceltips - Навчання та стиль
Thanks very so much
You are welcome
I've gotta give this a try.
Oh yes!!! It's good. It can't do lookups like Copilot, but it can do calculated columns great.
@@Computergaga
It wrote this formula for me. It strips off the letters at the end of a string, where the string starts with a varying number of numbers and ends with a varying number of letters.
Pretty impressive.
=RIGHT([@ID], LEN([@ID]) - (INDEX(FILTER(ROW(INDIRECT("1:" & LEN([@ID]))), (65
Just looking at that, scares me
Thanks, very interesting, is this a bit like Flash Fill? Paul
Yes, except that it writes a formula while Flash Fill is a one-time only feature. Also Flash Fill has a button while Formula by Example is currently executed automatically as you type. Would be great to have a button form it.
Which is the extension working in the background?
That’s nice , will check this out , it’s somehow similar to column by example in power query
Yes, sure is Chahine. Thanks!