PDA

View Full Version : Sleeper: Excel's Formula by Example



Aussiebear
05-30-2023, 04:16 PM
Has anyone experienced the new "Formula by Example" yet?

georgiboy
05-30-2023, 10:30 PM
No but I have read about it, it's like a dynamic version of flash fill. Instead of just giving you the text as a result, it generates the suggested formula and autofills it. When I read about it, it was only supported with Personal and Family subscriptions to 365 and also only supported with tables and not ranges. I like it TBH, only a sign of things to come with AI and all.

Anyone else wants to read about it, below is a decent read:
https://techcommunity.microsoft.com/t5/excel-blog/more-on-formula-by-example/ba-p/3728914