- Formula if you have credit in one column, debit in next column
- Excel - A formula to count a list of names
- Excel - Find occurences of same value in a column
- Filter The Data In Excel Through Formula (Solved)
- Formula to count if cells in consecutive columns are populated
- Excel – Formula to calculate between two columns

Well, it is like this:

=a1-b1

In cell c1.

So, in cell c1 use the above formula. Then in a1 use the credit amount. IN b1 use the debit amount.

=a1-b1

In cell c1.

So, in cell c1 use the above formula. Then in a1 use the credit amount. IN b1 use the debit amount.

Was this answer helpful?

Solved myself

Many thanks

Many thanks

Was this answer helpful?

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Jack- Jan 12, 2016 at 09:37 AMJackthelad- Jan 13, 2016 at 04:51 AM