Rashid

I can't help because I don't understand what you want.

Could you rewrite your question with more specifics, including which
cells hold the various months, what you mean by the latest known data
point, how Row 3 Column 1 (i.e.cell A3) relates to the data, what you
mean by "if there was something in March" (what is this "something" and
where is it stored?), etc.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=534007