that extra if statement worked great.
Any ideas on part two (the charting)....based on my last post.
"
Also the question about the chart did not work since the cells that
respresent future transaction have zeros in them.
For example:
A2 = 6/1/06 F2 = 4.0%
A3 = 7/1/06 F3 = 3.5%
A4 = 8/1/06 F4 = 2.9%
A5 = 9/1/06 F5 = 2.1%
A6 = 10/1/06 F6 = 0.0%
For my chart I only want to chart out information that is < Today(). So
that if I look at the chart today it will chart F2:F4, but if I look at
the chart next month it will chart F2:F5.
"
--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread:
http://www.excelforum.com/showthread...hreadid=574295