# Sorting data by Person
**URL:** https://community.glideapps.com/t/sorting-data-by-person/10654
**Category:** Feature Requests
**Created:** [June 10, 2020, 11:19pm UTC](https://community.glideapps.com/t/sorting-data-by-person/10654 "2020-06-10T23:19:15Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Gera\_Yeremin](https://community.glideapps.com/u/Gera_Yeremin)
#### Post date: [June 10, 2020, 11:19pm UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/1 "2020-06-10T23:19:15Z")
Hello, my fellow Glide wizards,
I am working on a glide app and want to sort some data related to a person about the feedback they are getting.
I made a video explaining what I mean:
[http://somup.com/cY160oQ27H](http://somup.com/cY160oQ27H)
Thanks for all your help.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 10, 2020, 11:40pm UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/2 "2020-06-10T23:40:04Z")
Hi Gera,
Related to what we discussed on another thread, I want to implement a REGEXEXTRACT solution to label your comments first to make the system more scalable. I am thinking of doing relations/row owner to solve your problem here, and I will take time to look at it later.
Is this the same sheet you shared to me the other day?
---
### Author:  [@Gera\_Yeremin](https://community.glideapps.com/u/Gera_Yeremin)
#### Post date: [June 12, 2020, 1:24am UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/3 "2020-06-12T01:24:53Z")
I am open to ideas. Yes its all in that same sheet. The feedback is in “Feedback”. “Reviews” is going to get filled from another source.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 12, 2020, 1:25am UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/4 "2020-06-12T01:25:44Z")
I’ll take a look this weekend and get back to you.
---
### Author:  [@Gera\_Yeremin](https://community.glideapps.com/u/Gera_Yeremin)
#### Post date: [June 12, 2020, 7:58pm UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/5 "2020-06-12T19:58:05Z")
Awesome! Thanks dude.
---
### Author:  [@Glider](https://community.glideapps.com/u/Glider)
#### Post date: [June 12, 2020, 9:38pm UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/6 "2020-06-12T21:38:47Z")
I think that has to do with user specific columns
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 13, 2020, 1:24am UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/7 "2020-06-13T01:24:40Z")
Hi Gera,
Going back to this now.
I have created 2 columns inside your Feedbacks and Reviews sheet, which contains the following ARRAYFORMULA.
```
=ARRAYFORMULA(PROPER(IFNA(REGEXEXTRACT(LOWER(D2:D), LOWER(TEXTJOIN("|", 1,Agents!A2:A))))))
```
This will extract all the matching names with the data in your agent names column in the Agents sheet. You should see it work in your data now.
The thing you want: sorting data by person, can probably be done with a relation in the Agents sheet, matching all names in the Agents sheet to all the names in the Agent Find Test column I just created, return multiple matches and try to make a chart to see if it works.
Tell me if I can help more.
---
### Author:  [@Gera\_Yeremin](https://community.glideapps.com/u/Gera_Yeremin)
#### Post date: [June 13, 2020, 3:36am UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/8 "2020-06-13T03:36:58Z")
This is super helpful! How are you coming up with these formulas? Is there a good cookbook I can review?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 13, 2020, 3:38am UTC](https://community.glideapps.com/t/sorting-data-by-person/10654/9 "2020-06-13T03:38:48Z")
Not really a cookbook, but you can start learning arrayformula from here.
> [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727):
>
> Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job.
>
> > **1/ Definition**
> >
> > Arrayformula is defined as “a range, mathematical expression using one cell range …
The rest is just based on the situation, really. If you need me just send me a message.