Results 1 to 5 of 5

Top 10 List with Reference to Sheet Name

Threaded View

  1. #1
    Registered User
    Join Date
    03-04-2011
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    3
    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.
    Attached Files Attached Files
    Last edited by davesexcel; 03-04-2011 at 08:22 PM. Reason: Reset replies to zero

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1