Auto Fill VS Flash Fill
Posted: September 13, 2019 8:44:00 AM CDT
Flashfill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column or combine first and last names from two different columns.
Autofill is a very useful Excel feature. It allows you to create entire columns or rows of data which are based on the values from other cells. In other words, Excel compares the selected data and tries to guess the next values that will be inserted.
INSTRUCTIONS