I have daily, hourly, and minute data that started in 2015 and is current for 3 weather stations. They are collecting 50+ observations each. They are all missing observations at random throughout the data set independent of each other. I need to find a way to populate the missing rows with blank rows so I can line up the data sets in a new sheet.
I have tried making helper columns with MATCH lookups, but with a data set as big as mine you find out that when you increment time it doesn't add 1 hour it ads 1.00000001 hours or whatever and none of the times match. Also when I drag down the MATCH through the column, the first three cells which I do by hand have the MATCH('CELL I AM REFERRING TOO', 'ARRAY, 0), but when I drag it down the formula in the error checker is MATCH("NUMBER EQUIVILANT TO THE TIME IN THIS CELL", "ARRAY", 0). I have played with the formatting of the cells, but I can't seem to get anything to work. If I can get that to work, I can use the MATCH function, but I figured I'd state the big picture problem in case someone has a better idea.
Also I don't know VBA, I am starting to think learning it would be easier than trying to figure this out or doing it by hand.
Bookmarks