# Determine second position
**URL:** https://community.glideapps.com/t/determine-second-position/19269
**Category:** Ask for Help
**Created:** [December 2, 2020, 12:42pm UTC](https://community.glideapps.com/t/determine-second-position/19269 "2020-12-02T12:42:13Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [December 2, 2020, 12:42pm UTC](https://community.glideapps.com/t/determine-second-position/19269/1 "2020-12-02T12:42:13Z")
hi,
I have a use case where participants will get rewards points based on their quiz result. In the data editor I can do a roll up and get the maximum to determine the leader (winner).
How can I determine the second and third position in data editor. I know in the inline list I can display with sorting but this is not useful for my usage.
Appreciate suggestions.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 2, 2020, 12:52pm UTC](https://community.glideapps.com/t/determine-second-position/19269/2 "2020-12-02T12:52:47Z")
If you have the results in the Sheets then you can use this.
> **[RANK - Docs Editors Help](https://support.google.com/docs/answer/3094098?hl=en)**
---
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [December 2, 2020, 1:18pm UTC](https://community.glideapps.com/t/determine-second-position/19269/3 "2020-12-02T13:18:23Z")
I did calculations in Glide Editor
---
### Author:  [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)
#### Post date: [December 2, 2020, 6:34pm UTC](https://community.glideapps.com/t/determine-second-position/19269/4 "2020-12-02T18:34:25Z")
Is there much difference between the maximum and minimum?
---
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [December 3, 2020, 12:14am UTC](https://community.glideapps.com/t/determine-second-position/19269/5 "2020-12-03T00:14:37Z")
It is a quiz, so the differences will depend on response. however, the range is between 1 to 20.
---
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [December 3, 2020, 12:55am UTC](https://community.glideapps.com/t/determine-second-position/19269/6 "2020-12-03T00:55:31Z")
Maybe the best is still to bring the calculated data back into Googlesheets
Is there a way to write from the data editor to a column in sheets?
Thank you.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [December 3, 2020, 2:13am UTC](https://community.glideapps.com/t/determine-second-position/19269/7 "2020-12-03T02:13:04Z")
Here I’m thinking fast…
1- Find the maximum value (winner) using a Rollup
2- Subtract this max value to other values and look for lowest result \>0 now, it is your 2nd place
3- Subtract the lowest value \>0 belonging to step 2 to other values and look for lowest result \>0 again, you will have the 3rd place.
Of course, you will have to use new columns to Rollup and If-Else-Then operations.
I hope it helps you!
Saludos @Mns_Glide
---
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [December 3, 2020, 6:50am UTC](https://community.glideapps.com/t/determine-second-position/19269/8 "2020-12-03T06:50:49Z")
got it working @gvalero
thank you so much.
---
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [December 7, 2020, 11:01pm UTC](https://community.glideapps.com/t/determine-second-position/19269/9 "2020-12-07T23:01:21Z")
Hi,
In continuation with this question. Now I have a situation where there can be many people with the same results or points and hence we will have many people showing up in first place.
I would like sort out where we factor in the timing…so first one to come in highest points in the fastest time will be winner…then all the rest will push to second and third…so basically even if we have 5 people with same highest points, only the fastest time will receive the honor of being first, second and third…
Suggestions please.
Thank you.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 8, 2020, 12:35am UTC](https://community.glideapps.com/t/determine-second-position/19269/10 "2020-12-08T00:35:29Z")
I think this is getting a bit complex to make workarounds in Glide as we don’t have a native “rollup for ranking” as you have seen. If you’re willing to bring the data back to the Sheet, then I believe you can use SORT function to do that.
---
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [December 8, 2020, 1:10am UTC](https://community.glideapps.com/t/determine-second-position/19269/11 "2020-12-08T01:10:40Z")
Indeed it is. just sorting out the three winners required a lot of logic in glide. hopefully these formulas will be available soon in glide.