Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sort text and number values in matrix

Hello,

 

I have a matrix in which I have basically number values. I put an if condition, and if it applies, i have inserted a text(ex: "0 LY"). The problem is I want to sort by the values descending, and the text ones should be at the end. When I sort descending by the specific value, the ones with text are first, and I want them to be at the end. How can I do that?

 

Thank you!

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi

    extract only the numerical part in a separate column (that you can hide if you want). Once you have that, select the column and in the ribbon choose "Order by" and select the other column. So your original text column will be sorted using a different column.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

    extract only the numerical part in a separate column (that you can hide if you want). Once you have that, select the column and in the ribbon choose "Order by" and select the other column. So your original text column will be sorted using a different column.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      Thank you!