I am attempting to display on a weeksheet, the fastest time ran on a given race. I have tried vlookup, and min function, and IF's... obviously I'm stuck.
On the enclosed file you will find that two columns are highlighted. The first is the length of the given race, and is what the cell will be looking for on the main worksheet.
The second column is the time.
On the main page is lists
3.1
6.2
13.1
26.2
What I would like it to do it list the fastest time ran for each distance next to it.
The list is currently short, but will grow very long.
Thanks for taking time to ponder this.
Kent