# How to find the highest value in a column - using the data editor **URL:** \ **Category:** Ask for Help\ **Created:** [February 6, 2022, 5:37am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177 "2022-02-06T05:37:46Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [February 6, 2022, 5:37am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/1 "2022-02-06T05:37:46Z")
I have a user specific column with various numbers in it. I need to find the highest number in that column using the data editor? or glide sheet? Please help! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 6, 2022, 5:49am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/2 "2022-02-06T05:49:36Z")
User specific columns are specific to each user. The only way you can view those numbers is to preview the app as each user, or export the data and view all of the values in the exported data. ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [February 6, 2022, 5:54am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/3 "2022-02-06T05:54:36Z")
I don’t actually need to see those numbers. i just need to determine what the highest value for each of a specific users choices are so that i can show them a result based on their choice. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 6, 2022, 5:57am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/4 "2022-02-06T05:57:43Z")
You’ll need to track that somehow outside of a user specific column. Possibly by storing the largest number in a basic column and only replacing it if the next number is larger. ---
**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:** [February 6, 2022, 6:01am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/5 "2022-02-06T06:01:09Z")
If it’s just needed for a specific user - the currently signed in user - then a rollup could be used, yes? ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [February 6, 2022, 6:06am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/6 "2022-02-06T06:06:15Z")
Leet me try that. Thx ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [February 6, 2022, 6:16am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/7 "2022-02-06T06:16:55Z")
Perfect. Used a rollup and theres an option to show the maximum value in a column. All sorted. Been pulling my hair out for hours. Should have come here first.🤪 ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 6, 2022, 9:40am UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/8 "2022-02-06T09:40:37Z")
Hi The icon in your profile photo is good.where you get these type of icons ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [February 6, 2022, 4:42pm UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/9 "2022-02-06T16:42:03Z")
If you’re talking about mine i made it myself, my business avatar😎 Easy to make on keynote or inkscape👍 ---
**Author:** ![fluittsolutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fluittsolutions/32/30155_2.png) [@fluittsolutions](https://community.glideapps.com/u/fluittsolutions)\ **Post date:** [February 7, 2022, 11:19pm UTC](https://community.glideapps.com/t/how-to-find-the-highest-value-in-a-column-using-the-data-editor/38177/10 "2022-02-07T23:19:40Z")
Yes, rollup worked for me in a scenario where I didn’t want to show old calendar dates. Unique events with multiple dates. Rollup to find last date for each event. Make event visible only if “last date” is in the future.