+ Reply to Thread
Results 1 to 2 of 2

Assort person by lap time

  1. 01-23-2019, 02:36 PM #1
    brian461
    brian461 is offline
    Registered User
    Join Date
    01-23-2019
    Location
    USA
    MS-Off Ver
    windows 7
    Posts
    1

    Assort person by lap time

    Hello,

    I am trying to create a spreadsheet that will assort a person based off there laps completed & time it took.

    What I am looking to do is have:
    Qual 1 ran, there is a time
    Qual 2 ran, there is a time
    Qual 3 ran, there is a time

    I would like to take the fastest of that persons time and laps and place him in order based off of his best qual run.

    Qual 1
    Joe 1 FR Pro 13 07:38.9
    Joe 2 SE Pro 12 07:07.5
    Joe 3 CA Pro 12 07:09.4
    Joe 4 US Pro 12 07:13.0

    Qual 2
    Joe 1 SE Pro 12 07:05.8
    Joe 2 US Pro 12 07:17.2
    Joe 3 SE Pro 12 07:25.4
    Joe 4 KR Pro 12 07:29.8

    Qual 3
    Joe 1 FR Pro 13 07:33.9
    Joe 2 SE Pro 12 07:02.2
    Joe 3 CA Pro 12 07:11.7
    Joe 4 US Pro 12 07:13.0

    Then place that person in the correct order on a results page.

    Thanks
    Reply With QuoteRegister To Reply
  2. 01-24-2019, 12:54 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Assort person by lap time

    This sounds like something which, if the data are correctly organized, can be done with pivot tables. However without a spreadsheet and a look at the way the data are organized, we can't do much more at this time.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    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. [SOLVED] Group values of each person - Time avaiable vs Time assigned the task
    By matinha052 in forum Excel General
    Replies: 8
    Last Post: 10-26-2016, 07:19 AM
  2. Match Time in and Time out by Person, then Add for Hours
    By ms.mount in forum Excel General
    Replies: 10
    Last Post: 05-15-2014, 02:37 PM
  3. VBA to convert person-to-event into person-person
    By LuckyStrike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 02:34 PM
  4. Transpose/Pivot multiple rows per person into 1 row per person with fixed columns
    By MaestroEnrique in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2013, 06:35 AM
  5. [SOLVED] Return Call time for each person less or equal than Break time
    By amitav in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-24-2012, 11:26 AM
  6. more than 1 person at a time
    By jimmisavage in forum Excel General
    Replies: 1
    Last Post: 05-01-2007, 10:19 AM
  7. linking cells and assort decending
    By Cindy Morgan in forum Excel General
    Replies: 0
    Last Post: 07-07-2005, 08:05 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