Consulting

Results 1 to 3 of 3

Thread: Ranking and declaring winner and runner up

  1. 11-11-2014, 07:30 AM #1
    gary2014
    gary2014 is offline
    VBAX Regular
    Joined
    Sep 2014
    Posts
    20
    Location

    Arrow Ranking and declaring winner and runner up

    Winner & Runner.xlsxWinner & Runner.xlsx

    Hi team,

    I would like to determine only "Winner" & and "Runner Up" from a points table.

    I have attached file for your reference.

    Please help!!!
    Reply With Quote Reply With Quote
  2. 11-11-2014, 01:59 PM #2
    Aussiebear
    Aussiebear is offline
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,064
    Location
    Create a helper column in Column I, then starting at cell I5 enter the following formula and drag down =Rank(H5,$H$5:$H$9,1). As the points compile throughout the season the relative placings will change.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link
    Reply With Quote Reply With Quote
  3. 11-11-2014, 05:23 PM #3
    gary2014
    gary2014 is offline
    VBAX Regular
    Joined
    Sep 2014
    Posts
    20
    Location
    Hi,

    Thank you for kind reply.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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