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	532	September 20, 2019
Sort an array by the original column order Ask for Help	4	437	July 26, 2020
Sorting data by Person Feature Requests	8	711	June 13, 2020
Concatenate, format and display Ask for Help	6	1811	July 29, 2020
Sort rows in sheet Ask for Help	6	267	February 14, 2023

Can you sort by two columns?

Related Topics