I am looking to take some race data that has multiple athlete times from training and extract the fastest time from each individual athlete. with each athletes top time it will then need to be ranked amongst the other athletes best times.
Ideally this would need to be done through an aggregate formula as some of the times potentially could be the same. I would also need to pull the full row of data and put into a new table.
attached is the sample form the first table is the actual times in no particular order (this table would actually be a lot bigger) to the right is hte table that needs to be populated and below is what the actual final results should be.
Bookmarks