Matching Debits and Credits in same column

[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

 

[Sam Wilson]

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

 

[ap19]

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.

 

[Sam Wilson]

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.

 

[ap19]

thanks....got it...

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.