Matching Debits and Credits in same column

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
 
S

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
 
A

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.
 
S

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.
 
A

ap19

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top