# Top Five Sellers **URL:** \ **Category:** Ask for Help\ **Created:** [March 9, 2022, 6:51am UTC](https://community.glideapps.com/t/top-five-sellers/39416 "2022-03-09T06:51:59Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [March 9, 2022, 6:51am UTC](https://community.glideapps.com/t/top-five-sellers/39416/1 "2022-03-09T06:51:59Z")
In this column all employee sales for 2021, divided into four categories (Q1, Q2, Q4, Q4) Can I have Top Five Sellers for each quarter? . ![لقطة الشاشة 2022-03-09 094451](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a4f7baf5611b256af380a3fdcf641609227b36f6.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 9, 2022, 7:03am UTC](https://community.glideapps.com/t/top-five-sellers/39416/2 "2022-03-09T07:03:42Z")
yes, extract Q1…4 to separate columns, sort by amount, and filter by row less than 6 ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [March 9, 2022, 8:50am UTC](https://community.glideapps.com/t/top-five-sellers/39416/3 "2022-03-09T08:50:02Z")
Required as follows: Add a new column, next to the first seller appears “first place” and next to the second seller the “second place” … ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 9, 2022, 4:04pm UTC](https://community.glideapps.com/t/top-five-sellers/39416/4 "2022-03-09T16:04:49Z")
I don’t understand what you mean… but if you want to have a sorted column, this can be done only in google sheets using few filter formulas or script… in Glide you can achieve that using few if else columns to extract values and then filter 4 inline lists in app UI, but it won’t be a single column… the easiest way in glide… simply filter your column for condition if including Q1, then sort by amount, display only 5 results… repeat list for each Q ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 9, 2022, 4:12pm UTC](https://community.glideapps.com/t/top-five-sellers/39416/5 "2022-03-09T16:12:04Z")
as long as you do what Uzo said above, and then sort the list from largest to smallest, you’re done. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 9, 2022, 4:26pm UTC](https://community.glideapps.com/t/top-five-sellers/39416/6 "2022-03-09T16:26:42Z")
Hola… Do you want to have your Top 5 List in an only one Inline List (showing 20 rows)? Or will you be happy using 4 InLine List instead? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 10, 2022, 12:05am UTC](https://community.glideapps.com/t/top-five-sellers/39416/7 "2022-03-10T00:05:30Z")
If you need this calculated only within Glide, then probably it needs a few columns: - Relation and lookup to get an array of only numbers of the same quarter. - Experimental code column to rank the current row’s number against the set of numbers returned via the lookup. - If Then Else column to return the final ranking text (i.e first place, second place, etc.) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 10, 2022, 3:20am UTC](https://community.glideapps.com/t/top-five-sellers/39416/8 "2022-03-10T03:20:24Z")
Ya, check this out: [🥇🥈🥉 Convert Number Score to Rankings in Glide!](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103) ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [March 10, 2022, 7:45am UTC](https://community.glideapps.com/t/top-five-sellers/39416/9 "2022-03-10T07:45:25Z")
Yes, that’s exactly what I meant. Thanks ---
**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:** [March 11, 2022, 7:45am UTC](https://community.glideapps.com/t/top-five-sellers/39416/10 "2022-03-11T07:45:43Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.