Results 1 to 3 of 3

sorting or categorizing "race results" table

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2010
    Location
    Kagasala, Finland
    MS-Off Ver
    Excel 2007
    Posts
    2

    sorting or categorizing "race results" table

    Hi there experts,

    I have been composing a “race timer” sheet with which I could record times in a race where people run/ride/drive multiple laps. As I don´t know too much Visual Basic, I have been using simple lookuptables, pivot tables, IF functions and such.

    I have managed to enter lapping time events (yellow tab) and calculate the final times (blue tab) but I would need help in categorizing the final results in various classes and in the order of quickiest time. Now I have done this with recording a macro to sort a range (green tab). In this I cannot include “automatic” position indices and the different callses are not too well separated from each others. What I would like is something in the last tab. Any advice would be appreciated. I have attached the sheet.

    Thanks Timo
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1