Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Generate Payment Statement
I'm hoping I can do this with functions but it may need to be a macro. I've been looking at it for awhile now and can't work it out. I have two columns. Column A has the dates of each day, Column B has a figure next to the date that an amount was paid. Some days have nothing in column B. A.........B 1/1/05 10 2/1/05 3/1/05 5 4/1/05 5 5/1/05 I have to produce a statement of payments received. Therefore I want a listing of the date with the amount received to be generated automatically. from above: 1/1/05 10 3/1/05 5 4/1/05 5 Any help would be very much appreciated. thanks adrian -- myty ------------------------------------------------------------------------ myty's Profile: http://www.excelforum.com/member.php...o&userid=24592 View this thread: http://www.excelforum.com/showthread...hreadid=381844 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loan Schedule with Balloon Payment | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Trying to Manipulate a Mortgage Payment (HELP!) | Excel Worksheet Functions | |||
how do you get a positive number payment with a mortgage payment . | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |