Google Sheets - QueryByName Named Function

11 months ago
16
google sheets query

Use column names in your QUERY()

Target Experience Level: Intermediate
Topic Level: Intermediate to Advanced

Benefits
Makes using QUERY() more intuitive
If columns change your function will continue to work

References
https://www.benlcollins.com/
A free site with plenty of free Google Sheets and app script tips and guides. Sign up and get weekly tips delivered to your inbox.

Articles from Ben Collins for Named Functions:
SCAN Function in Google Sheets - LAMDA Helper Function
https://www.benlcollins.com/spreadsheets/scan-function/
Lambda Functions 10-Day Challenge
https://courses.benlcollins.com/p/lambdafunctions
QUERY & MYSELECT functions, Select by Column Names (Headers, Labels) - Google Sheets
https://www.youtube.com/watch?v=clq7WlC2whk&list=PLn5v4CFyfaY_gjJ1vl-1rBrV6GQL3lq87&index=3&t=43s
Google Resources
SCAN Function
https://support.google.com/docs/answer/12569094?hl=en
Working Model Showing How to use QueryByName, Named Functions Included (make your own copies if you like)
QueryByName
https://docs.google.com/spreadsheets/d/11AtsQslRDJ6E5TJctFONDyFkQt6NsIYjyrcQLQH2eYs/edit?usp=sharing
Youtube Links
Named Function Tutorial (includes link to Named Function Library)
https://youtu.be/sqdDEms0Ct4

Rumble Links
Named Function Tutorial (includes link to Named Function Library)
https://rumble.com/v25qm9k-introduction-to-google-sheets-named-functions.html

Loading comments...