Filling in data gaps in Excel – Option 3- Formula

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: