Sort text and number values in matrix

[diana66]

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!

[Anonymous · Accepted solution]

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.

[diana66]

Hi @Anonymous ,

Thank you!