No video
Get Excel to Write Formulas FOR YOU 🔥 (Formula by Example in Excel)
Рет қаралды 1,436
Ай бұрын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
@anathanath4687 Ай бұрын
Thanks very so much
@Computergaga Ай бұрын
You are welcome
@OzduSoleilDATA Ай бұрын
I've gotta give this a try.
@Computergaga Ай бұрын
Oh yes!!! It's good. It can't do lookups like Copilot, but it can do calculated columns great.
@OzduSoleilDATA Ай бұрын
@@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
@Computergaga Ай бұрын
Just looking at that, scares me
@PaulEBrownbill Ай бұрын
Thanks, very interesting, is this a bit like Flash Fill? Paul
@Computergaga Ай бұрын
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.
@chahineatallah2636 Ай бұрын
That’s nice , will check this out , it’s somehow similar to column by example in power query
@Computergaga Ай бұрын
Yes, sure is Chahine. Thanks!
@kameshsharma5164 Ай бұрын
Hello Sir, I need your help. I want a formula that • if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated • If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated • if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated *Please Reply Sir*
@amolkanawade5129 Ай бұрын
Which is the extension working in the background?
@Computergaga 22 күн бұрын
extension?
Computergaga
Рет қаралды 1 М.