I’m sitting in a training session today, and I saw the trainer do something in Excel that I didn’t know was possible… Flash Fill can complete columns of names based on other columns. Here’s how…
I have an Excel table with a list of Full Names, followed by columns for First Name and Last Name:
If I enter the first name (Tom) of the first entry (Tom Duff) in the First Name column, I can then click on the cell underneath it and click on Flash Fill:
Hey! It filled in all the first names from the Full Names column:
Same thing works for the Last Name:
This is REALLY cool as I don’t have to come up with any formulas to make that happen for me!