View original (French)

Merge 2 columns for accounting

Solved
Adrien88958 Posted messages 4 Status Member -  
Adrien88958 Posted messages 4 Status Member -
Hello,

I have extracted my client accounting data into Excel.
So I have a Debit column and a Credit column.
I would like to merge these two columns so that I get a negative value for the data in the Credit column.

I've looked for quite a few tutorials without finding an answer to my question.

Thank you for your help!

Best regards,
Adrien

Configuration: Windows 7 / Chrome 27.0.1453.110

1 answer

  1.
    Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 639
     
    I doubt you searched for anything, because you just need to do a simple subtraction to answer your question :D

    If A=Credit and B=Debit, the balance in C is A-B. If it is positive, you have a credit balance in your account, otherwise it's a debit balance.

    Or maybe I just don't understand your question at all???

    --
    Remember remember the fifth of November
    Gunpowder, treason and plot.
    I see no reason why gunpowder, treason
    Should ever be forgot...
    0
    1. Adrien88958 Posted messages 4 Status Member
       
      Yes, there is this solution where I have 3 columns... (thanks, I know how to add :p)

      Except there's a trick that allows me to merge these 2 columns into one, other than a calculation...
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      without a formula it seems difficult...
      You're not really going to ask for a macro for that, are you?

      eric
      0
    3. Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 639
       
      Alright, I understand what you want: you need to do a special paste: you copy the Debit column, select your Credit column, choose "Special Paste", and check "Values" and "Subtract". Then you will need to delete the Debit column.

      The first time you do it, you save a macro like that so it's faster next time...
      0
    4. Adrien88958 Posted messages 4 Status Member
       
      Perfect!

      Thanks for your help ;-)
      0