Results 1 to 13 of 13

Create a list of Min values from data table

Threaded View

JO505 Create a list of Min values... 07-05-2013, 12:24 PM
Fotis1991 Re: Create a list of Min... 07-05-2013, 12:47 PM
JO505 Re: Create a list of Min... 07-05-2013, 01:08 PM
Fotis1991 Re: Create a list of Min... 07-05-2013, 01:24 PM
Fotis1991 Re: Create a list of Min... 07-05-2013, 01:41 PM
XOR LX Re: Create a list of Min... 07-05-2013, 01:03 PM
XOR LX Re: Create a list of Min... 07-05-2013, 01:35 PM
JO505 Re: Create a list of Min... 07-05-2013, 02:00 PM
Fotis1991 Re: Create a list of Min... 07-05-2013, 02:18 PM
JO505 Re: Create a list of Min... 07-05-2013, 02:25 PM
JO505 Re: Create a list of Min... 07-05-2013, 03:13 PM
XOR LX Re: Create a list of Min... 07-05-2013, 03:15 PM
Fotis1991 Re: Create a list of Min... 07-08-2013, 02:26 AM
  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Create a list of Min values from data table

    As the title suggests I want to create a list of Lap records from a list of races, listed by year and venue.

    The table Race Data is a list of the raw data that I want to pare down to a list of records for each venue. The times are listed in 2 columns "N & O". One is the time for qualifying and the other is a list of times during the race. The fastest time for a venue of either qualifying or race time is the record. I can figure out how to find the Fastest time (lowest value) for one column but trying to select between 2 columns is giving me a problem.

    I also want to match the fastest time with a Driver (column I) and the year (column C).

    Thanks

    Jim O
    Attached Files Attached Files
    Last edited by JO505; 07-05-2013 at 03:13 PM.

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