Hi, I am having a problem matching a few accounts, The problem is as follows
I receive an excel dokument with account names, currencies and amounts.
What i would like to do is to check that the balances are equal to what i think they should be in my excel document.
The probelm arises when for example i have posts with two amounts and they have one with the total amount, for example:
My file:
Harrry EUR 100
Harry EUR 200
john eur 100
Jane eur 50
Jane eur 100
Their file
Harry eur 300
john EUR 100
jane eur 150
What I am looking for is to see that for each name we have the same amounts. The names are also different, i have been using vlookup to create matches so the ones with one name like John above are not a problem but obviously when trying to do the same with their aggregated accounts i get an issue. One note of importance is that this is a daily check and names can drop off or enter so manually aggregating is not really an option.
Any help much appreciated
/h
Last edited by henriklesaque; 01-27-2012 at 11:29 AM.
Possibly using SUMIF or SUMPRODUCT formulas to test for equality?
As dangelor suggests try the "SUMIF" function. See example in file.
Alf
Hi
Anothersolution
Pivot table
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks