didn’t realize that excel had this level of program synthesis behind it: (backstory of development in thread)

"Flashfill is not dynamic." 😢 So close to brilliant. (Gharani's tutorial is remarkably clear by the way.)

MS released it as an SDK: https://github.com/microsoft/prose

@wtaysom – looks like Google's clone ("Smart Fill") generates a spreadsheet formula & exposes it, so it is dynamic. (I can't get it to trigger at all though, so no hands-on experimentation yet.)

found another more detailed video: the prose group seems do be doing awesome stuff!