+ Reply to Thread
Results 1 to 5 of 5

Auto Sort Values From Highest To Lowest Based Off Of Value

  1. #1
    Registered User
    Join Date
    08-03-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    3

    Auto Sort Values From Highest To Lowest Based Off Of Value

    I need to auto sort values based on ATT with corresponding supervisor from highest to lowest so that I can see at a glance who the top 5 supervisors are that has the highest ATT. please help me with this. I have attached the file, thanks for your help!
    Attached Files Attached Files

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Auto Sort Values From Highest To Lowest Based Off Of Value

    How about this?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-03-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Auto Sort Values From Highest To Lowest Based Off Of Value

    Quote Originally Posted by Bob Phillips View Post
    How about this?
    Yep, the sorting part works.thank you! but i guess what i forgot to tell you guys is that the data changes from time to time. supervisors don't have the same number of agents everytime. sorry about that.

  4. #4
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Auto Sort Values From Highest To Lowest Based Off Of Value

    The code handles that.

  5. #5
    Registered User
    Join Date
    08-03-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    3

    Unhappy Re: Auto Sort Values From Highest To Lowest Based Off Of Value

    Quote Originally Posted by Bob Phillips View Post
    How about this?
    Hey thanks! It works. I don't wanna be a real pain but could you perhaps explain to me how each part works?i'm trying to copy it to another workbook i created but somehow the formula no longer works.

+ Reply to Thread

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