Ok, I've been at this for hours and I'm going a little crazy.
I have a workbook with many sheets - each sheet is a job code, eg. "F0169852"
Each sheet keeps track of that job's expenses, mainly hours and salary.
Here's what I want to do:
Have a sheet called "admin" with a simple 2 column list.
Column 1 would be a "hours" top 10 list. It would show in decreasing order the jobs with the most hours logged. Example:
Hours
456
400
350
200
etc...
That was the easy part, I used the LARGE function to choose from the same cell on a range of sheets. =LARGE('-:end'!AA41,1) - i repeated that 10 times changing the "1" at the end to 2,3,4, etc... got me so far?
Beside those hours I want another column entitled "Job" showing me what job code (sheet name) that number came from. This is the part I can't figure out for the life of me...
Anyone have any idea? Did I explain myself clearly enough?
PLEASE HELP!!!
Awesome idea.
Here's a dummy file.
Bookmarks