Sort particular rows or columns within an array
- V E Meganathan
- 11 hours ago
- 1 min read
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))))
Comments