+ Reply to Thread
Results 1 to 6 of 6

populating a table from a separate sheet based on ranking

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Torrance, CA
    MS-Off Ver
    Excel 2013
    Posts
    75

    populating a table from a separate sheet based on ranking

    I'm looking to populate tables for specific tasks that my site performs and compare their performance against the other top sites in the company. I need to pull the site # and their performance based on the task, ranking them from first to last.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-21-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: populating a table from a separate sheet based on ranking

    With what sort of regularity do you need to do this? How often is it updated? It seems like what you really want to do is just transpose a row of data and then sort it; which if this is a one time thing would be way easier to just DO than to try and write equations/a macro to do it for you.

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: populating a table from a separate sheet based on ranking

    I needed something to do on my lunch.
    Attached Files Attached Files
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  4. #4
    Registered User
    Join Date
    09-27-2012
    Location
    Torrance, CA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Re: populating a table from a separate sheet based on ranking

    Kate,

    I need to do this weekly, and we have about 50 different tasks and 14 sites to compare...plus, I'm lazy!

  5. #5
    Registered User
    Join Date
    09-27-2012
    Location
    Torrance, CA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Re: populating a table from a separate sheet based on ranking

    Perfect! That's exactly what I need! Thanks for the help, looking forward to breaking this down to see how it does what it does.

    Hope your lunch was good!

  6. #6
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: populating a table from a separate sheet based on ranking

    Glad I could help out.

    Lazy is the mother of all process improvements.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 03-26-2013, 07:36 AM
  2. [SOLVED] Populating a table based on the value match from another table
    By wnarx in forum Excel General
    Replies: 6
    Last Post: 08-31-2012, 12:30 AM
  3. Replies: 0
    Last Post: 09-26-2011, 12:04 PM
  4. [SOLVED] Populating a table based on values in another table
    By Bri in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-25-2006, 09:30 PM
  5. populating table based on codes
    By AmyTaylor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2005, 09:52 AM

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