+ Reply to Thread
Results 1 to 8 of 8

Marathon Race Results - Autofill of Placements

  1. 07-02-2015, 11:22 PM #1
    Joseph Wee
    Joseph Wee is offline
    Registered User
    Join Date
    07-22-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    10

    Marathon Race Results - Autofill of Placements

    Hi All,

    I am currently attempting to formulate a spreadsheet whereby I am able to auto-fill the details of the runners in the "All Runners" tab into their appropriate placing in the "Placement" tab.

    Meaning, if a runner is the fastest in timing and belongs to the Men's Open category, his details should be placed in the "Men's Open" section in the "Placement" tab as the 1st Place runner.

    Kindly note that I would have to enter the details of the runners manually in the "All Runners" tab.

    Seeking your help in this, please!
    Joseph
    Attached Files Attached Files
    Last edited by Joseph Wee; 07-03-2015 at 12:53 AM.
    Reply With QuoteRegister To Reply
  2. 07-03-2015, 12:39 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Marathon Race Results - Autofill of Placements

    If you are basing this on the entries in All Runners-column D, you will need to change those entries to real time, not text.

    24m 15s is text, not a number. Because it is not text, it's a bit like asking...is flower faster than tree
    0:24:15 AM is a number, we can use LARGE() or something else to determine the fastest
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 07-03-2015, 12:51 AM #3
    Joseph Wee
    Joseph Wee is offline
    Registered User
    Join Date
    07-22-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Marathon Race Results - Autofill of Placements

    Hi,

    Thanks for the advice!

    I have since edited the document and replaced it with the updated one.

    Looking for any assistance please =D
    Reply With QuoteRegister To Reply
  4. 07-03-2015, 12:57 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Marathon Race Results - Autofill of Placements

    Can you upload your updated file please?
    Reply With QuoteRegister To Reply
  5. 07-03-2015, 02:41 AM #5
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,215

    Re: Marathon Race Results - Autofill of Placements

    See attached. ALL formulae need to be entered with Ctrl+Shift+Enter
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-03-2015, 03:42 AM #6
    Joseph Wee
    Joseph Wee is offline
    Registered User
    Join Date
    07-22-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Marathon Race Results - Autofill of Placements

    Hi John,

    Thanks for the prompt response!

    I would like to clarify on just one thing.

    This formula works only if I enter the timings of the runners in the "All Runners" tab and sort them by the fastest runner as the 1st entry, yep?
    -> Meaning if I were to enter the fastest runner in Row 9 for example, it will not capture the latter as the fastest runner, yep?
    Reply With QuoteRegister To Reply
  7. 07-03-2015, 04:25 AM #7
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,215

    Re: Marathon Race Results - Autofill of Placements

    My mistake .... see new version which allows entry in any order.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 07-03-2015, 05:12 AM #8
    Joseph Wee
    Joseph Wee is offline
    Registered User
    Join Date
    07-22-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Marathon Race Results - Autofill of Placements

    Thanks John! this has been very useful! =)
    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)

Similar Threads

  1. Race Results: Adding points for fastest race lap and fastest qualifying lap to final point
    By Bibly in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2014, 09:43 PM
  2. [SOLVED] Race results
    By akalien in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2012, 10:18 AM
  3. Race Results Spreadsheet
    By kkjellquist in forum Excel General
    Replies: 3
    Last Post: 05-13-2011, 08:35 AM
  4. Sumproduct Formula Calculate Just Like Marathon Race
    By avk in forum Excel General
    Replies: 4
    Last Post: 08-17-2010, 02:36 AM
  5. Race results
    By pobuckley in forum Excel General
    Replies: 2
    Last Post: 08-07-2007, 12:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1