Filling in data gaps in Excel – Option 3- Formula

Please sign up for the course before starting the lesson.

The GOTO Special and Filter trick work well for filling in data gaps in Excel but there are times you want to set up a template so that every month or so you can simply copy paste the data and formula do the rest.

Back to: Data cleanup in Excel > Filling in gaps