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