Forum Discussion

robertsobotka's avatar
robertsobotka
Copper Contributor
May 04, 2022

custom sorting with excel

 

My excel will not sort more than 2 columns.  How can I correct this?

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor

    robertsobotka 

     

    Let's start with a more complete description.

     

    When you say it won't sort more than 2 columns, do you mean

    • if the table (area to be sorted) has three or more columns, only two of them will be sorted?
    • I can only specify two columns as the basis for the sorting, a primary and secondary?
    • something else?

    What version of Excel are you working with? Are you sorting using the SORT function, or the little diamonds at the top row, in the header?

Resources