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
Multiple Sorts with Date Ask for Help	3	591	September 20, 2019
Help With Sorting Please Ask for Help	9	226	September 14, 2020
Sort an array by the original column order Ask for Help	4	485	July 26, 2020
Sorting data by Person Feature Requests	8	754	June 13, 2020
Concatenate, format and display Ask for Help	6	1980	July 29, 2020

Can you sort by two columns?

Related topics