If you’re new to named ranges, here’s how you create them: Feel free to use the named range “countries” too, which already exists in the template. In this tutorial, I have used a named range to identify the data, which makes it much easier and cleaner to use in the QUERY function.
This is what our starting data looks like: If you want to follow along with the solutions, please make a copy of the Google Sheet template above.
If you right-click the link and open it in an Incognito window you’ll be able to see it. If you can’t access the template, it might be because of your organization’s Google Workspace settings.
Learn more about the QUERY Function in my newest course: The QUERY Function in Google Sheets Google Sheets QUERY Function Templateįeel free to make a copy: File > Make a copy…
