Sorting in Excel

  • Thread starter Wells Co Audiotor''s Office
  • Start date
W

Wells Co Audiotor''s Office

For Example if I have 5+ numbers
90-08-07-100-006.000-010
90-08-05-300-013.000-006
90-02-21-100-014.000-002
90-03-33-200-048.000-004
90-03-35-500-097.000-021

We are preparing a spreadsheet
then we need to sort it in order
just buy the last 3 digits of each
number. Is this possible with out
sorting by the other numbers?

Thanks for your help.
 
S

Sean Timmons

I would suggest having another column.

So, assuming the numbers are in cells A2 - A6, then in B2, enter
=right(A2,3).

Copy the formula down.

Then, do a sort on column B.
 
R

Rich57

You could write/record a macro to copy the last 3 digits to the beginning of
each number sequence, then do a sort, then strip them out.
 
E

edvwvw via OfficeKB.com

Wells said:
For Example if I have 5+ numbers
90-08-07-100-006.000-010
90-08-05-300-013.000-006
90-02-21-100-014.000-002
90-03-33-200-048.000-004
90-03-35-500-097.000-021

We are preparing a spreadsheet
then we need to sort it in order
just buy the last 3 digits of each
number. Is this possible with out
sorting by the other numbers?

Thanks for your help.


You could use a helper cell, in B1

=(MID(A1,22,3))*1 - then drag down

This presumes that the last 3 digits are always in the same place. The *1 is
to change the result to a number so that it can be sorted.

edvwvw
 

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

Top