Hi. I need to compare two balance sheets of different months in Microsoft Excel. The ledger (line items) may not be exactly the same for the balance sheet of each month. I need to calculate the fluctuation of identical ledger (line items) across 2 months. There is an account number attached to each ledger (line item).
What Excel formulas (other than Sum and If) would help me to complete this task in the fast possible time?
I currently take at least about 4 hours to complete this task as there are hundreds of lines.|||If the account numbers are in column A and the account values are in column B and the two sheets you want to compare are called say April and May, you could try something like this...
=INDEX(May!B:B,MATCH(
April!A1,May!A:A,0))-April!B1
This formula takes the account number from April-A1 and looks it up in the column May-A. It returns the account amount from the matching account number in May. It then subtracts the April account amount.
If you want to send me a sample workbook and a detailed description of what exactly what you are trying to do, I'll take a look at it.
Excelpert@cfl.rr.com|||Use VLookup
http://www.timeatlas.com/mos/5_Minute_Ti鈥?/a>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment