# Classement

**URL:** <https://community.glideapps.com/t/classement/68961>\
**Category:** Ask for Help\
**Created:** [December 23, 2023, 12:57pm UTC](https://community.glideapps.com/t/classement/68961 "2023-12-23T12:57:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![RagnarLagerta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ragnarlagerta/32/40388_2.png) [@RagnarLagerta](https://community.glideapps.com/u/RagnarLagerta)\
**Post date:** [December 23, 2023, 12:57pm UTC](https://community.glideapps.com/t/classement/68961/1 "2023-12-23T12:57:27Z")

</div>

Bonjour,  
J’ai une colonne avec des athlètes, puis 10 colonnes avec des performances. Je souhaite récupérer pour chaque athlète la 2ème meilleure performance, la 3ème pour effectuer ensuite des calcul. Quelle est la meilleur méthode? La colonne rollup permet de récupérer uniquement la meilleure performance (maximum).  
Merci beaucoup,  
Stéphane

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 23, 2023, 1:13pm UTC](https://community.glideapps.com/t/classement/68961/2 "2023-12-23T13:13:03Z")

</div>

Perhaps something like the following:

- Use a Make Array column to create an array from your 10 performance columns
- A Sort Array column to sort the array (this will only work if all of your 10 columns are number types)
- Two Single value columns: one to pick 1 from start of the array, and the other to pick 2 from the start of the array

---

<div class="post-metadata">

**Author:** ![RagnarLagerta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ragnarlagerta/32/40388_2.png) [@RagnarLagerta](https://community.glideapps.com/u/RagnarLagerta)\
**Post date:** [December 23, 2023, 1:30pm UTC](https://community.glideapps.com/t/classement/68961/3 "2023-12-23T13:30:15Z")

</div>

👍 merci beaucoup.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 30, 2023, 1:31pm UTC](https://community.glideapps.com/t/classement/68961/4 "2023-12-30T13:31:05Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.