+ Reply to Thread
Results 1 to 2 of 2

How to sort a group of data that are a result of a formula?

  1. 05-15-2009, 05:29 PM #1
    Brand7 is offline
    Registered User
    Join Date
    05-15-2009
    Location
    Brockhall Village, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Exclamation How to sort a group of data that are a result of a formula?

    Can anyone help...

    I have a table that is made up of 14 answers from formulas elsewhere in the sheet.

    It's like this...

    - I input a time manually for 14 footballers...e.g. "91.36" (mins/secs) cells - (F2:F15)

    - I then input the distance they have ran during that match e.g. "9100" (metres) - (H2:H15)

    - Then in cell "I2" i have the equation "=sum(H2/F2)" running in cells (I2:I15). That then gives me the answer i need and all is fine.

    - I then have another table which i have set out in order to sort the 14 footballers in order of who has ran the furthest so written in "J2", i have "=I2".

    - The problem is that when i come to sort the data, it doesn't move, and i think it's because this data hasn't been input and that it's a result of a formula.

    Can anyone help, it would be much appreciated.
    Reply With QuoteRegister To Reply
  2. 05-16-2009, 02:29 AM #2
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to sort a group of data that are a result of a formula?

    Welcome to the Board.

    Please post a sample file with dummy data outlining expected results.

    In short you will want to set your 2nd sheet to use formula to automatically order the data without having to sort sheet 1 ... this can be achieved relatively easily - what should happen when the calculation in I on sheet1 were to return multiple instances of the same result ? What is the deciding factor in terms of rank in these instances... think of it like Goal Difference being the initial decider if Pts are level, then subsequently Goals Scored etc...

    A rough demo is attached based on a generic approach to such a problem, this assumes where mtrs/min result is identical the first differentiating factor is total distance covered (greater = higher rank) - this utilises a helper column (Sheet1!J) - it may be of interest to you ?
    Attached Files Attached Files
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1