Populate Missing Values

[pamarty]

Hi,

I have data in worksheet which has 2 columns of dates and rates. I need
to populate the missing dates and rates with the rate just prior to the
missing date.

Ex:

3/27/2002 0.0522
3/28/2002 0.0529
4/1/2002 0.0529

The above data has 3/29/2002, 3/30/2002 and 3/31/2002 missing. I would
have to add these dates and populate the rate with the rate of
3/28/2002 (which would be 0.0529).

I need to do this for 20,000+ records. I am new to excel. Is there a
way to do this using a macro/VB script?

Thanks,
Pamarty

 

[Marcelo]

Hi Pamarty

I am not sure if this solution will attend you but...

on another column make a list as
3/27/2002 (assuming it is on c2)
=c2+1

and copy down
on the column D use this formula

=if(iserror(vlookup(C2,$A$2:$A$100,2,0)),C1,vlookup(C2,$A$2:$A$100,2,0))

Hope this helps
Regards from Brazil
Marcelo




"pamarty" escreveu: