Reconcile

Status
Not open for further replies.
F

Foxtrot

Board Regular
Joined
Jun 29, 2005
Messages
83
Hi, i need to reconcile 4 colums, ie Ref number, Description, Dr Amount, Cr Amount. I need a formula or way to match these entries. Say line 4 and 10 match then i need those lines to be color coded or a description in another column indicating that line 4 and 10 matches? Any help with this one? Thanks
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
Is that the full extent of the rules, that there will be one other matching entry maximum?
 
Upvote 0
Hi Glenn, i basically want to audit entries in an excel spreadsheet, ie Col A=date, Col B=Reference, Col C=Description, Col D=Debit Amount, Col E=Credit Amount and Col F=Total.
Now based on the above - line 5 = 12/12/2010, JBC001, Goods A, 250, 0 and 250 then in line 55 you will have the match = 25/12/201, JBC001, Goods A, 0, 250, 0...
I want to match Column B, C, D/E??? If they match then i need to know which 2 match??? Hope this makes sense? Thanks
 
Upvote 0
Isn't it the case that the Reference JBC001 will only occur in row 5 and 55?
 
Upvote 0
Yes, you are correct BUT the debit and credit amount must MATCH (be axactly the same) -this is for auditing entries in excel. Thanks
 
Upvote 0
Hi,

You could add another row with the formula =ROW() in and pivot the table, if you pull the newly formed column intot he rows column after your four criteria fields then it should total all products up and show you each individual entry's value which will also show you the associated row numbers.
 
Upvote 0
Mikey B means ... have another column with the formula =ROW()
 
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

N
  • Question Question
Match and lookup combined
Replies
4
Views
353
Glenn Kennedy
G
M
  • Question Question
DR/CR Matching
Replies
3
Views
373
Joe4
Joe4
R
  • Question Question
VBA for Cut, move, paste, delete rows
Replies
6
Views
270
RForster6
R
I
  • Question Question
VLookup question
Replies
2
Views
98
saboh12617
S
S
  • Question Question
extracting data
Replies
1
Views
96
shamsu203
S

Forum statistics

Threads
1,224,557
Messages
6,179,510
Members
452,918
Latest member
Davion615

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