Hi All,
I have created an Excel template (Excel 2010) that allows me to create individual worksheet for each project. It calculates total budget, remaining budget and totals for each project.
I have now created a Total Monthly Expenditure sheet which basically calculates budgets, totals and remaining budgets for all projects. In the same sheet I need to list top 20 projects that have the highest expenditure. I can get total expenditure with =LARGE(First:Last!$F$52:$F$52,ROW(1:1)) but i am trying to get the corresponding worksheet name or the value of A1 next to the total value. How can i do this?
I hope this makes sense, if it does't I can post my current Excel document.
Would really appreciate your help.
Bookmarks