Hello. So I am having a problem company up with a formual for an analysis I am trying to create. The example below is general ledger with multiple account numbers and multiple centers. Very long sheet, about 1500 rows of information. I want to be able to pull GL information for a specific account and specific center and list that on a separate sheet. For example I want to pull GL account 5000 (payroll) in cost center 10.
Download:
Date Journal Entry Discription Account Amount Center
10/31/2013 Payroll 5000 1000 10
10/31/2013 Payroll 5000 1200 12
10/31/2013 Payroll 5000 1100 13
10/31/2013 Payroll 5000 1100 10
10/31/2013 Payroll 5000 1000 10
10/31/2013 Payroll 5000 900 11
10/31/2013 Payroll 5000 875 16
Result I am trying to get to:
GL Account: 5000 Cost Center 10
Date Journal Entry Discription Account Amount Center
10/31/13 Payroll 5000 1100 10
10/31/13 Payroll 5000 1000 10
Basically I need a formula based on 2 criteria and it will list all of the transactions, not just one. Any help will be greatly appreciated. Thanks.
Bookmarks