I have a data set for discrete dates. I have to show the data as continuous information. That is, if i have data for 1st Jan and 10th Jan, i have to show the 1st Jan data for 2nd to 9th Jan. Please find the attached excel for detailed data explanation. I want to achieve the same in script. It is a kind of FOR THE DATE reporting.
thank you Som for your effort. though your output is not exactly what i wanted, but your script gives me a fair idea. i wanted to populate missig rates for dates from historical rate(may be using PEEK function). i will go through yor script in details and try.
