I am working on a spreadsheet that has a list of people, and for each person, they have ten choices that correspond to adjacent columns with artist and song name. The data set to choose from is 1014 songs.
I am trying to import their choices from another sheet using the IMPORTRANGE function as an input to the QUERY function that will list the items in range of descending count of appearance, basically listing the top 10 most popular songs from everybody in the list. For those who think they know what I am doing, it is capturing family votes for the Triple J Hottest 100 of 2022, and ranking the top 10 songs voted for by my family.
The test spreadsheet has the data set up where the query works when I set a data source in QUERY to be cell references, but when I try using IMPORTRANGE to provide the data, it doesn't recognise or allow a reference to any column.
Has anyone had any luck doing this in one function, or do I have to import and reference local cells in two operations?