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'")
Google-sheets – Sort a column by name with query between tabs
google sheetsgoogle-sheets-query
Related Topic
- Google-sheets – A formula to copy and past data between sheets as values only
- Google Sheets SORT Formula – How to Handle Null Cells
- Google-sheets – QUERY remove column and column header if blank
- Google-sheets – Checkbox to activate a column in QUERY
- Google Sheets – Dynamically Reference Data from Multiple Tabs and Sort It
- Google Sheets – Generate Column in Query Based on Reference Range Matches
- Google-sheets – How to solve the issue of sorting numbers in 00-00 format
Best 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