Sorting in Excel..

M

maxmouse

Sorting a long list of numbers, the list goes so far,
then starts over from the lowest number to complete all
the numbers in it. How can I get the list to sort
completely from 111111 to 511111 without going up that
high with part of the numbers and then starting over at,
say, 111223 and sorting to 500088?
 
J

Jay

Sorting a long list of numbers, the list goes so far,
then starts over from the lowest number to complete all
the numbers in it. How can I get the list to sort
completely from 111111 to 511111 without going up that
high with part of the numbers and then starting over at,
say, 111223 and sorting to 500088?
Click to expand...

It sounds like you want to split the rows into two batches, with the second
batch coming after the first one in sort order.

So you can use an extra "helper" column that identifies the batch. If the
part numbers are in column A and the helper column is H, put in H1 a
formula like:
=IF(AND(A1>111222,A1<500089),2,1)
and extend down for as many rows as you need.

Then "Sort by column H then by column A".
 
M

Myrna Larson

If you mean you end up with, essentially, two lists, it probably means that
the data in the 2nd portion is text instead of numbers.
 
Top