+ Reply to Thread
Results 1 to 2 of 2

I need to sort based on a calculated field

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Atlanta, Ga
    MS-Off Ver
    Excel 2003
    Posts
    7

    I need to sort based on a calculated field

    I need to set up a way Auto Sort the data in two small areas on one tab. The sort criteria is located in H3:N15 and separately H20:L30. The sort is based on the "%Participating" column in each small table. Each time the data is updated on two other separate tabs in this workbook these numbers change. I would like to set something up to make sure that this information continuously sorts in a decending order based on the above columns and cells. I hope this makes sense. I'm struggling to get this out as quickly as possible. Please see the attached workbook. If you have any questions please don't hesitate to ask me. I really could use the help. Thanks
    Attached Files Attached Files
    Last edited by r71lima; 07-18-2012 at 09:34 AM. Reason: Clarify need

  2. #2
    Registered User
    Join Date
    07-17-2012
    Location
    Atlanta, Ga
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: I need to sort based on a calculated field

    Instead of sorting by the criteria column with calculated data, how about taking the last comlumn of information which happens to be "Rank" and creating and Rank & Sort instead? What I would like however is to bring the entire chart of information out as resorted. I can then hide the original data so only the resorted information is seen? Any thoughts on this?

+ 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