I have 2 sets of data. What's the best way to reconcile one against the other?
I've got 3 columns in each data set: dept, acct, and amount. I need to get the total amount per dept and account combination in data set #1 reconciled against the same thing from data set #2.
I don't know if a vlookup can work or pivot tables or some function I'm not already familiar with.... Help! Anyone have any suggestions on how to attack this?
May be this link on Pivot Tables will help?
http://www.microsoft.com/dynamics/us...s_collins.mspx
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
What I'm trying to get around is creating 2 pivot tables from 2 data sets and manually comparing them line for line. The data would be grouped nicely but I'd still have 3500 lines to compare. I'm trying to figure out a way to automatically compare the 2 sheets and only review nonmatching amounts.
Any other thoughts?
How about filtering and sorting?
http://office.microsoft.com/en-us/ex...127901033.aspx
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks