Sorting Question

[apearce]

I have a easy question, I want to sort a list of numbers, but only by the last two digits? Is there a way to do this, when I got to sort I have the normal options.

 

[Gerald Higgins]

You'll need to set up another column, I think, which captures the last two digits.
You can do it like this -

=a1-rounddown(a1,-2)

Then sort on your new column.

 

[MandelBrah]

I don't think you would want to round these numbers. You might try something like this:

=VALUE(RIGHT(TEXT(D1,0),2))

 

[MandelBrah]

.

 

[MandelBrah]

I don't think you would want to round these numbers. You might try something like this:

=VALUE(RIGHT(TEXT(D1,0),2))

 

[MandelBrah]

I don't think you would want to round these numbers. You might try something like this:

=VALUE(RIGHT(TEXT(D1,0),2))

 

[MandelBrah]

I don't think you would want to round these numbers. You might try something like this:

=VALUE(RIGHT(TEXT(D1,0),2))

 

[MandelBrah]

Sorry - I was having trouble submitting....Is there any way I can erase all of those posts?

 

[Gerald Higgins]

Why not round them ? This will work fine (as long as none of the numbers are negative).