Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match debits with credits | Excel Programming | |||
Macro to delete rows with matching Credits and Debits | Excel Programming | |||
Using Sumif with debits & credits | Excel Discussion (Misc queries) | |||
debits and credits in one column | Excel Programming | |||
incrementing rows for matching debits/credits | Excel Programming |