Flash Fill is one of those features in Excel that is easy to ignore or turn off, but it actually does have some very valid use cases that could make life easier! Flash Fill can be tremendously helpful when working on repetitive tasks that would be tricky to implement with formulas. Below are a few examples to demonstrate how this feature can be used. It’s pretty smart! If you’re doing any sort of repetitive task in Excel, I recommend giving it a try.
Credit to http://www.excel-easy.com/examples/flash-fill.html for the Flash Fill example ideas!
UPDATE MARCH 2018:
I’d also like to direct you to another great tutorial (with practice worksheets!), courtesy Hannah Sharron of speadsheeto.com. Thanks, Hannah!
https://spreadsheeto.com/flash-fill-auto-fill/
