I’m pretty new on airtable and I have a problem I can’t solve.
I have data for swimmers in a table:
Race - Time - stroke amount - swimmer
50free - 27.01 - 28 - Mike
50free - 28.09 - 30 - Steve
50free - 26.50 - 27 - Mike
50free - 29.10 - 32 - Steve
I need to find the best time, and for each best time of each swimmer, find the correspondant stroke amount.
Actually it’s easy to find the best time for each swimmer with a rollup function (MIN(Time)), but I’m not able to link with the according strokes…
Thanks for your help