Sort a column by name with query between tabs

Question

I am pulling information from one tab to another and I believe this is why it will not allow me to sort (because it is not sorted in the original tab). The easy solution would be to sort that tab. However, this is not an option. Is there something I can add to my query code to allow it to sort column A by ascending? My query code is here =Query('Tardy Data Sheet'!L17:R, "Select * Where N = '8th'")

Castleman · Answer

Try
=Query('Tardy Data Sheet'!L17:R, "Select * Where N = '8th' Order by A")
OOPS, Didnt notice ColA isn't in your query range... Use A17:R

Sort a column by name with query between tabs

One Answer

Add your own answers!

Ask a Question