Matching Debits and Credits in same column
 

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

Matching Debits and Credits in same column
 

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

=IF(A10,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" wrote:

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

Matching Debits and Credits in same column
 

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" wrote:

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

=IF(A10,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" wrote:

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

Matching Debits and Credits in same column
 

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" wrote:

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" wrote:

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

=IF(A10,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" wrote:

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

Matching Debits and Credits in same column
 

thanks....got it...

"Sam Wilson" wrote:

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" wrote:

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" wrote:

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

=IF(A10,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" wrote:

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