How to Sort Rows or Columns in Excel Using Formulas

View profile for Meganathan Elumalai

Data Analyst | Excel Enthusiast | Advanced Excel & Power Query Consultant | Founder at Excel-End ☎️ 9841169759

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)),p,IF(MOD(s,2),a,SORT(a,s,-1,1)),IF(p=0,"",p)) Sort Alternate Columns: =LET(a,B10:F15,s,SEQUENCE(,COLUMNS(a)),p,IF(MOD(s,2),a,SORT(a,s,-1)),IF(p=0,"",p))

  • table

My solution: Sort Alternate Rows: =LET(d,B2:G6,s,SEQUENCE(ROWS(d)),a,IFNA(EXPAND(s,,COLUMNS(d)),s),T(IF(MOD(a,2),d,SORT(d,s,-1,1)))) Sort Alternate Columns: =LET(d,B10:F15,s,SEQUENCE(,COLUMNS(d)),a,IFNA(EXPAND(s,ROWS(d)),s),T(IF(MOD(a,2),d,SORT(d,s,-1)))) U can use T function to replace zero to blank.

To view or add a comment, sign in

Explore content categories