Sort particular rows or columns within an array

Sorting rows or columns can be done using either the user interface or formulas.

In this post, I will show you how to sort only selected rows or columns of data using formulas.

Sort Alternate Rows:

=LET(a,B2:G6,s,SEQUENCE(ROWS(a)),T(IF(MOD(s,2),a,SORT(a,s,-1,1))))

Sort Alternate Columns:

=LET(a,B10:F15,s,SEQUENCE(,COLUMNS(a)),T(IF(MOD(s,2),a,SORT(a,s,-1))))