Sorting by last 3 digits in cell

  • Thread starter Thread starter britten funk
  • Start date Start date
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.
 
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
 
I'd use a formula like:

=mod(a1,1000)

To keep them numbers (not text)

Or modify Harry's formula to:

=--RIGHT(A1,3)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort a column using the last number in the cell? 2
Excel Sorting 4
sort a cell by last two digits 4
Sorting or Filtering 5
How can I sort a list of numbers by the last 4 digits? 2
News Bank of England considers digital currency 4
I need to rearrange the information in a column. Help? 2
Sort by number only in cell 2

Back
Top