+ Reply to Thread
Results 1 to 2 of 2

Automatically Calculate Race Places

  1. #1
    Registered User
    Join Date
    04-22-2007
    Posts
    2

    Smile Automatically Calculate Race Places

    I have a sheet with (say) 3 input columns:
    A has times [ 2:04:16 - 2 hours, 4 minutes and 16 seconds]
    B has categories [ OM, OF, JM, JF]
    E has competitor names

    each competitor is allocated a category [ at entry time] and a finish time during an event.

    I have 2 additional columns:
    C = Place in category
    D = Place overall
    I'd like my sheet to be able to automatically calculate both place in category and place overall based on the times input. I figure a button on the sheet would ensure the changes aren't being made each time I enter a new time.

    Any clues how to go about this one?
    cheers
    emmsee

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by emmsee_two
    I have a sheet with (say) 3 input columns:
    A has times [ 2:04:16 - 2 hours, 4 minutes and 16 seconds]
    B has categories [ OM, OF, JM, JF]
    E has competitor names

    each competitor is allocated a category [ at entry time] and a finish time during an event.

    I have 2 additional columns:
    C = Place in category
    D = Place overall
    I'd like my sheet to be able to automatically calculate both place in category and place overall based on the times input. I figure a button on the sheet would ensure the changes aren't being made each time I enter a new time.

    Any clues how to go about this one?
    cheers
    emmsee
    Hi,

    =COUNTA(A$1:A$2000)+2-RANK(A1,A$1:A$2000)-COUNTIF(A$1:A1,A1)

    should go close to Place Overall

    hth
    ---
    Si fractum non sit, noli id reficere.

+ 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