I have 2 columns a and b . a contains payment b
contains balance.
I have the entire col b with the formula. my ? is
when the balance appearsin b it is in all the cells in that column.I
only want it in the used ones, not the unused ones:( example
$270.00 16,730.00
$270.00 16,460.00
$100.00 16,360.00
$300.00 16,060.00
$270.00 15,790.00
15,790.00
15,790.00
15,790.00
15,790.00
15,790.00
this 15790.00 is in col b...not a...I want no bal in unused cells


--
fiftieslady
------------------------------------------------------------------------
fiftieslady's Profile: http://www.excelforum.com/member.php...o&userid=31186
View this thread: http://www.excelforum.com/showthread...hreadid=508574