+ Reply to Thread
Results 1 to 2 of 2

Scoresheet with Equal Ranks - need to identify equal placings separately

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    The Hatch NSW Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Scoresheet with Equal Ranks - need to identify equal placings separately

    Hi all - thank you for accepting my Registration to join your group (this is my first thread)

    I have a fairly complex spreadsheet for scoring a Sporting Championship (pony club).

    Each rider has been allocated a back number (say 1 through to 119) and their names, club and the horse they are competing on is on this table - I have named this range as "riders"

    Each rider when competing has a time listed against their Back No (in their specific age group) and I use a the Rank formula to place them from fastest to slowest. This is great for placing the majority of events as an equal score is ok as the points are divided between them BUT for events where there is a final involved and we need to run off the top four riders and also place 5th & 6th, I need to be able to identify the riders separately and place them on a finals sheet.

    I have attached an abbreviated form of the spreadsheet I have created (removed the kids names for privacy concerns)

    I have used the formula sumif but as you can see in the finals section it adds the two back numbers together and then when the vlookup formula is used it place the last rider in the lists name. Hopefully there are no equals BUT as the scoring is done on the field using tablets/iPads (I upload the spreadsheets to google docs) I won't be out there to correct the equal placings

    I do apologise now if I haven't explained myself clearly.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Scoresheet with Equal Ranks - need to identify equal placings separately

    add the row divided by 1000 to your ranking in column I and use small in your 2nd table
    Attached Files Attached Files
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 11-01-2012, 10:17 AM
  2. When is equal not equal? Answer: In 2010
    By natefarm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 06:21 PM
  3. equal ranks - Rank by second column
    By Bradz85 in forum Excel General
    Replies: 5
    Last Post: 12-24-2009, 06:16 AM
  4. sorting with RANK/VLOOKUP (problem with equal ranks)
    By hip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2006, 02:50 AM
  5. lower and upper case equal on spreadsheet but not equal in VB
    By don in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2005, 09:06 PM

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