# Help with Query and ArrayFormula

**URL:** <https://community.glideapps.com/t/help-with-query-and-arrayformula/3091>\
**Category:** Ask for Help\
**Created:** [December 23, 2019, 6:30am UTC](https://community.glideapps.com/t/help-with-query-and-arrayformula/3091 "2019-12-23T06:30:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jake\_z](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@jake\_z](https://community.glideapps.com/u/jake_z)\
**Post date:** [December 23, 2019, 6:30am UTC](https://community.glideapps.com/t/help-with-query-and-arrayformula/3091/1 "2019-12-23T06:30:54Z")

</div>

Spreadsheet setup: [Example Glide - Google Sheets](https://docs.google.com/spreadsheets/d/1vTMjyKeoCqCWudxqWmOAPmCHivFQuFDE7BSpz4lfurg/edit?usp=sharing)

I am trying to build an app which has employee profiles, skills with different hourly $ values, and keeps track of which employees have which skills. I want to show an employee’s highest value skill on their profile page. I have added 2 columns on my Employees tab of the sheet above, to populate the name of their most valuable skill and the rate. I know I need to do this using ArrayFormula since I need the formula to auto populate the entire column as the database grows, but am running into trouble since you can’t use Query inside an ArrayFormula. Can anyone advise on a workaround? I’ve been trying various approaches including SORTN to get the top skill sorted by the price but doesn’t seem to work right in arrayformula either ☹

---

<div class="post-metadata">

**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:** [January 7, 2020, 1:33am UTC](https://community.glideapps.com/t/help-with-query-and-arrayformula/3091/2 "2020-01-07T01:33:34Z")

</div>

Check out this sheet. I put in descriptions of what I did. Let me know if you have any questions.

> **[Copy of Example Glide](https://docs.google.com/spreadsheets/d/1AHOw3XKA0viVWop9uWpM477dqWbYpnbGRtzoEvHPqy0/edit?usp=sharing)**
>
> Skills
> 
> Skill Name,Hourly Price
> Development,$100.00
> Marketing,$80.00
> Design,$90.00
> Support,$75.00