I want to sort a table by two levels, column A and column B. I can only see that you can sort by one column. Am I missing anything or are there any tricks?

As the error says, you have data in the rest of the column, so the arrayformula can’t fill the rest of the column. Delete the data in the column below the row that contains the formula.

Can you sort by two columns?

Ask for Help

ThinhDinh April 23, 2021, 11:57pm 10

You can read more about it here.

Hope it helps.

1 Like

Topic		Replies	Views
Range returning more than one value per row on arrayformula Ask for Help	8	513	October 10, 2019
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help	125	13866	September 9, 2022
How to If-then-else—> array? Report a Bug	9	847	February 7, 2024
Sum formula Ask for Help	9	1895	July 8, 2020
Using Arrayformula or similar with Glideapp form submission Ask for Help	2	512	April 19, 2020

Can you sort by two columns?

Related topics