Matching Debits and Credits in same column

  • Thread starter Thread starter ap19
  • Start date Start date
A

ap19

Hello. Any help would be greatly appreicated. I have Debits and Credit values
in the same row, what I would like to do is run a macro that will match them
and extract them to cell to the right. Is this possible?

Thanks
 
You don't need a macro. If you have your list in column A1 downwards put this
in cell B1:

=IF(A1>0,A1,0)

and this in C1:

=B1-A1

Copy the formulas down as far as necessary and then change the format of the
cells to the following custom:

#,##0.00;(#,##0.00);-

Sam
 
Sam
Thanks for your response. The problem is that the debits and credits are not
always one after each other. They can be anywhere within the group.
 
It doesn't matter where the debits and credits are - if you have a long
column of numbers with some positive and some negative those formulas will
put all the positive ones in the next column along and the values of all the
negative ones in the column after that.
 
thanks....got it...

Sam Wilson said:
It doesn't matter where the debits and credits are - if you have a long
column of numbers with some positive and some negative those formulas will
put all the positive ones in the next column along and the values of all the
negative ones in the column after that.
Click to expand...
 
Back
Top