Comparing 2 columns of numbers

Status
Not open for further replies.
F

Foxtrot

Board Regular
Joined
Jun 29, 2005
Messages
83
Hi, i want to compare debits in column (D1:1000) to credit in column (E1:1000). If a debit and a credit is equal then it must just add a ZERO in each line, say in Column F??? How can i go about this???
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Well, what you're looking to do literally is just comparing them and doing simple math like

=D1-E1

What' i'd suggest is starting with =SUM($E$1:E1)-SUM($D$1:D1) which will give you a running balance.
 
Upvote 0
Thanks but this is not going to work - the matching debit and credit must clear, then i will only have to investigate the ones not clearing?
 
Upvote 0
Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to this thread.
 
Upvote 0
Status
Not open for further replies.

Similar threads

R
  • Question Question
Reconciling debits and credits
Replies
9
Views
347
RG93
R
T
  • Solved
Using reference data from one table to populate another column/table
Replies
2
Views
272
thirdeye85
T
O
  • Solved
transfer data from userform by matching items in combobox with headers in sheet
Replies
4
Views
222
Omar M
O
E
  • Question Question
Trial Balance, INDEX/MATCH, Multiple Criteria, and SPILL
Replies
2
Views
471
Cubist
Cubist
O
  • Solved
Macro to change way of showing data by transporting for each account name
2
Replies
19
Views
401
Alex Blakenburg
A

Forum statistics

Threads
1,224,551
Messages
6,179,480
Members
452,915
Latest member
hannnahheileen

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top