| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to fill missing cells in the collumn of dates?
Hi,
I have large set of data. I have two columns for every variable: first consists of dates (from 01.01.2000 to 01.01.2008) and the second column consists of values for every date. The problem is that some dates are missed (for example I have 01.01.2000 and next row is 05.01.2000). Is it possble to insert row for every missed date and fill the date in the first column? I can do it manually but I have 7 variables with different set of dates so it will take ages to do it manually. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting if data from one collumn is present in another collumn | Excel Worksheet Functions | |||
| code to fill in missing border lines | Excel Discussion (Misc queries) | |||
| FILL COLOR BOX MISSING | Excel Discussion (Misc queries) | |||
| Fill in missing months | Excel Discussion (Misc queries) | |||
| FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
Threaded Mode
