Sorting by last 3 digits in cell

B

britten funk

I need to sort columns using the last 3 digits of a number
not the first digits. How do I do this? Thanks for your
help.
 
H

Harry Bo

Hi,

Try adding a helper column (B) and use =RIGHT(A1,3) and fill down, then click any cell within column B and sort.

Harry
 
D

Dave Peterson

I'd use a formula like:

=mod(a1,1000)

To keep them numbers (not text)

Or modify Harry's formula to:

=--RIGHT(A1,3)
 
Top