first, second and third classified

[francescoj_albini]

I have to calculate the first, second and third classified of a race based on times.  Which function can I use?

Best regards,

francesco

[sergio0592]

Hi,

Can you share a sample?

[francescoj_albini]

I want to know who are the first, second and third who have the lowest time,I don't know what you need more?

I have the fields name, event(race) and time of every athlete

[tresesco]

Try using firstsortedvalue().

Firstsortedvalue(name, time) - first (took least time)

Firstsortedvalue(name, time, 2) - second

...

[francescoj_albini]

sorry, i solved with fisrtsortedvalue

[francescoj_albini]

thx, I had already found this function 2 minutes before I read you