Sort based on criteria

[mesh55]

Hello,

I have thousands of rows of data. I want to sort the rows based on a numeric value. The value to be sorted on will all ways end in zero. How can I sort the a colum so that all the values that end in zero are displayed first then the rest of the values (not ending in zero)

Where:

400405
345902
300000
209844
400000

Becomes:

300000
400000
209844
345902
400405

Thank you,
Ron

[shg]

Add a column that tests whether the last character is zero, and use that as the primary sort key.

[mesh55]

Thank you. How would I use the MOD command to do that?

[shg]

=if(mod(a1,10)=0, 0, 1)