Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Cyahr12

macrumors newbie
Original poster
Sep 17, 2023
1
0
I'm having trouble in numbers. I'm making a running log so I can keep track of my training. I have a table that has the date, duration, distance, average pace, ect. I have another table that I want to have it automatically find the top 5 fastest times for a certain distance (5K) and pull that entire rows info into the new table. What would be the formula I should use to do that? Attached are screenshots of my tables for reference.
Thanks!


Screenshot 2023-09-17 at 12.06.55 PM.png
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.