Hacker News new | past | comments | ask | show | jobs | submit login

The tasks on the first sheet is easily accomplished by flash fill in MS Excel and I suspect less prone to error. Not sure why flash fill is not more popular



What is flash fill? I have worked a lot on Excel sheets and still haven’t heard anything about it.


Flash fill is an implementation of program synthesis, a technique invented by Sumit Gulwani formerly of Microsoft Research. Here's a paper that explains more about how it works [1]. It's not a very discoverable feature of Excel though [2]

[1] https://arxiv.org/pdf/1703.03539.pdf [2] https://support.microsoft.com/en-us/office/using-flash-fill-...


ctrl+e




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: