+ Reply to Thread
Results 1 to 7 of 7

Automatically Place Player Based Results & Player Ranking

  1. 02-22-2009, 09:27 PM #1
    Killer17
    Killer17 is offline
    Forum Contributor
    Join Date
    07-16-2008
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    106

    Automatically Place Player Based Results & Player Ranking

    Hey all need some assistants on creating a formula that will automatically place players in the correct position based on the outcome and there rank.

    I have created an example sheet and the results should be in cells E3:E15

    Thanks Ahead
    Attached Files Attached Files
    Last edited by Killer17; 02-25-2009 at 02:13 AM.
    Reply With QuoteRegister To Reply
  2. 02-22-2009, 11:55 PM #2
    Paul
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Automatically Place Player Based Results & Player Ranking

    Seems almost sacrilegious to a March Madness fan. Not supposed to mess with the tree man!
    - Paul

    Click here to read the Forum Rules

    Reply With QuoteRegister To Reply
  3. 02-23-2009, 01:24 AM #3
    Killer17
    Killer17 is offline
    Forum Contributor
    Join Date
    07-16-2008
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    106

    Re: Automatically Place Player Based Results & Player Ranking

    For the recorded it has nothing to do March Madness whatever that is its tournament for a bowling league pins over average.
    Reply With QuoteRegister To Reply
  4. 02-23-2009, 04:45 AM #4
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Automatically Place Player Based Results & Player Ranking

    one way.... albeit not very elegant
    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
  5. 02-23-2009, 08:42 PM #5
    Killer17
    Killer17 is offline
    Forum Contributor
    Join Date
    07-16-2008
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    106

    Re: Automatically Place Player Based Results & Player Ranking

    Hey DonkeyOte thanks for the help

    But it’s not listing the correct people if the correct order if the lowest rank is in the lower group ground.

    Each round has the higher seed facing the lowest rank seed throughout each round.

    See attachment

    Thanks again
    Attached Files Attached Files
    Last edited by Killer17; 02-23-2009 at 08:46 PM.
    Reply With QuoteRegister To Reply
  6. 02-24-2009, 04:28 AM #6
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Automatically Place Player Based Results & Player Ranking

    Unfortunately this was not clear in your prior example.

    See attached:
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 02-25-2009, 02:12 AM #7
    Killer17
    Killer17 is offline
    Forum Contributor
    Join Date
    07-16-2008
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    106

    Re: Automatically Place Player Based Results & Player Ranking

    thank you very much Donkey
    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)

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