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
Bookmarks