Sorting in Excel
 

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.

Sorting in Excel
 

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.

"Wells Co Audiotor''s Office" wrote:

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.

Sorting in Excel
 

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.
--
Richard

Search the web and raise money for charity at http://www.everyclick.com/


"Wells Co Audiotor''s Office" wrote:

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.

Sorting in Excel
 

Wells Co Audiotor''s Office wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1