Apr 23 2021 09:51 AM
PC/ Windows 10 Pro | Microsoft 365 MSO (16.0.13901.20366)
Hello, I was wondering if there was a way to autofill the empty spaces in the "Date Created" column like I have starting from lines 2-73. The dates are completely random within 01/01/2016 to 04/22/2021.
Each date is connected to a specific router so I can't have one date overwrite another or the empty cells a date should belong to.
Any help on this matter is appreciated, thank you.
Apr 23 2021 12:19 PM
SolutionSelect column A.
Press F5 to display the Go To dialog.
Click Special...
Select Blanks, then click OK.
Note the address of the active cell in the selection -in your sample spreadsheet it is A75.
Enter the formula =A74 (where A74 is the cell above the active cell) and confirm it with Ctrl+Enter.
Apr 23 2021 12:36 PM
Easiest is with Power Query - query the range and fill down the dates.
Apr 23 2021 12:19 PM
SolutionSelect column A.
Press F5 to display the Go To dialog.
Click Special...
Select Blanks, then click OK.
Note the address of the active cell in the selection -in your sample spreadsheet it is A75.
Enter the formula =A74 (where A74 is the cell above the active cell) and confirm it with Ctrl+Enter.